| | |
| | | //} |
| | | #endregion |
| | | |
| | | #region[批量新增单据-保存按钮] |
| | | /// <summary> |
| | | /// 新增单据-保存按钮 |
| | | ///参数:string sql。 |
| | | ///返回值:object。 |
| | | /// </summary> |
| | | [Route("Sc_ProcessExchangeBill/AddBill_pl")] |
| | | [HttpPost] |
| | | public object AddBill_pl([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString();//主表 |
| | | string msg3 = sArray[1].ToString();//单据号及数量 |
| | | string msg4 = sArray[2].ToString();//工艺路线 |
| | | string msg5 = sArray[3].ToString();//类型 |
| | | string msg6 = sArray[4].ToString();//用户 |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | |
| | | try |
| | | { |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, msg6)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "无保存权限!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //单据号 及数量 |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | List<Model.ClsSc_ProcessExchangeBillMain> ListHbillNo = new List<Model.ClsSc_ProcessExchangeBillMain>(); |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | ListHbillNo = JsonConvert.DeserializeObject<List<Model.ClsSc_ProcessExchangeBillMain>>(msg3); |
| | | |
| | | //主表信息 |
| | | Model.ClsSc_ProcessExchangeBillMain Main = new Model.ClsSc_ProcessExchangeBillMain(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | Main = JsonConvert.DeserializeObject<Model.ClsSc_ProcessExchangeBillMain>(msg2); |
| | | |
| | | DBUtility.ClsPub.CurUserName = msg6; |
| | | Main.HMaker = msg6; //制单人 |
| | | Main.HBillType = "3772"; |
| | | Main.HBillSubType = "3772"; |
| | | Main.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | Main.HMaterID = Main.HMaterID2; |
| | | if (DBUtility.ClsPub.isStrNull(Main.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!没有单据日期,无法保存!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //表体数据 |
| | | //按 },{来拆分数组 //去掉【和】 |
| | | msg4 = msg4.Substring(1, msg4.Length - 2); |
| | | msg4 = msg4.Replace("\\", ""); |
| | | msg4 = msg4.Replace("\n", ""); //\n |
| | | List<Model.ClsSc_ProcessExchangeBillSub> ls = new List<Model.ClsSc_ProcessExchangeBillSub>(); |
| | | ls = oListModels.getObjectByJson_Sc_ProcessExchangeBillSub(msg4); |
| | | |
| | | //循环新增单据 |
| | | for (int i = 0; i < ListHbillNo.Count; i++) |
| | | { |
| | | Main.HBillNo = ListHbillNo[i].HBillNo; |
| | | Main.HQty = ListHbillNo[i].HQty; |
| | | oBill.omodel = Main; |
| | | |
| | | int j = 0; |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oItemSub in ls) |
| | | { |
| | | j++; |
| | | oItemSub.HEntryID = j; |
| | | oItemSub.HQty = Main.HQty; |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oBill.DetailColl.Add(oItemSub); |
| | | } |
| | | //保存 |
| | | //保存完毕后处理 |
| | | bool bResult=false; |
| | | if (msg5 == "2") |
| | | { |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | oBill.DetailColl.Clear(); |
| | | if (!bResult) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "保存成功!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region 工序流转卡列表显示器具清单信息 |
| | | [Route("Sc_ProcessExchangeBillList/QJQD")] |
| | | [HttpGet] |