?using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Summary description for DeliveredSheetBZ
/// </summary>
public class DeliveredSheetBZ : InventoryListBZ
{
	public DeliveredSheetBZ()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    override public string LabelListName
    {
        get { return "出庫(kù)單管理"; }
    }

    override public string LabelDate
    {
        get { return "出庫(kù)日期"; }
    }

    override public string LabelListNumber
    {
        get { return "出庫(kù)單號(hào)"; }
    }

    override public string ButtonSave
    {
        get { return "保存出庫(kù)單"; }
    }

    override public string ButtonClose
    {
        get { return "關(guān)閉出庫(kù)單"; }
    }

    override public void GetListData(int listid, out DataTable dt, out int warehouseid, out DateTime date, out string listnumber)
    {
        DataTable tbl = new DataTable();

        using (SqlConnection connect = new SqlConnection(PublicDefine.SQLConnectString))
        {
            connect.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = connect;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select warehouseid,createddate,listnumber from tbl_DeliveredSheet where DeliveredSheetID=" + listid.ToString();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(tbl);
            if (0 == tbl.Rows.Count)
            {
                throw new Exception("出庫(kù)單" + listid.ToString() + "不存在！");
            }
            warehouseid = (int)tbl.Rows[0]["WarehouseID"];
            date = (DateTime)tbl.Rows[0]["CreatedDate"];
            listnumber = tbl.Rows[0]["ListNumber"].ToString();
            tbl = new DataTable();
            cmd.CommandText = "Select ProductID,Quantity from tbl_DeliveredSheetDetail where DeliveredSheetID =" + listid.ToString();
            adapter.Fill(tbl);
            if (0 == tbl.Rows.Count)
            {
                throw new Exception("出庫(kù)單" + listid.ToString() + "沒有明細(xì)！");
            }
            // get the details 
            dt = GetEmptyList();
            string code, name, module, color;
            int id;
            decimal quantity;
            for (int i = 0; i < tbl.Rows.Count; i++)
            {
                id = (int)tbl.Rows[i]["ProductID"];
                quantity = (decimal)tbl.Rows[i]["Quantity"];
                GetProductInfo(id, out code, out name, out module, out color);
                DataRow dr = dt.NewRow();
                dr["ProductID"] = id;
                dr["ProductCode"] = code;
                dr["ProductName"] = name;
                dr["ProductModule"] = module;
                dr["ProductColor"] = color;
                dr["Quantity"] = quantity;
                dt.Rows.Add(dr);
            }
            connect.Close();
        }
    }


    override public int AddList(SqlCommand cmd, int warehouseid, DateTime createddate, string listnumber, DataTable dt)
    {
        SqlParameter parameter;
        int deliveredsheetid = 0;
        int productid;
        decimal quantity;
        int deliveredsheetdetailid = 0;

        //1 insert into tbl_warehouselist
        cmd.CommandText = "sp_DeliveredSheet_Add";
        cmd.Parameters.Clear();
        parameter = new SqlParameter("@WarehouseID", warehouseid);
        cmd.Parameters.Add(parameter);
        parameter = new SqlParameter("@CreatedDate", createddate);
        cmd.Parameters.Add(parameter);
        parameter = new SqlParameter("@ListNumber", listnumber);
        cmd.Parameters.Add(parameter);
        parameter = new SqlParameter("@DeliveredSheetID", deliveredsheetid);
        parameter.Direction = ParameterDirection.InputOutput;
        cmd.Parameters.Add(parameter);
        cmd.ExecuteNonQuery();
        deliveredsheetid = (int)cmd.Parameters["@DeliveredSheetID"].Value;
        //insert the detail into tbl_DeliveredSheetdetail
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow dr = dt.Rows[i];
            productid = (int)dr["ProductID"];
            quantity = (decimal)dr["Quantity"];
            cmd.CommandText = "sp_DeliveredSheetDetail_Add";
            cmd.Parameters.Clear();
            parameter = new SqlParameter("@DeliveredSheetID", deliveredsheetid);
            cmd.Parameters.Add(parameter);
            parameter = new SqlParameter("@ProductID", productid);
            cmd.Parameters.Add(parameter);
            parameter = new SqlParameter("@Quantity", quantity);
            cmd.Parameters.Add(parameter);
            parameter = new SqlParameter("@DeliveredSheetDetailID", deliveredsheetdetailid);
            parameter.Direction = ParameterDirection.InputOutput;
            cmd.Parameters.Add(parameter);
            cmd.ExecuteNonQuery();
            deliveredsheetdetailid = (int)cmd.Parameters["@DeliveredSheetDetailID"].Value;
        }
        return deliveredsheetid;
    }

    override public void DeleteList(SqlCommand cmd, int ListID)
    {
        SqlParameter parameter;
        cmd.CommandText = "sp_DeliveredSheet_Delete";
        cmd.Parameters.Clear();
        parameter = new SqlParameter("@DeliveredSheetID", ListID);
        cmd.Parameters.Add(parameter);
        cmd.ExecuteNonQuery();
    }
}