/// <summary>
/// 把gridview中的数据保存到数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void but_Storage_Click(object sender, EventArgs e)
{
//string STID, string STnum, string STCKID, string STGSID,
//string STRKMGID, string STYHMGID, string STKHID, int STquantity,
//string STDW, decimal STDJ, decimal STprice, DateTime STdate,
//string STnote, string STstatus
//"编号""名称""单位""单价""数量""金额""备注"
DataSet myDataSet = (DataSet)Session["myDataSet"];
Control.StorageManage myCSM = new Control.StorageManage();
Control.GoodsManage myGSM = new Control.GoodsManage();
Control.Manager myMG=new Control.Manager ();
string mySTnum = txt_STnum.Text.Trim().Replace("'", "");
string myCKid = ddl_Cangku.SelectedValue;
string myKHid = DDL_GHS.SelectedValue;
decimal mySTPrice = decimal.Parse(txt_price.Text.Trim().Replace("'", ""));
string myRKMGid = ddl_RKY.SelectedValue;
string myYHMGid = ddl_YHY.SelectedValue;
int myCount = myDataSet.Tables["myTB"].Rows.Count;
DAO.Storage[] myStorages = new DAO.Storage[myCount];
//把DataSet中的记录实例化，存入数组
for (int i = 0; i < myCount; i++)
{
string myGSid = myGSM.SelectGS("", myDataSet.Tables["myTB"].Rows[i]["名称"].ToString(), "", "", "").Tables[0].Rows[0]["gs_id"].ToString();
int mySTquantity = int.Parse(myDataSet.Tables["myTB"].Rows[i]["数量"].ToString());
string mySTdw = myDataSet.Tables["myTB"].Rows[i]["单位"].ToString();
decimal mySTdj = decimal.Parse(myDataSet.Tables["myTB"].Rows[i]["单价"].ToString());
string mySTnote = myDataSet.Tables["myTB"].Rows[i]["备注"].ToString();
DAO.Storage myStorage = myCSM.SetModel("", mySTnum, myCKid, myGSid, myRKMGid, myYHMGid, myKHid, mySTquantity, mySTdw, mySTdj, mySTPrice, DateTime.Now, mySTnote, "");
myStorages[i] = myStorage;
}
//
Page.RegisterStartupScript("js", "<script>alert('" + myCSM.AddST_More_bool(myStorages) + "');window.location.href='StorageAdd.aspx';</script>");
}
/// <summary>
/// 设置入库单对象实例
/// </summary>
/// <param name="STID">ID</param>
/// <param name="STnum">入库单号</param>
/// <param name="STCKID">仓库ID</param>
/// <param name="STGSID">货物ID</param>
/// <param name="STRKMGID">入库员ID</param>
/// <param name="STYHMGID">验货员ID</param>
/// <param name="STKHID">供货商ID</param>
/// <param name="STquantity">数量</param>
/// <param name="STDW">单位</param>
/// <param name="STDJ">单价</param>
/// <param name="STprice">总价格</param>
/// <param name="STdate">入库日期</param>
/// <param name="STnote">备注</param>
/// /// <param name="STstatus">状态</param>
/// <returns></returns>
public DAO.Storage SetModel(string STID, string STnum, string STCKID, string STGSID, string STRKMGID, string STYHMGID, string STKHID, int STquantity, string STDW, decimal STDJ, decimal STprice, DateTime STdate, string STnote, string STstatus)
{
DAO.Storage myModel = new DAO.Storage();
myModel.STid = STID;
myModel.STnum = STnum;
myModel.STckid = STCKID;
myModel.STgsid = STGSID;
myModel.STRK_MGid = STRKMGID;
myModel.STYH_MGid = STYHMGID;
myModel.STKHid = STKHID;
myModel.STquantity = STquantity;
myModel.STDW = STDW;
myModel.STDJ = STDJ;
myModel.STprice = STprice;
myModel.STdate = STdate;
myModel.STnote = STnote;
myModel.STstatus = STstatus;
return myModel;
}
/// <summary>
/// 获取入库单对象实例
/// </summary>
/// <param name="STID"></param>
/// <returns></returns>
public DAO.Storage GetModel(string STID)
{
DataSet myData = DBUtility.DBHelperSQL.Query("select * from db_Storage where ST_id=" + STID);
DAO.Storage myModel = new DAO.Storage();
myModel.STid = STID;
myModel.STnum = myData.Tables[0].Rows[0]["st_num"].ToString().Trim();
myModel.STckid = myData.Tables[0].Rows[0]["st_ckid"].ToString().Trim();
myModel.STgsid = myData.Tables[0].Rows[0]["ST_gsid"].ToString().Trim();
myModel.STRK_MGid = myData.Tables[0].Rows[0]["st_rk_mgid"].ToString().Trim();
myModel.STYH_MGid = myData.Tables[0].Rows[0]["st_yh_mgid"].ToString().Trim();
myModel.STKHid = myData.Tables[0].Rows[0]["st_khid"].ToString().Trim();
myModel.STquantity = int.Parse(myData.Tables[0].Rows[0]["st_quantity"].ToString().Trim());
myModel.STDW = myData.Tables[0].Rows[0]["st_dw"].ToString().Trim();
myModel.STDJ = decimal.Parse(myData.Tables[0].Rows[0]["st_dj"].ToString().Trim());
myModel.STprice = decimal.Parse(myData.Tables[0].Rows[0]["st_price"].ToString().Trim());
myModel.STdate = DateTime.Parse(myData.Tables[0].Rows[0]["st_date"].ToString().Trim());
myModel.STnote = myData.Tables[0].Rows[0]["st_note"].ToString().Trim();
myModel.STstatus = myData.Tables[0].Rows[0]["st_status"].ToString().Trim();
return myModel;
}
