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;
}
