| | |
| | | } |
| | | #endregion |
| | | |
| | | #region æ´æ°æ¡ç 对åºåæ® åå· æ¬¡æ° æ¶é´ |
| | | #region æ´æ°æ¡ç 对åºåºåºç³è¯·åå· å
´è¾¾ |
| | | public class BarCodeMeta |
| | | { |
| | | public string HBarCode { get; set; } |
| | |
| | | string msg2 = sArray[0].ToString(); |
| | | string HBillType = sArray[1].ToString(); |
| | | string HBillNo = sArray[2].ToString(); |
| | | string HOrgName = sArray[3].ToString(); |
| | | |
| | | List<BarCodeMeta> BarCodeMetaList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<BarCodeMeta>>(msg2); |
| | | oCN.BeginTran(); |
| | | try |
| | | { |
| | | oCN.BeginTran(); |
| | | |
| | | for(int i = 0; i < BarCodeMetaList.Count; i++) |
| | | { |
| | | if (HBillType == "1205") // éå®åºåº |
| | | { |
| | | oCN.RunProcReturn("Update Gy_BarCodeBill set HOutStockDate = getdate(), HOutStockCounts=isnull(HOutStockCounts,0)+1," + |
| | | "HOutStockBillNo='" + HBillNo + " 'where HBarCode = '" + BarCodeMetaList[i].HBarCode + "'", "Gy_BarCodeBill"); |
| | | } |
| | | if (HBillType == "1201") // éè´å
¥åº |
| | | { |
| | | oCN.RunProcReturn("Update Gy_BarCodeBill set HInStockDate = getdate(), HInStockCounts=isnull(HOutStockCounts,0)+1," + |
| | | "HInStockBillNo='" + HBillNo + " 'where HBarCode = '" + BarCodeMetaList[i].HBarCode + "'", "Gy_BarCodeBill"); |
| | | |
| | | if (HOrgName.Contains("å
´è¾¾") && !string.IsNullOrEmpty(HBillNo)) |
| | | { |
| | | // å
´è¾¾ éå®åºåºæ´æ° åè´§éç¥å |
| | | oCN.RunProcReturn("Update Gy_BarCodeBill set " + |
| | | "HSeOutStockBillNo='" + HBillNo + "' where HBarCode = '" + BarCodeMetaList[i].HBarCode + "'", "Gy_BarCodeBill"); |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿®æ¹å¤±è´¥!" + e.Message; |