ZQHApi.git - Gitblit

			@@ -204,7 +204,7 @@
			hbillno = djwo,
			hbilltype = "1103", //采购到货单类型
			hbarcode = json[i].children[j].labcode,
			qualitystatus= json[i].hischeck=="Y"? "TS" : "CS",
			qualitystatus = json[i].hischeck == "Y" ? "TS" : "CS",
			hbarcodestatus = "Y",
			hbarcodetype = "P",
			hmaterialcode = json[i].children[j].partnumber,
			@@ -356,9 +356,22 @@
			try
			{
			//判断条码状态
			mes = LabCodeStatusMessage.LabCodeStatus("2060", "1103", labcode);//功能编号、单据类型编码、标签编码
			mes = LabCodeStatusMessage.LabCodeStatus("2060", "1103", labcode);//功能编号(采购到货)、单据类型编码(采购到货单)、标签编码
			if (mes.code == "300")
			{
			return mes;
			}
			//判断标签状态(是否已入库(不能再入))
			sql = @"select * from TK_WMS_Inwh_Sub where labcode like '%'+@labcode+'%'";
			dynamicParams.Add("@labcode", "labcode");
			dynamicParams.Add("@labcode", labcode);
			var dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前条码已入库!";
			mes.data = null;
			return mes;
			}
			//判断扫描标签是否为当前选择采购订单下的到货单所生成标签
			@@ -466,7 +479,7 @@
			string labcode = "";//标签信息
			decimal suminqty = 0; //单标签入库总数量
			string batchno = ""; //批次号


			//查询汇总标签信息
			for (int j = 0; j < arra[i]["labcont"].Count(); j++)//循环获取标签信息
			{
			@@ -495,10 +508,33 @@
			hinqty = decimal.Parse(arra[i]["labcont"][j]["qty"].ToString())
			}
			});
			labcode = labcode + arra[i]["labcont"][j]["labcode"].ToString() + ",";

			//写入库存表
			sql = @"insert into TK_WMS_Stock(labcode,materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date)
			values(@labcode,materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			labcode = arra[i]["labcont"][j]["labcode"].ToString(),
			materiel_code = arra[i]["partcode"].ToString(),
			batchno = batchno,
			storehouse_code = arra[i]["storehousecode"].ToString(),
			location_code = arra[i]["warehousecode"].ToString(),
			customercode = arra[i]["customercode"].ToString(),
			qty = suminqty,
			lm_user = username,
			lm_date = datetime,
			}
			});


			//labcode = labcode + arra[i]["labcont"][j]["labcode"].ToString() + ",";
			suminqty = suminqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString());
			partlabqty = partlabqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString());
			batchno = arra[i]["labcont"][j]["batch"].ToString();

			}

			//更新采购订单子表入库数量
			@@ -516,9 +552,9 @@
			});

			//写入采购入库单子表
			sql = @"insert into TK_WMS_Inwh_Sub(hbillno,labcode,rownumber,materiel_code,storehouse_code,location_code,qty,batchno)
			values(@hbillno,@labcode,@rownumber,@materiel_code,@storehouse_code,@location_code,@qty,@batchno)";
			labcode = string.Format("'{0}'", labcode.Substring(0, labcode.Length - 1).Replace(",", "','"));
			sql = @"insert into TK_WMS_Inwh_Sub(hbillno,rownumber,materiel_code,storehouse_code,location_code,qty,batchno)
			values(@hbillno,@rownumber,@materiel_code,@storehouse_code,@location_code,@qty,@batchno)";
			//labcode = string.Format("'{0}'", labcode.Substring(0, labcode.Length - 1).Replace(",", "','"));
			list.Add(new
			{
			str = sql,
			@@ -534,44 +570,7 @@
			batchno = batchno
			}
			});
			//写入库存表前查询当前物料在库存表中是否存在,写入或更新库存表
			sql = @"select * from TK_WMS_Stock where materiel_code=@materiel_code";
			dynamicParams.Add("@materiel_code", arra[i]["partcode"].ToString());
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			sql = @"update TK_WMS_Stock set qty=qty+@suminqty
			where materiel_code=@materiel_code";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			materiel_code = arra[i]["partcode"].ToString(),
			suminqty = suminqty
			}
			});
			}
			else
			{
			sql = @"insert into TK_WMS_Stock(materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date)
			values(materiel_code,batchno,storehouse_code,location_code,customercode,qty,lm_user,lm_date)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			materiel_code = arra[i]["partcode"].ToString(),
			batchno = batchno,
			storehouse_code= arra[i]["storehousecode"].ToString(),
			location_code= arra[i]["warehousecode"].ToString(),
			customercode= arra[i]["customercode"].ToString(),
			qty= suminqty,
			lm_user=username,
			lm_date= datetime,
			}
			});
			}

			/写入ERP采购入库单***********
			* ***********************
			* **********************
			@@ -697,6 +696,25 @@
			var dynamicParams = new DynamicParameters();
			try
			{
			//判断条码状态
			mes = LabCodeStatusMessage.LabCodeStatus("2060", "1103", labcode);//功能编号(采购到货)、单据类型编码(采购到货单)、标签编码
			if (mes.code == "300")
			{
			return mes;
			}
			//判断标签状态(是否已入库(不能退货))
			sql = @"select * from TK_WMS_Inwh_Sub where labcode like '%'+@labcode+'%'";
			dynamicParams.Add("@labcode", "labcode");
			dynamicParams.Add("@labcode", labcode);
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前条码已入库!";
			mes.data = null;
			return mes;
			}
			//根据采购订单号、物料编码、标签条码查找标签信息
			sql = @"select A.hbarcode,A.hcustomercode,C.name as hcustomercode,
			A.hbatchno,A.qualitystatus,A.location_code,L.name as location_name,A.hqty
			@@ -768,15 +786,15 @@
			str = sql,
			parm = new
			{
			orderdate= datetime,
			ordercode= djwo,
			status="NEW",
			departmentcode= arra[0]["departmentcode"].ToString(),
			customercode= arra[0]["customercode"].ToString(),
			saleorderid= orderid,
			saleordercode=ordercode,
			lm_user= username,
			lm_date= datetime
			orderdate = datetime,
			ordercode = djwo,
			status = "NEW",
			departmentcode = arra[0]["departmentcode"].ToString(),
			customercode = arra[0]["customercode"].ToString(),
			saleorderid = orderid,
			saleordercode = ordercode,
			lm_user = username,
			lm_date = datetime
			}
			});
			//根据源单+物料查询采购订单到货总数、入库总数
			@@ -804,6 +822,18 @@
			//查询汇总标签信息
			for (int j = 0; j < arra[i]["labcont"].Count(); j++)//循环获取标签信息
			{
			//更新条码状态
			sql = @"update T_BarCodeBill set hbarcodestatus=@hbarcodestatus where hsourcebillno=@hsourcebillno and hbarcode=@hbarcode";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			hbarcodestatus = "N",
			hsourcebillno = ordercode,
			hbarcode = arra[i]["labcont"][j]["labcode"].ToString()
			}
			});
			//更新到货单子表退货数量
			sql = @"update T_PurchaseArrivalOrder_sub set hreturnqty=isnull(hreturnqty,0)+@inqty where hbillno=@hbillno and hpartcode=@hpartcode";
			list.Add(new
			@@ -816,6 +846,21 @@
			hinqty = decimal.Parse(arra[i]["labcont"][j]["qty"].ToString())
			}
			});

			//更新库存表
			sql = @"update TK_WMS_Stock set qty=qty-@inqty
			where materiel_code=@materiel_code and labcode=@labcode";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			labcode = arra[i]["labcont"][j]["labcode"].ToString(),
			materiel_code = arra[i]["partcode"].ToString(),
			inqty = decimal.Parse(arra[i]["labcont"][j]["qty"].ToString())
			}
			});

			labcode = labcode + arra[i]["labcont"][j]["labcode"].ToString() + ",";
			suminqty = suminqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString());
			partlabqty = partlabqty + decimal.Parse(arra[i]["labcont"][j]["qty"].ToString());
			@@ -855,24 +900,6 @@
			batchno = batchno
			}
			});
			//写入库存表前查询当前物料在库存表中是否存在,写入或更新库存表
			sql = @"select * from TK_WMS_Stock where materiel_code=@materiel_code";
			dynamicParams.Add("@materiel_code", arra[i]["partcode"].ToString());
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			sql = @"update TK_WMS_Stock set qty=qty-@suminqty
			where materiel_code=@materiel_code";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			materiel_code = arra[i]["partcode"].ToString(),
			suminqty = suminqty
			}
			});
			}
			/写入ERP采购退货单***********
			* ***********************
			* **********************