public HttpResponseBase InsertIialg() { string json = string.Empty; IialgQuery iagQuery = new IialgQuery(); Iinvd invd = new Iinvd(); int result = 0; try { invd.row_id = Convert.ToInt32(Request.Params["row_id"]);//行號碼 _iinvd = new IinvdMgr(mySqlConnectionString); DataTable dt = _iinvd.GetRowMsg(invd);//首先根據row_id 獲取到製造日期和有效日期 iagQuery.made_dt = Convert.ToDateTime(dt.Rows[0]["made_date"]);//製造日期 iagQuery.cde_dt = Convert.ToDateTime(dt.Rows[0]["cde_dt"]);//有效日期 if (!string.IsNullOrEmpty(Request.Params["item_id"]))//商品細項編號 { iagQuery.item_id = Convert.ToUInt32(Request.Params["item_id"]); } if (!string.IsNullOrEmpty(Request.Params["po_id"])) { iagQuery.po_id = Request.Params["po_id"];//採購單編號 } if (!string.IsNullOrEmpty(Request.Params["iarc_id"])) { iagQuery.iarc_id = Request.Params["iarc_id"];//庫調原因 } if (!string.IsNullOrEmpty(Request.Params["ktloc_id"])) { iagQuery.loc_id = Request.Params["ktloc_id"].ToUpper();//料位編號 } if (!string.IsNullOrEmpty(Request.Params["doc_no"])) { iagQuery.doc_no = Request.Params["doc_no"];//庫調單號 } if (!string.IsNullOrEmpty(Request.Params["remarks"])) { iagQuery.remarks = Request.Params["remarks"];//庫調單號 } if (!string.IsNullOrEmpty(Request.Params["made_date"]))//創建時間 { iagQuery.made_dt = Convert.ToDateTime(Request.Params["made_date"]); } if (!string.IsNullOrEmpty(Request.Params["end_date"]))//有效日期 { iagQuery.cde_dt = Convert.ToDateTime(Request.Params["end_date"]);//庫調單號 } int kucuncount = Convert.ToInt32(Request.Params["benginnumber"]);//庫存數量 int tiaozhengcount = Convert.ToInt32(Request.Params["changenumber"]);//調整數量 int kucuntype = Convert.ToInt32(Request.Params["kutiaotype"]);//庫存類型 if (kucuntype == 1) { iagQuery.adj_qty = tiaozhengcount; //調整庫存 } else { iagQuery.adj_qty = tiaozhengcount * (-1);//調整庫存 } iagQuery.qty_o = kucuncount;//原來庫存 iagQuery.create_dtim = DateTime.Now; iagQuery.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; if (!string.IsNullOrEmpty(Request.Params["ktloc_id"])) { iagQuery.loc_id = Request.Params["ktloc_id"]; } if (!string.IsNullOrEmpty(Request.Params["doc_no"])) { iagQuery.doc_no = Request.Params["doc_no"]; } _iagMgr = new IialgMgr(mySqlConnectionString); result = _iagMgr.insertiialg(iagQuery); if (result > 0) { json = "{success:true}";//返回json數據 } else { json = "{success:false}";//返回json數據 } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }