| | |
|---|
| | | //dynamicParams.Add("@purchordercode", purchordercode); |
|---|
| | | } |
|---|
| | | //查询未关闭且未全部到货的采购订单 |
|---|
| | | sql = @"select distinct A.ordercode from T_PurchaseOrder A |
|---|
| | | sql = @"select distinct A.orderid,A.ordercode from T_PurchaseOrder A |
|---|
| | | inner join T_PurchaseOrder_sub B on A.ordercode=B.purchaseorder_code |
|---|
| | | where (isnull(B.quantity,0)-isnull(B.countarrivalquantity,0)+isnull(B.countreturnquantity,0))>0 and A.status<>'CLOSED'" + search; |
|---|
| | | dynamicParams.Add("@purchordercode", purchordercode); |
|---|
| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //根据采购订单号查询物料信息，供应商信息 |
|---|
| | | sql = @"select B.rownumber, B.materiel_code as partcode,M.partname,M.partspec,M.is_batchno,M.is_incheck, |
|---|
| | | sql = @"select B.rownumber,B.sbid, B.materiel_code as partcode,M.partname,M.partspec,M.is_batchno,M.is_incheck, |
|---|
| | | B.quantity,B.customercode,C.name as customername,A.departmentcode,T.org_name as departmentname,U.code as uomcode,U.name as uomname, |
|---|
| | | A.ordercode,B.countarrivalquantity,A.acceptdate |
|---|
| | | from T_PurchaseOrder A |
|---|
| | |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[采购入库扫描标签条码带出到货单信息] |
|---|
| | | public static ToMessage MesAppPurchInStorScanLabCode(string labcode, string ordercode) |
|---|
| | | public static ToMessage MesAppPurchInStorScanLabCode(string labcode) |
|---|
| | | { |
|---|
| | | string sql = ""; |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.Message = "当前条码已入库!"; |
|---|
| | | mes.data = null; |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | //判断扫描标签是否为当前选择采购订单下的到货单所生成标签 |
|---|
| | | sql = @"select * from T_BarCodeBill where hsourcebillno=@ordercode"; |
|---|
| | | dynamicParams.Add("@ordercode", ordercode); |
|---|
| | | var data0 = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | if (data0.Rows.Count < 0) |
|---|
| | | { |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.Message = "当前条码不是采购订单【" + ordercode + "】生成条码!"; |
|---|
| | | mes.data = null; |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | |
|---|
| | | JArray arra = (JArray)Newtonsoft.Json.JsonConvert.DeserializeObject(incontent); |
|---|
| | | list.Clear(); |
|---|
| | | //写入入库记录主表 |
|---|
| | | sql = @"insert into TK_WMS_Inwh_Main(docu_typecode,hbillno,hsoucenillno,status,hcustomer,hdempart,lm_user,lm_date) |
|---|
| | | values(@docu_typecode,@hbillno,@hsoucenillno,@status,@hcustomer,@hdempart,@lm_user,@lm_date)"; |
|---|
| | | sql = @"insert into TK_WMS_Inwh_Main(docu_typecode,hbillno,hsoucenillnoid,hsoucenillno,status,hcustomer,hdempart,lm_user,lm_date) |
|---|
| | | values(@docu_typecode,@hbillno,@hsoucenillnoid,@hsoucenillno,@status,@hcustomer,@hdempart,@lm_user,@lm_date)"; |
|---|
| | | list.Add(new |
|---|
| | | { |
|---|
| | | str = sql, |
|---|
| | |
|---|
| | | { |
|---|
| | | docu_typecode = "1201", |
|---|
| | | hbillno = djwo, |
|---|
| | | hsoucenillnoid= arra[0]["hsoucenillnoid"].ToString(), |
|---|
| | | hsoucenillno = ordercode, |
|---|
| | | status = "NEW", |
|---|
| | | hcustomer = arra[0]["customercode"].ToString(), |
|---|
| | |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
