智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
duhe
2025-09-18 ce6cc4e378c7428dc0c77728a8c3447373b79685 
 WebAPI/Controllers/»ªÔ¶datamapping/QC_CheckNote_PNL_TempController.cs


@@ -142,7 +142,7 @@


                int HPosition_x = list[0].HPosition_x;


                int HPosition_y = list[0].HPosition_y;


                string HCheckProc = list[0].HCheckProc;


                short HPageIndex = list[0].HPageIndex;


                string HPageIndex = list[0].HPageIndex;


                string HBadReason = list[0].HBadReason;


                string HMaker = list[0].HMaker;


                DateTime HMakeDate = list[0].HMakeDate;


@@ -203,7 +203,7 @@


                sb.Append("N'" + HPageIndex + "',");


                sb.Append("N'" + HBadReason + "',");


                sb.Append("N'" + HMaker + "',");


                sb.Append("N'" + HMakeDate + "')");


                sb.Append("N'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')");




                string sql = sb.ToString();


                sb.Clear();


@@ -232,6 +232,130 @@


                    return objJsonResult;


                }


                //=========================================================




                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "新增成功！";


                //objJsonResult.data = null;


                return objJsonResult;


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.Message;


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion




        #region æ‰¹é‡æ·»åŠ QC_CheckNote_PNL_Temp


        [Route("QC_CheckNote_PNL_TempController/BatchAddBill")]


        [HttpPost]


        public object BatchAddBill([FromBody] JObject oMain)


        {


            try


            {


                var _value = oMain["oMain"].ToString();


                string msg1 = _value.ToString();


                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


                string msg2 = sArray[0].ToString();


                string msg3 = sArray[1].ToString();//当前人




                //判断权限


                if (!ClsPub.Security_Log("QC_CheckNote_PNL_Temp_Edit", 1, false, msg3))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "没有修改权限！";


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //反序列化


                //msg2 = "[" + msg2.ToString() + "]";


                List<Models.ClsQC_CheckNote_PNL_Temp> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsQC_CheckNote_PNL_Temp>>(msg2);




                oCN.BeginTran();


                for (int i = 0; i < list.Count; i++)


                {


                    int HItemID = list[i].HItemID;


                    string HBarCode = list[i].HBarCode;


                    string HSetNo = list[i].HSetNo;


                    string HPCSNo = list[i].HPCSNo;


                    int HPosition_x = list[i].HPosition_x;


                    int HPosition_y = list[i].HPosition_y;


                    string HCheckProc = list[i].HCheckProc;


                    string HPageIndex = list[i].HPageIndex;


                    string HBadReason = list[i].HBadReason;


                    string HMaker = list[i].HMaker;


                    DateTime HMakeDate = list[i].HMakeDate;




                    DataSet ds_editCheck;


                    //保存前控制=========================================


                    ds_editCheck = oCN.RunProcReturn("Exec h_p_QC_CheckNote_PNL_Temp_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_QC_CheckNote_PNL_Temp_BeforeSaveCtrl");


                    if (ds_editCheck == null)


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "保存前判断失败！";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //=========================================================




                    StringBuilder sb = new StringBuilder();


                    sb.Append("Insert Into QC_CheckNote_PNL_Temp(HBarCode, HSetNo, HPCSNo, HPosition_x,HPosition_y,HCheckProc,HPageIndex ,HBadReason, HMaker, HMakeDate) Values(");


                    sb.Append("N'" + HBarCode + "',");


                    sb.Append("N'" + HSetNo + "',");


                    sb.Append("N'" + HPCSNo + "',");


                    sb.Append("N'" + HPosition_x + "',");


                    sb.Append("N'" + HPosition_y + "',");


                    sb.Append("N'" + HCheckProc + "',");


                    sb.Append("N'" + HPageIndex + "',");


                    sb.Append("N'" + HBadReason + "',");


                    sb.Append("N'" + HMaker + "',");


                    sb.Append("N'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')");


                    string sql = sb.ToString();


                    sb.Clear();


                    ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");




                    //保存后控制=========================================


                    ds_editCheck = oCN.RunProcReturn("Exec h_p_QC_CheckNote_PNL_Temp_AfterSaveCtrl " + msg3 + ",'1'", "h_p_QC_CheckNote_PNL_Temp_AfterSaveCtrl");


                    if (ds_editCheck == null)


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "保存后判断失败！";


                        objJsonResult.data = null;


                        return objJsonResult;




                    }


                    if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")


                    {


                        oCN.RollBack();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    //=========================================================


                }




                oCN.Commit();


                objJsonResult.code = "1";


@@ -362,7 +486,7 @@


                int HPosition_x = list[0].HPosition_x;


                int HPosition_y = list[0].HPosition_y;


                string HCheckProc = list[0].HCheckProc;


                short HPageIndex = list[0].HPageIndex;


                string HPageIndex = list[0].HPageIndex;


                string HBadReason = list[0].HBadReason;


                string HMaker = list[0].HMaker;


                DateTime HMakeDate = list[0].HMakeDate;