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