public HttpResponseBase aboutmadetime() { string jsonStr = string.Empty; int result = 0; DataTable dt = new DataTable(); try { int userId = (Session["caller"] as Caller).user_id; DateTime nowtimes = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); int type_id = 0;//類型 int days = 0; int row_id = int.Parse(Request.Params["row_id"]); string cde_dtormade_dt = Request.Params["cde_dtormade_dt"]; string y_cde_dtormade_dt = string.Empty; if (!string.IsNullOrEmpty(Request.Params["y_cde_dtormade_dt"])) { y_cde_dtormade_dt = Request.Params["y_cde_dtormade_dt"];//原來的日期 } if (!string.IsNullOrEmpty(Request.Params["type_id"])) { type_id = Convert.ToInt32(Request.Params["type_id"]); } if (!string.IsNullOrEmpty(Request.Params["datetimeday"])) { days = Convert.ToInt32(Request.Params["datetimeday"]); } IinvdQuery invd = new IinvdQuery(); IinvdQuery newinvd = new IinvdQuery(); IialgQuery ialg = new IialgQuery(); newinvd.change_user = userId; newinvd.change_dtim = DateTime.Now; if (!string.IsNullOrEmpty(Request.Params["sloc_id"])) { invd.plas_loc_id = Convert.ToString(Request.Params["sloc_id"]).ToUpper(); ialg.loc_id = invd.plas_loc_id; } if (!string.IsNullOrEmpty(Request.Params["prod_id"])) { invd.item_id = Convert.ToUInt32(Request.Params["prod_id"]); ialg.item_id = invd.item_id; } if (!string.IsNullOrEmpty(Request.Params["prod_qtys"])) { invd.prod_qty = Convert.ToInt32(Request.Params["prod_qtys"]); ialg.qty_o = invd.prod_qty; } if (!string.IsNullOrEmpty(Request.Params["remarks"])) { invd.remarks = Request.Params["remarks"]; ialg.remarks = invd.remarks; } if (!string.IsNullOrEmpty(Request.Params["po_id"])) { ialg.po_id = Request.Params["po_id"]; } if (!string.IsNullOrEmpty(Request.Params["iarc_id"])) { ialg.iarc_id = Request.Params["iarc_id"]; } if (!string.IsNullOrEmpty(Request.Params["doc_no"])) { ialg.doc_no = Request.Params["doc_no"]; } ialg.create_user = userId; invd.change_user = userId; ialg.create_dtim = DateTime.Now; invd.change_dtim = DateTime.Now; invd.row_id = row_id; if (type_id == 1)//表示編輯的是製造日期 { invd.made_date = DateTime.Parse(cde_dtormade_dt); invd.cde_dt = invd.made_date.AddDays(days);//有效日期 if (invd.made_date > nowtimes)//已經過期 { jsonStr = "{success:true,msg:1}";//1表示有效日期不能小於當前日期 } else { _ipalet = new PalletMoveMgr(mySqlConnectionString); _iialgMgr = new IialgMgr(mySqlConnectionString); result = _ipalet.selectcount(invd); #region 往iialg表中插入時間修改記錄 ialg.made_dt = DateTime.Parse(y_cde_dtormade_dt);//原來的日期 ialg.c_made_dt = DateTime.Parse(cde_dtormade_dt);//改后的日期 ialg.cde_dt = DateTime.Parse(y_cde_dtormade_dt).AddDays(days);//原來的有效日期 ialg.c_cde_dt = DateTime.Parse(cde_dtormade_dt).AddDays(days);//修改后的有效日期 ialg.adj_qty = 0; if (string.IsNullOrEmpty(ialg.iarc_id)) { ialg.iarc_id = "PC"; } _iialgMgr.insertiialg(ialg);//往iialg中插入數據,用來記錄數據 #endregion if (result > 0)//大於0表示裡面存在一樣子的值 { dt = _ipalet.selectrow_id(invd);//獲取這個重複的row_id newinvd.row_id = Convert.ToInt32(dt.Rows[0][0]); newinvd.prod_qty = Convert.ToInt32(dt.Rows[0][1]) + invd.prod_qty; if (_ipalet.UpdateordeleteIinvd(invd, newinvd) > 0) { jsonStr = "{success:true,msg:2}";//修改成功 } else { jsonStr = "{success:false,msg:3}";//修改失敗 } } else { if (_ipalet.updatemadedate(invd) > 0) { jsonStr = "{success:true,msg:2}";//修改成功 } else { jsonStr = "{success:false,msg:3}";//修改失敗 } } } } else if (type_id == 2)//表示有效日期 { invd.cde_dt = DateTime.Parse(cde_dtormade_dt); invd.made_date = invd.cde_dt.AddDays(days * (-1)); if (invd.made_date > nowtimes) { jsonStr = "{success:true,msg:1}";//1表示有效日期不能小於當前日期 } else { _ipalet = new PalletMoveMgr(mySqlConnectionString); _iialgMgr = new IialgMgr(mySqlConnectionString); result = _ipalet.selectcount(invd); #region 往iialg表中插入時間修改記錄 ialg.cde_dt = DateTime.Parse(y_cde_dtormade_dt);//原來的有效日期日期 ialg.c_cde_dt = DateTime.Parse(cde_dtormade_dt);//改后的有效日期日期 ialg.made_dt = DateTime.Parse(y_cde_dtormade_dt).AddDays(days * (-1));//原來的製造日期 ialg.c_made_dt = DateTime.Parse(cde_dtormade_dt).AddDays(days * (-1));//修改后製造日期 ialg.adj_qty = 0; if (string.IsNullOrEmpty(ialg.iarc_id)) { ialg.iarc_id = "PC"; } _iialgMgr.insertiialg(ialg);//往iialg中插入數據,用來記錄數據 #endregion if (result > 0)//大於0表示裡面存在一樣子的值 { dt = _ipalet.selectrow_id(invd);//獲取這個重複的row_id newinvd.row_id = Convert.ToInt32(dt.Rows[0][0]); newinvd.prod_qty = Convert.ToInt32(dt.Rows[0][1]) + invd.prod_qty; if (_ipalet.UpdateordeleteIinvd(invd, newinvd) > 0) { jsonStr = "{success:true,msg:2}";//修改成功 } else { jsonStr = "{success:false,msg:3}";//修改失敗 } } else { if (_ipalet.updatemadedate(invd) > 0) { jsonStr = "{success:true,msg:2}";//修改成功 } else { jsonStr = "{success:false,msg:3}";//修改失敗 } } } } } 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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
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; }
// 更新表Iinvd庫存鎖的狀態 public JsonResult UpdateIinvdActive() { string jsonStr = string.Empty; try { _iinvd = new IinvdMgr(mySqlConnectionString); Iinvd nvd = new Iinvd(); IialgQuery q = new IialgQuery(); _iagMgr = new IialgMgr(mySqlConnectionString); int id = Convert.ToInt32(Request.Params["id"]); string active = Request.Params["active"]; string lock_id = Request.Params["lock_id"]; if (!string.IsNullOrEmpty(Request.Params["po_id"].ToString())) { q.po_id = Request.Params["po_id"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["remarks"].ToString())) { q.remarks = Request.Params["remarks"].ToString(); } if (active == "H") { nvd.ista_id = "A"; nvd.qity_id = 0; } else if (active == "A") { nvd.qity_id = Convert.ToInt32(lock_id); nvd.ista_id = "H"; } nvd.row_id = id; nvd.change_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); nvd.change_dtim = DateTime.Now; if (_iinvd.UpdateIinvdLock(nvd, q) > 0) { //加鎖成功往iialg插入一條數據;解鎖不需要記錄 if (active == "A") { Iinvd store = _iinvd.GetIinvd(nvd).FirstOrDefault(); q.loc_id = store.plas_loc_id; q.item_id = store.item_id; q.iarc_id = "KS"; q.qty_o = store.prod_qty; q.type = 1; q.adj_qty = -store.prod_qty; q.create_dtim = DateTime.Now; q.create_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); q.made_dt = store.made_date; q.cde_dt = store.cde_dt; if (_iagMgr.insertiialg(q) > 0) { Caller call = new Caller(); call = (System.Web.HttpContext.Current.Session["caller"] as Caller); ProductItem proitem = new ProductItem(); _proditemMgr = new ProductItemMgr(mySqlConnectionString); int item_stock = store.prod_qty; proitem.Item_Stock = -item_stock; proitem.Item_Id = store.item_id; string path = "/WareHouse/KutiaoAddorReduce"; _proditemMgr.UpdateItemStock(proitem, path, call); return Json(new { success = "true" }); } else { return Json(new { success = "false" }); } } else { Iinvd store = _iinvd.GetIinvd(nvd).FirstOrDefault(); q.loc_id = store.plas_loc_id; q.item_id = store.item_id; q.iarc_id = "KS"; q.qty_o = 0; q.type = 1; q.adj_qty = store.prod_qty; q.create_dtim = DateTime.Now; q.create_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); q.made_dt = store.made_date; q.cde_dt = store.cde_dt; if (_iagMgr.insertiialg(q) > 0) { Caller call = new Caller(); call = (System.Web.HttpContext.Current.Session["caller"] as Caller); ProductItem proitem = new ProductItem(); _proditemMgr = new ProductItemMgr(mySqlConnectionString); int item_stock = store.prod_qty; proitem.Item_Stock = item_stock; proitem.Item_Id = store.item_id; string path = "/WareHouse/KutiaoAddorReduce"; _proditemMgr.UpdateItemStock(proitem, path, call); return Json(new { success = "true" }); } else { return Json(new { success = "false" }); } } } else { return Json(new { success = "false" }); } } 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); return Json(new { success = "false" }); } }
public HttpResponseBase InsertIinvd() { string jsonStr = String.Empty; Int64 aaa = 0; //無用變數 uint p = 0; //無用變數 try { Iinvd m = new Iinvd(); IialgQuery ia = new IialgQuery(); Iupc iu = new Iupc(); ProductItem proitem = new ProductItem(); Caller call = new Caller(); IstockChangeQuery stock = new IstockChangeQuery(); call = (System.Web.HttpContext.Current.Session["caller"] as Caller); string path = ""; _iinvd = new IinvdMgr(mySqlConnectionString); _iagMgr = new IialgMgr(mySqlConnectionString); _IiupcMgr = new IupcMgr(mySqlConnectionString); #region 獲取數據往 if (Int64.TryParse(Request.Params["item_id"].ToString(), out aaa)) { if (uint.TryParse(Request.Params["item_id"].ToString(), out p)) { m.item_id = uint.Parse(Request.Params["item_id"].ToString()); } if (Request.Params["item_id"].ToString().Length > 6) { m.item_id = uint.Parse(_iinvd.Getprodubybar(Request.Params["item_id"].ToString()).Rows[0]["item_id"].ToString()); } } else { if (Request.Params["item_id"].ToString().Length > 6) { m.item_id = uint.Parse(_iinvd.Getprodubybar(Request.Params["item_id"].ToString()).Rows[0]["item_id"].ToString()); } } m.dc_id = 1; m.whse_id = 1; m.prod_qty = Int32.Parse(Request.Params["prod_qty"].ToString());//數量 DateTime today = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); DateTime dtime; if (DateTime.TryParse(Request.Params["startTime"].ToString(), out dtime)) {//用戶填寫創建時間算出有效日期 DateTime start = DateTime.Parse(Request.Params["startTime"].ToString()); m.made_date = start; if (uint.TryParse(Request.Params["cde_dt_incr"].ToString(), out p)) { m.cde_dt = start.AddDays(Int32.Parse(Request.Params["cde_dt_incr"].ToString())); } else { m.cde_dt = DateTime.Now; } } else { if (DateTime.TryParse(Request.Params["cde_dt"].ToString(), out dtime)) {//用戶填寫有效日期算出製造日期 m.cde_dt = DateTime.Parse(Request.Params["cde_dt"].ToString());//有效時間 if (uint.TryParse(Request.Params["cde_dt_incr"].ToString(), out p)) { m.made_date = m.cde_dt.AddDays(-Int32.Parse(Request.Params["cde_dt_incr"].ToString())); } else { m.made_date = today; } } else { m.cde_dt = today; m.made_date = today; } } m.cde_dt = DateTime.Parse(m.cde_dt.ToShortDateString()); m.made_date = DateTime.Parse(m.made_date.ToShortDateString()); m.plas_loc_id = Request.Params["plas_loc_id"].ToString().ToUpper();//上架料位 string loc_id = Request.Params["loc_id"].ToString().ToUpper(); m.change_dtim = DateTime.Now;//編輯時間 m.receipt_dtim = DateTime.Now;//收貨時間 m.create_user = (Session["caller"] as Caller).user_id; #endregion #region 獲取數據添加打iialg ia.loc_id = m.plas_loc_id.ToString().ToUpper(); ia.item_id = m.item_id; stock.sc_trans_type = 0; if (!string.IsNullOrEmpty(Request.Params["iarc_id"].ToString())) { ia.iarc_id = Request.Params["iarc_id"].ToString(); } else { ia.iarc_id = "PC"; stock.sc_trans_type = 1;//收貨上架 } //if (ia.iarc_id == "DR" || ia.iarc_id == "KR") //{ // type = 2;//RF理貨 //} ia.create_dtim = DateTime.Now; ia.create_user = m.create_user; ia.doc_no = "P" + DateTime.Now.ToString("yyyyMMddHHmmss"); if (!string.IsNullOrEmpty(Request.Params["doc_num"])) { ia.doc_no = Request.Params["doc_num"]; stock.sc_trans_id = ia.doc_no;//交易單號 } if (!string.IsNullOrEmpty(Request.Params["Po_num"])) { ia.po_id = Request.Params["Po_num"]; stock.sc_cd_id = ia.po_id;//前置單號 } if (!string.IsNullOrEmpty(Request.Params["remark"])) { ia.remarks = Request.Params["remark"]; stock.sc_note = ia.remarks;//備註 } ia.made_dt = m.made_date; ia.cde_dt = m.cde_dt; #endregion #region 獲取店內條碼-=添加條碼 if (!string.IsNullOrEmpty(Request.Params["vendor_id"].ToString())) { iu.upc_id = CommonFunction.GetUpc(m.item_id.ToString(), Request.Params["vendor_id"].ToString(), m.cde_dt.ToString("yyMMdd")); } iu.item_id = m.item_id; iu.upc_type_flg = "2";//店內碼 iu.create_user = m.create_user; string result = _IiupcMgr.IsExist(iu);//是否有重複的條碼 if (result == "0") { if (_IiupcMgr.Insert(iu) < 1) { jsonStr = "{success:true,msg:2}"; } } #endregion #region 新增/編輯 #region 庫存調整的時候,商品庫存也要調整 _proditemMgr = new ProductItemMgr(mySqlConnectionString); int item_stock = m.prod_qty; proitem.Item_Stock = item_stock; proitem.Item_Id = m.item_id; #endregion if (_iinvd.IsUpd(m, stock) > 0) {//編輯 ia.qty_o = _iinvd.Selnum(m); ia.adj_qty = m.prod_qty; m.prod_qty = ia.qty_o + m.prod_qty; if (m.prod_qty >= 0) { if (_iinvd.Upd(m) > 0) { if (Request.Params["iialg"].ToString() == "Y") {// if (ia.iarc_id != "PC" && ia.iarc_id != "NE")//------------庫存調整的時候商品庫存也更改,收貨上架的時候不更改,RF理貨的時候也是不更改 { path = "/WareHouse/KutiaoAddorReduce"; _proditemMgr.UpdateItemStock(proitem, path, call); } if (_iagMgr.insertiialg(ia) > 0) { jsonStr = "{success:true,msg:0}";//更新成功 } else { jsonStr = "{success:false,msg:1}";//更新失敗 } } else { jsonStr = "{success:true,msg:0}";//更新成功 } } else { jsonStr = "{success:false,msg:1}";//更新失敗 } } else { jsonStr = "{success:false,msg:1}";//庫存為負數 } } else {//新增 m.ista_id = "A"; m.create_dtim = DateTime.Now; //創建時間 if (_iinvd.Insert(m) > 0) { _IlocMgr = new IlocMgr(mySqlConnectionString); Iloc loc = new BLL.gigade.Model.Iloc(); loc.change_user = int.Parse((System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString()); loc.change_dtim = DateTime.Now; loc.loc_id = m.plas_loc_id.ToString().ToUpper(); if (loc_id.Trim() != m.plas_loc_id.Trim())//判斷如果是主料位不需要進行多餘的操作 { if (_IlocMgr.SetIlocUsed(loc) > 0) { if (Request.Params["iialg"].ToString() == "Y") { if (ia.iarc_id != "PC" && ia.iarc_id != "NE")//------------庫存調整的時候商品庫存也更改,收貨上架的時候不更改,RF理貨的時候也是不更改 { path = "/WareHouse/KutiaoAddorReduce"; _proditemMgr.UpdateItemStock(proitem, path, call); } ia.qty_o = 0; ia.adj_qty = m.prod_qty; if (_iagMgr.insertiialg(ia) > 0) { jsonStr = "{success:true,msg:0}";//更新成功 } else { jsonStr = "{success:false,msg:1}";//更新失敗 } } else { jsonStr = "{success:true,msg:0}";//新增成功 } } else { jsonStr = "{success:false,msg:1}";//新增失敗 } } else { if (Request.Params["iialg"].ToString() == "Y") { if (ia.iarc_id != "PC" && ia.iarc_id != "NE")//------------庫存調整的時候商品庫存也更改,收貨上架的時候不更改,RF理貨的時候也是不更改 { path = "/WareHouse/KutiaoAddorReduce"; _proditemMgr.UpdateItemStock(proitem, path, call); } ia.qty_o = 0; ia.adj_qty = m.prod_qty; if (_iagMgr.insertiialg(ia) > 0) { jsonStr = "{success:true,msg:0}";//更新成功 } else { jsonStr = "{success:false,msg:1}";//更新失敗 } } else { jsonStr = "{success:true,msg:0}";//新增成功 } } } else { jsonStr = "{success:false,msg:1}"; } } #endregion } 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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr.ToString()); this.Response.End(); return this.Response; }
public JsonResult IinvdSave() { bool falg = false; string message ="保存失敗"; try { string row_id = ""; int prod_qty = 0; if (Request.Params["rowid"].Length > 5) { row_id = Request.Params["rowid"].Substring(5); } string changeStore = Request.Params["changeStore"]; int temp1=0; if (int.TryParse(changeStore, out temp1)) { if (temp1 < 0) { falg = false; message = "庫存不能小於1"; } else { _iinvd = new IinvdMgr(mySqlConnectionString); IinvdQuery iinvd = new IinvdQuery(); iinvd.pwy_dte_ctl = Request.Params["pwy_dte_ctl"]; if (!string.IsNullOrEmpty(Request.Params["loc_id"])) { iinvd.plas_loc_id = Request.Params["loc_id"]; } int id = 0; if (int.TryParse(row_id, out id)) { iinvd.row_id = id; } if (int.TryParse(changeStore, out id)) { iinvd.prod_qty = id; } if (!string.IsNullOrEmpty(Request.Params["item_id"])) { if (int.TryParse(Request.Params["item_id"], out id)) { iinvd.item_id = uint.Parse(Request.Params["item_id"]); } } iinvd.create_user = (Session["caller"] as Caller).user_id; iinvd.create_dtim = DateTime.Now; iinvd.change_user = iinvd.create_user; iinvd.change_dtim = iinvd.create_dtim; iinvd.prod_qtys = _iinvd.GetProd_qty(Convert.ToInt32(iinvd.item_id), iinvd.plas_loc_id, "", iinvd.row_id.ToString()); if (iinvd.pwy_dte_ctl == "Y") { List<DateTime> list = new List<DateTime>(); list=_iinvd.GetCde_dt(iinvd.row_id); if(list.Count>0) { iinvd.cde_dt = list[0]; iinvd.made_date = list[1]; } } else { iinvd.made_date = iinvd.create_dtim; iinvd.cde_dt = iinvd.create_dtim; } if (iinvd.row_id != 0) { if (iinvd.pwy_dte_ctl == "Y") { prod_qty = _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id, iinvd.pwy_dte_ctl, iinvd.row_id.ToString()); if (prod_qty == iinvd.prod_qty) { falg = true; return Json(new { success = falg, message = message }); } else if (_iinvd.SaveIinvd(iinvd) == 1) { falg = true; } } if (iinvd.pwy_dte_ctl == "N" || iinvd.pwy_dte_ctl == "") { iinvd.row_id = 0; if (iinvd.prod_qtys < iinvd.prod_qty) { iinvd.ista_id = "A"; iinvd.prod_qty = iinvd.prod_qty - iinvd.prod_qtys; iinvd.cde_dt = DateTime.Now; int result=_iinvd.GetIinvdCount(iinvd); if (result>1) { prod_qty = result - 1; falg = true; } else { if (_iinvd.Insert(iinvd) == 1) { falg = true; } } } else if (iinvd.prod_qtys> iinvd.prod_qty) { if (_iinvd.SaveIinvd(iinvd) == 1) { falg = true; return Json(new { success = falg, message = message }); } } else if (iinvd.prod_qtys == iinvd.prod_qty) { falg = true; return Json(new { success = falg, message = message }); } } IialgQuery iialg = new IialgQuery(); iialg.cde_dt = iinvd.cde_dt; iialg.qty_o = prod_qty;//原始庫存數量 iialg.loc_id = iinvd.plas_loc_id; iialg.item_id = iinvd.item_id; iialg.iarc_id = "循環盤點"; if (iinvd.pwy_dte_ctl == "Y") { iialg.adj_qty = iinvd.prod_qty - prod_qty; } else { iialg.adj_qty = iinvd.prod_qty-prod_qty;//轉移數量 } iialg.create_dtim = DateTime.Now; iialg.create_user = iinvd.create_user; iialg.type = 2; iialg.doc_no = "C" + DateTime.Now.ToString("yyyyMMddHHmmss"); iialg.made_dt = iinvd.made_date; iialg.cde_dt = iinvd.cde_dt; _iialgMgr = new IialgMgr(mySqlConnectionString); _iialgMgr.insertiialg(iialg); IstockChangeQuery istock = new IstockChangeQuery(); istock.sc_trans_id = iialg.doc_no; istock.item_id = iinvd.item_id; istock.sc_istock_why = 2; istock.sc_trans_type = 2; istock.sc_num_old = iinvd.prod_qtys;//原始庫存數量 istock.sc_num_chg = iialg.adj_qty;//轉移數量 istock.sc_num_new = _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id,"","");//結餘數量 istock.sc_time = iinvd.create_dtim; istock.sc_user = iinvd.create_user; istock.sc_note = "循環盤點"; IstockChangeMgr istockMgr = new IstockChangeMgr(mySqlConnectionString); istockMgr.insert(istock); } else { return Json(new { success = falg }); } } } else { message = "庫存不能小於1"; } } 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); } return Json(new { success = falg,message=message }); }
public HttpResponseBase SaveIinvd() { string json = "{success:false,message:'系統異常'}"; try { int temp = 0; if (int.TryParse(Request.Params["prod_qty"], out temp)) { if (temp > 0) { IinvdQuery iinvd = new IinvdQuery(); if (!string.IsNullOrEmpty(Request.Params["loc_id"])) { iinvd.plas_loc_id = Request.Params["loc_id"]; } if (!string.IsNullOrEmpty(Request.Params["item_id"])) { if (int.TryParse(Request.Params["item_id"], out temp)) { iinvd.item_id = uint.Parse(Request.Params["item_id"]); } } #region 判斷是否指定主料位 IlocQuery ilocquery = new IlocQuery(); _IiplasMgr = new IplasMgr(mySqlConnectionString); IplasQuery iplasquery = new IplasQuery(); iplasquery.item_id = iinvd.item_id; IIlocImplMgr ilocMgr = new IlocMgr(mySqlConnectionString); IplasDao iplasdao = new IplasDao(mySqlConnectionString); int total = 0; ilocquery.loc_id = iinvd.plas_loc_id; ilocquery.lcat_id = "0"; ilocquery.lsta_id = ""; ilocquery.IsPage = false; List<IlocQuery> listiloc = ilocMgr.GetIocList(ilocquery, out total); if (listiloc.Count > 0) { string lcat_id = listiloc.Count == 0 ? "" : listiloc[0].lcat_id; if (lcat_id == "S") { string item_id = iplasdao.Getlocid(ilocquery.loc_id); if (item_id == "") { Iplas iplas = new Iplas(); if (int.TryParse(Request.Params["item_id"], out temp)) { iplas.item_id = uint.Parse(Request.Params["item_id"]); if (_IiplasMgr.IsTrue(iplas) == "false") { json = "{success:false,message:'不存在該商品編號'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } if (_IiplasMgr.GetIplasid(iplasquery) > 0) { json = "{success:false,message:'此商品主料位非該料位'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } Iloc iloc = new Iloc(); iloc.loc_id = iinvd.plas_loc_id; if (_IiplasMgr.GetLocCount(iloc) <= 0) { json = "{success:false,message:'該料位已鎖定或被指派'}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } iplas.loc_id = iloc.loc_id; iplas.loc_stor_cse_cap = 100; iplas.create_user = (Session["caller"] as Caller).user_id; iplas.create_dtim = DateTime.Now; iplas.change_user = (Session["caller"] as Caller).user_id; iplas.change_dtim = DateTime.Now; _IiplasMgr.InsertIplas(iplas); } } } } #endregion iinvd.create_user = (Session["caller"] as Caller).user_id; iinvd.create_dtim = DateTime.Now; iinvd.change_user = iinvd.create_user; iinvd.change_dtim = iinvd.create_dtim; iinvd.ista_id = "A"; if (!string.IsNullOrEmpty(Request.Params["loc_id"])) { iinvd.plas_loc_id = Request.Params["loc_id"]; } int change_prod_qty = int.Parse(Request.Params["prod_qty"]); iinvd.prod_qty = change_prod_qty; if (!string.IsNullOrEmpty(Request.Params["st_qty"])) { if (int.TryParse(Request.Params["st_qty"], out temp)) { iinvd.st_qty = int.Parse(Request.Params["st_qty"]); } } if (!string.IsNullOrEmpty(Request.Params["item_id"])) { if (int.TryParse(Request.Params["item_id"], out temp)) { iinvd.item_id = uint.Parse(Request.Params["item_id"]); } } DateTime date = DateTime.Now; if (DateTime.TryParse(Request.Params["datetimepicker1"], out date)) { iinvd.made_date = date; } else { iinvd.made_date = DateTime.Now; } _iinvd = new IinvdMgr(mySqlConnectionString); if (Request.Params["pwy_dte_ctl"] == "Y") { iinvd.pwy_dte_ctl = "Y"; IProductExtImplMgr productExt = new ProductExtMgr(mySqlConnectionString); int Cde_dt_incr = productExt.GetCde_dt_incr((int)iinvd.item_id); iinvd.cde_dt = date.AddDays(Cde_dt_incr); } else { iinvd.cde_dt = DateTime.Now; } iinvd.prod_qtys = _iinvd.GetProd_qty(Convert.ToInt32(iinvd.item_id), iinvd.plas_loc_id, "", iinvd.row_id.ToString()); IialgQuery iialg = new IialgQuery(); iialg.cde_dt = iinvd.cde_dt; int prod_qty = 0;// _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id, "", ""); int row = _iinvd.GetIinvdCount(iinvd); if (row > 1) { prod_qty = row - 1; json = "{success:true}"; } else { if (_iinvd.Insert(iinvd) == 1) { json = "{success:true}"; } } iialg.qty_o = prod_qty; iialg.loc_id = iinvd.plas_loc_id; iialg.item_id = iinvd.item_id; iialg.iarc_id = "循環盤點"; iialg.adj_qty = change_prod_qty; iialg.create_dtim = DateTime.Now; iialg.create_user = iinvd.create_user; iialg.type = 2; iialg.doc_no = "C" + DateTime.Now.ToString("yyyyMMddHHmmss"); iialg.made_dt = iinvd.made_date; iialg.cde_dt = iinvd.cde_dt; _iialgMgr = new IialgMgr(mySqlConnectionString); _iialgMgr.insertiialg(iialg); IstockChangeQuery istock = new IstockChangeQuery(); istock.sc_trans_id = iialg.doc_no; istock.item_id = iinvd.item_id; istock.sc_istock_why = 2; istock.sc_trans_type = 2; istock.sc_num_old = iinvd.prod_qtys; istock.sc_num_chg = iialg.adj_qty; istock.sc_num_new = _iinvd.GetProd_qty((int)iinvd.item_id, iinvd.plas_loc_id,"N",""); istock.sc_time = iinvd.create_dtim; istock.sc_user = iinvd.create_user; istock.sc_note = "循環盤點"; IstockChangeMgr istockMgr = new IstockChangeMgr(mySqlConnectionString); istockMgr.insert(istock); } else { json = "{success:false,message:'庫存不能小於1'}"; } } else { json = "{success:false,message:'庫存請輸入數字'}"; } } 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }