| | |
| | | { |
| | | private JsonResult objJsonResult = new JsonResult(); |
| | | private json objjson = new json(); |
| | | |
| | | public new ClsCNSRM oCn = new ClsCNSRM(); |
| | | |
| | | public T ScriptDeserialize<T>(string strJson) |
| | | { |
| | |
| | | /// <returns></returns> |
| | | [Route("UpdateBarcodePrintQty")] |
| | | [HttpPost] |
| | | public object UpdateBarcodePrintQty([FromBody]JObject msg) |
| | | public object UpdateBarcodePrintQty([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | /// <param name="msg"></param> |
| | | /// <param name="msg2"></param> |
| | | /// <returns></returns> |
| | | public object GetBarcodeSaveBill_Varieties([FromBody]JObject msg) |
| | | public object GetBarcodeSaveBill_Varieties([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string UserName = ""; |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | |
| | | if (ClsPub.isLong(oItemSub.HMaterID) != 0) |
| | | { |
| | | HNumber = oItemSub.HMaterID.ToString(); |
| | | HMTONO=ClsPub.isStrNull(oItemSub.HMTONO); |
| | | HMTONO = ClsPub.isStrNull(oItemSub.HMTONO); |
| | | // |
| | | |
| | | HQty = ClsPub.isDoule(oItemSub.HQty); |
| | |
| | | /// <param name="msg"></param> |
| | | /// <param name="msg2"></param> |
| | | /// <returns></returns> |
| | | public object GetBarcodeSaveBill_Only([FromBody]JObject msg) |
| | | public object GetBarcodeSaveBill_Only([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | } |
| | | } |
| | | //int i = 1; |
| | | long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | int LSHlen = 6; //流水号长度 |
| | | int SumLen = 10; //总长度 |
| | | string TM = ""; //条码 |
| | |
| | | HNumber = oItemSub.HMaterID.ToString(); |
| | | // |
| | | |
| | | HQty =ClsPub.isDoule(oItemSub.HQty); |
| | | HBQty = ClsPub.isInt(oItemSub.HBQty); |
| | | HQty = ClsPub.isDoule(oItemSub.HQty); |
| | | HBQty = ClsPub.isInt(oItemSub.HBQty); |
| | | HMinQty = ClsPub.isDoule(oItemSub.HMinQty); |
| | | HSumQty = ClsPub.isDoule(oItemSub.HQty); |
| | | for (int i = 0; i < HBQty; i++) |
| | |
| | | { |
| | | TM = "0" + TM; |
| | | } |
| | | TM = "SRM" + TM; |
| | | TM = "SRM" + TM; |
| | | //TM = "B" + TM; |
| | | if (HSumQty - HMinQty > 0) |
| | | { |
| | |
| | | bar.HSupID = oItemSub.HSupID; |
| | | bar.HMinQty = oItemSub.HMinQty; |
| | | bar.HMTONO = oItemSub.HMTONO; |
| | | |
| | | |
| | | ls2.Add(bar); |
| | | } |
| | | } |
| | |
| | | } |
| | | //暂时只回填关联数量 |
| | | oCn.RunProc("exec H_p_SRM_BarCodeBill_Update_UpdateBillRelateData " + linterid.ToString()); |
| | | |
| | | |
| | | oCn.Commit(); |
| | | } |
| | | catch (Exception e) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "生成条码成功!"; |
| | | WebAPIController.Add_Log("条码下推", UserName, "生成条码"); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "生成条码成功!"; |
| | | WebAPIController.Add_Log("条码下推", UserName, "生成条码"); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | [Route("GetBarcodeSaveBillBox")] |
| | | [HttpPost] |
| | |
| | | /// <param name="msg"></param> |
| | | /// <param name="msg2"></param> |
| | | /// <returns></returns> |
| | | public object GetBarcodeSaveBill_Box([FromBody]JObject msg) |
| | | public object GetBarcodeSaveBill_Box([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | } |
| | | } |
| | | long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | int LSHlen = 6; //流水号长度 |
| | | int SumLen = 10; //总长度 |
| | | string TM = ""; //条码 |
| | | string HNumber = ""; //物料代码 |
| | | double HSumQty = 0; //产品数量 |
| | | double HMinQty = 0; //最小包装数 |
| | | int HBQty = 0; //箱数 |
| | | double HQty = 0; //数量 |
| | | int LSH = 0; //流水号 |
| | | string LSH2 = ""; //流水号转换成字符 |
| | | string sDate = ""; //日期 |
| | | string sYear = ""; //年 |
| | | string sPeriod = ""; //月 |
| | | string sDay = ""; //日 |
| | | string WeiShu = ""; //尾数 |
| | | DataSet Ds; |
| | | SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); |
| | | Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH"); |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls) |
| | | { |
| | | if (ClsPub.isLong(oItemSub.HMaterID) != 0) |
| | | int LSHlen = 6; //流水号长度 |
| | | int SumLen = 10; //总长度 |
| | | string TM = ""; //条码 |
| | | string HNumber = ""; //物料代码 |
| | | double HSumQty = 0; //产品数量 |
| | | double HMinQty = 0; //最小包装数 |
| | | int HBQty = 0; //箱数 |
| | | double HQty = 0; //数量 |
| | | int LSH = 0; //流水号 |
| | | string LSH2 = ""; //流水号转换成字符 |
| | | string sDate = ""; //日期 |
| | | string sYear = ""; //年 |
| | | string sPeriod = ""; //月 |
| | | string sDay = ""; //日 |
| | | string WeiShu = ""; //尾数 |
| | | DataSet Ds; |
| | | SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM(); |
| | | Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH"); |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls) |
| | | { |
| | | HNumber = oItemSub.HMaterID.ToString(); |
| | | //HNumber = HNumber.Replace(".", ""); |
| | | // |
| | | if (ClsPub.isLong(oItemSub.HMaterID) != 0) |
| | | { |
| | | HNumber = oItemSub.HMaterID.ToString(); |
| | | //HNumber = HNumber.Replace(".", ""); |
| | | // |
| | | |
| | | //HQty = Math.Ceiling(HBQty + ClsPub.isDoule(oItemSub.HWBQty)); |
| | | |
| | | HQty = ClsPub.isDoule(oItemSub.HWBQty); |
| | | HBQty = ClsPub.isInt(oItemSub.HWBQty); |
| | | HMinQty = ClsPub.isDoule(oItemSub.HWXQty); |
| | | HSumQty = ClsPub.isDoule(oItemSub.HQty); //HWXQtyCol |
| | | for (int i = 0; i < HBQty; i++) |
| | | { |
| | | LSH = LSH + 1; |
| | | LSH2 = LSH.ToString(); |
| | | while (LSH2.Length < LSHlen) //如果流水号小于6位数前面补0 |
| | | HQty = ClsPub.isDoule(oItemSub.HWBQty); |
| | | HBQty = ClsPub.isInt(oItemSub.HWBQty); |
| | | HMinQty = ClsPub.isDoule(oItemSub.HWXQty); |
| | | HSumQty = ClsPub.isDoule(oItemSub.HQty); //HWXQtyCol |
| | | for (int i = 0; i < HBQty; i++) |
| | | { |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | sDate = ClsPub.GetServerDate(0); |
| | | sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | //================================== |
| | | TM = HNumber + sYear + sPeriod + sDay + LSH2; |
| | | while (TM.Length < SumLen) //如果条码小于12位数前面补0 |
| | | { |
| | | TM = "0" + TM; |
| | | } |
| | | LSH = LSH + 1; |
| | | LSH2 = LSH.ToString(); |
| | | while (LSH2.Length < LSHlen) //如果流水号小于6位数前面补0 |
| | | { |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | sDate = ClsPub.GetServerDate(0); |
| | | sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | //================================== |
| | | TM = HNumber + sYear + sPeriod + sDay + LSH2; |
| | | while (TM.Length < SumLen) //如果条码小于12位数前面补0 |
| | | { |
| | | TM = "0" + TM; |
| | | } |
| | | //TM = "B" + TM; |
| | | TM = "SRM" + "B" + TM; |
| | | |
| | | |
| | | if (HSumQty - HMinQty > 0) |
| | | { |
| | | WeiShu = ""; |
| | |
| | | } |
| | | HMinQty = HSumQty; |
| | | } |
| | | |
| | | Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model(); |
| | | bar.HBarCode = TM; |
| | | bar.HMaterID = oItemSub.HMaterID; |
| | | //bar.HMaterNumber = oItemSub.HMaterNumber; |
| | | //bar.HMaterName = oItemSub.HMaterName; |
| | | //bar.HMaterModel = oItemSub.HMaterModel; |
| | | // bar.HModel2 = oItemSub.HModel; |
| | | |
| | | bar.HUnitID = oItemSub.HUnitID; |
| | | //bar.HUnitNumber2 = oItemSub.HUnitNumber; |
| | | //bar.HUnitName2 = oItemSub.HUnitName; |
| | | Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model(); |
| | | bar.HBarCode = TM; |
| | | bar.HMaterID = oItemSub.HMaterID; |
| | | //bar.HMaterNumber = oItemSub.HMaterNumber; |
| | | //bar.HMaterName = oItemSub.HMaterName; |
| | | //bar.HMaterModel = oItemSub.HMaterModel; |
| | | // bar.HModel2 = oItemSub.HModel; |
| | | |
| | | bar.HQty = HMinQty; |
| | | bar.HBatchNo = oItemSub.HBatchNo; |
| | | bar.HKFDate = oItemSub.HKFDate; |
| | | bar.HKFPeriod = oItemSub.HKFPeriod; |
| | | bar.HKFDQDate = oItemSub.HKFDQDate; |
| | | bar.HSourceInterID = oItemSub.HSourceInterID; |
| | | bar.HSourceEntryID = oItemSub.HSourceEntryID; |
| | | bar.HSourceBillNo = oItemSub.HSourceBillNo; |
| | | bar.HSourceBillType = oItemSub.HSourceBillType; |
| | | bar.HMinQty = oItemSub.HMinQty; |
| | | bar.HSupID = oItemSub.HSupID; |
| | | bar.HEndQty = WeiShu; |
| | | bar.HMTONO = oItemSub.HMTONO; |
| | | ls2.Add(bar); |
| | | bar.HUnitID = oItemSub.HUnitID; |
| | | //bar.HUnitNumber2 = oItemSub.HUnitNumber; |
| | | //bar.HUnitName2 = oItemSub.HUnitName; |
| | | |
| | | bar.HQty = HMinQty; |
| | | bar.HBatchNo = oItemSub.HBatchNo; |
| | | bar.HKFDate = oItemSub.HKFDate; |
| | | bar.HKFPeriod = oItemSub.HKFPeriod; |
| | | bar.HKFDQDate = oItemSub.HKFDQDate; |
| | | bar.HSourceInterID = oItemSub.HSourceInterID; |
| | | bar.HSourceEntryID = oItemSub.HSourceEntryID; |
| | | bar.HSourceBillNo = oItemSub.HSourceBillNo; |
| | | bar.HSourceBillType = oItemSub.HSourceBillType; |
| | | bar.HMinQty = oItemSub.HMinQty; |
| | | bar.HSupID = oItemSub.HSupID; |
| | | bar.HEndQty = WeiShu; |
| | | bar.HMTONO = oItemSub.HMTONO; |
| | | ls2.Add(bar); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2) |
| | | { |
| | | if (ClsPub.isLong(oItemSub2.HMaterID) != 0) |
| | | foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2) |
| | | { |
| | | long sMaterID = ClsPub.isLong(oItemSub2.HMaterID); |
| | | Ds = oCn.RunProcReturn("exec GetLSH " + sMaterID.ToString(), "GetLSH"); |
| | | string WeiShu1 = ""; //尾数 |
| | | int SumLen2 = 4; |
| | | string TM2 = ""; |
| | | double HWXQty = 0; |
| | | |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]) + 1; |
| | | // |
| | | HNumber = oItemSub2.HMaterID.ToString(); |
| | | //HMinQty = ClsPub.isDoule(oItemSub2.HMinQtyCol2].Value); |
| | | HWXQty = ClsPub.isDoule(oItemSub2.HMinQty); |
| | | HSumQty = ClsPub.isDoule(oItemSub2.HQty); |
| | | HBQty = ClsPub.isInt(Math.Ceiling(HSumQty / HWXQty)); |
| | | double NXTMQTY = 0; |
| | | for (int i = 0; i < HBQty; i++) |
| | | if (ClsPub.isLong(oItemSub2.HMaterID) != 0) |
| | | { |
| | | if (HSumQty <= 0 || HWXQty <= 0) |
| | | long sMaterID = ClsPub.isLong(oItemSub2.HMaterID); |
| | | Ds = oCn.RunProcReturn("exec GetLSH " + sMaterID.ToString(), "GetLSH"); |
| | | string WeiShu1 = ""; //尾数 |
| | | int SumLen2 = 4; |
| | | string TM2 = ""; |
| | | double HWXQty = 0; |
| | | |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]) + 1; |
| | | // |
| | | HNumber = oItemSub2.HMaterID.ToString(); |
| | | //HMinQty = ClsPub.isDoule(oItemSub2.HMinQtyCol2].Value); |
| | | HWXQty = ClsPub.isDoule(oItemSub2.HMinQty); |
| | | HSumQty = ClsPub.isDoule(oItemSub2.HQty); |
| | | HBQty = ClsPub.isInt(Math.Ceiling(HSumQty / HWXQty)); |
| | | double NXTMQTY = 0; |
| | | for (int i = 0; i < HBQty; i++) |
| | | { |
| | | break; |
| | | } |
| | | if (HSumQty - HWXQty > 0) |
| | | { |
| | | WeiShu1 = ""; |
| | | NXTMQTY = HWXQty; |
| | | HSumQty = HSumQty - HWXQty; |
| | | } |
| | | else |
| | | { |
| | | if (HSumQty == HWXQty) |
| | | if (HSumQty <= 0 || HWXQty <= 0) |
| | | { |
| | | break; |
| | | } |
| | | if (HSumQty - HWXQty > 0) |
| | | { |
| | | WeiShu1 = ""; |
| | | NXTMQTY = HWXQty; |
| | | HSumQty = HSumQty - HWXQty; |
| | | } |
| | | else |
| | | { |
| | | WeiShu1 = "尾数"; |
| | | if (HSumQty == HWXQty) |
| | | { |
| | | WeiShu1 = ""; |
| | | } |
| | | else |
| | | { |
| | | WeiShu1 = "尾数"; |
| | | } |
| | | NXTMQTY = HSumQty; //HWXQty |
| | | HWXQty = HSumQty; |
| | | HSumQty = 0; |
| | | } |
| | | NXTMQTY = HSumQty; //HWXQty |
| | | HWXQty = HSumQty; |
| | | HSumQty = 0; |
| | | sDate = ClsPub.GetServerDate(0); |
| | | sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | // |
| | | // TM = HNumber + sYear + sPeriod + sDay; //条码 |
| | | // |
| | | Model.ClsGy_BarCodeBill_WMS_Model bar2 = new Model.ClsGy_BarCodeBill_WMS_Model(); |
| | | TM2 = (i + 1).ToString(); |
| | | while (TM2.Length < SumLen2) //如果条码小于12位数前面补0 |
| | | { |
| | | TM2 = "0" + TM2; |
| | | } |
| | | bar2.HMaterID = oItemSub2.HMaterID; |
| | | |
| | | |
| | | bar2.HBarCode = oItemSub2.HBarCode + "-" + TM2; |
| | | |
| | | bar2.HUnitID = oItemSub2.HUnitID; |
| | | bar2.HQty = HWXQty; |
| | | bar2.HBatchNo = DBUtility.ClsPub.isStrNull(oItemSub2.HBatchNo); |
| | | bar2.HKFDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDate); |
| | | bar2.HKFDQDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDQDate); |
| | | bar2.HKFPeriod = DBUtility.ClsPub.isInt(oItemSub2.HKFPeriod); |
| | | bar2.HSourceInterID = oItemSub2.HSourceInterID; |
| | | bar2.HSourceEntryID = oItemSub2.HSourceEntryID; |
| | | bar2.HSourceBillNo = oItemSub2.HSourceBillNo; |
| | | bar2.HSourceBillType = oItemSub2.HSourceBillType; |
| | | bar2.HSupID = oItemSub2.HSupID; |
| | | bar2.HEndQty = WeiShu1; |
| | | bar2.HMTONO = oItemSub2.HMTONO; |
| | | ls3.Add(bar2); |
| | | } |
| | | sDate = ClsPub.GetServerDate(0); |
| | | sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | // |
| | | // TM = HNumber + sYear + sPeriod + sDay; //条码 |
| | | // |
| | | Model.ClsGy_BarCodeBill_WMS_Model bar2 = new Model.ClsGy_BarCodeBill_WMS_Model(); |
| | | TM2 = (i + 1).ToString(); |
| | | while (TM2.Length < SumLen2) //如果条码小于12位数前面补0 |
| | | { |
| | | TM2 = "0" + TM2; |
| | | } |
| | | bar2.HMaterID = oItemSub2.HMaterID; |
| | | |
| | | |
| | | bar2.HBarCode = oItemSub2.HBarCode + "-" + TM2; |
| | | |
| | | bar2.HUnitID = oItemSub2.HUnitID; |
| | | bar2.HQty = HWXQty; |
| | | bar2.HBatchNo = DBUtility.ClsPub.isStrNull(oItemSub2.HBatchNo); |
| | | bar2.HKFDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDate); |
| | | bar2.HKFDQDate = DBUtility.ClsPub.isStrNull(oItemSub2.HKFDQDate); |
| | | bar2.HKFPeriod = DBUtility.ClsPub.isInt(oItemSub2.HKFPeriod); |
| | | bar2.HSourceInterID = oItemSub2.HSourceInterID; |
| | | bar2.HSourceEntryID = oItemSub2.HSourceEntryID; |
| | | bar2.HSourceBillNo = oItemSub2.HSourceBillNo; |
| | | bar2.HSourceBillType = oItemSub2.HSourceBillType; |
| | | bar2.HSupID = oItemSub2.HSupID; |
| | | bar2.HEndQty = WeiShu1; |
| | | bar2.HMTONO = oItemSub2.HMTONO; |
| | | ls3.Add(bar2); |
| | | } |
| | | } |
| | | } |
| | | string HBarCode = ""; |
| | | string HBarCodeType = ""; |
| | | Int64 HMaterID = 0; |
| | | Int64 HUnitID = 0; |
| | | double HQty2 = 0; |
| | | string HBatchNo = ""; |
| | | Int64 HSupID = 0; |
| | | Int64 HGroupID = 0; |
| | | int HPrintQty = 0; |
| | | Int64 HSourceInterID = 0; |
| | | Int64 HSourceEntryID = 0; |
| | | string HSourceBillNo = ""; |
| | | string HSourceBillType = ""; |
| | | Int64 HKFPeriod = 0; |
| | | string HKFDate = ""; |
| | | string HKFDQDate = ""; |
| | | string HWei = ""; |
| | | string HMTONO = ""; |
| | | string HBarCode = ""; |
| | | string HBarCodeType = ""; |
| | | Int64 HMaterID = 0; |
| | | Int64 HUnitID = 0; |
| | | double HQty2 = 0; |
| | | string HBatchNo = ""; |
| | | Int64 HSupID = 0; |
| | | Int64 HGroupID = 0; |
| | | int HPrintQty = 0; |
| | | Int64 HSourceInterID = 0; |
| | | Int64 HSourceEntryID = 0; |
| | | string HSourceBillNo = ""; |
| | | string HSourceBillType = ""; |
| | | Int64 HKFPeriod = 0; |
| | | string HKFDate = ""; |
| | | string HKFDQDate = ""; |
| | | string HWei = ""; |
| | | string HMTONO = ""; |
| | | oCn.BeginTran(); |
| | | foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2) |
| | | { |
| | |
| | | |
| | | } |
| | | |
| | | |
| | | [Route("GetHBarCodeShowBillMainBycg")] |
| | | /// <summary> |
| | | /// 条码生成表头(采购订单) |
| | | /// </summary> |
| | | /// <param name="sMsg"></param> |
| | | /// <returns></returns> |
| | | public object GetHBarCodeShowBillMainBycg(string sMsg) |
| | | { |
| | | try |
| | | { |
| | | DataSet ds; |
| | | string s = ""; |
| | | string ShowItem = " * ";//显示的字段 |
| | | if (DBUtility.ClsPub.isLong(sMsg) == 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill(); |
| | | string sql = string.Format(@"select * from h_v_Cg_POOrderBillMain_ForWeb2 where HInterID = " + sMsg); |
| | | ds = oCn.RunProcReturn(sql, "h_v_Cg_POOrderBillMain_ForWeb2"); |
| | | //ds = oClsWeb_BarCodeBill.ShowBillMain1(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 10000; |
| | | objjson.Message = "获取成功"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + e.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | [Route("GetHBarCodeShowBillSubBycg")] |
| | | [HttpGet] |
| | | /// <summary> |
| | | /// 条码生成表体(采购订单) |
| | | /// </summary> |
| | | /// <param name="sMsg"></param> |
| | | /// <returns></returns> |
| | | public object GetHBarCodeShowBillSubBycg(string sMsg) |
| | | { |
| | | try |
| | | { |
| | | DataSet ds; |
| | | string s = ""; |
| | | string ShowItem = " * ";//显示的字段 |
| | | if (DBUtility.ClsPub.isLong(sMsg) == 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill(); |
| | | string sql = string.Format(@"select * from h_v_Cg_POOrderBillSub_ForWeb2 where HInterID = " + sMsg); |
| | | ds = oCn.RunProcReturn(sql, "h_v_Cg_POOrderBillSub_ForWeb2"); |
| | | //ds = oClsWeb_BarCodeBill.ShowBillSub(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 10000; |
| | | objjson.Message = "获取成功"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + e.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | } |
| | | } |