智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
仲国强
2021-09-09 352c66a579a8ec5c60ecbc7dd3b79bf591f6002e 
 WebAPI/Controllers/BaseSet/Gy_GroupController.cs


@@ -150,14 +150,14 @@


                msg1 = "[" + msg1.ToString() + "]";


                DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();


                List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1);


                long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID;


                long HItemID = list[0].HItemID;


                string HNumber = list[0].HNumber;


                string HName = list[0].HName;


                string HShortNumber = list[0].HShortNumber;


                long HParentID = list[0].HParentID;


                string HHelpCode = list[0].HHelpCode;


                string HRemark = list[0].HRemark;


                string HStopflag = list[0].HStopflag == "True" ? "1" : "0";


                bool HStopflag = list[0].HStopflag;


                string HUseFlag = list[0].HUseFlag;


                var HEmpQty = list[0].HEmpQty;


                var HBarCodeForBase = list[0].HBarCodeForBase;


@@ -182,7 +182,7 @@


                   ",HDeptNumber,HEmpQty" +


                   ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" +


                   ",HProcID) " +


                   " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HItemID.ToString() +


                   " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +


                   ",'" + HDeptNumber + "'," + HEmpQty +


                   ",'" + HLevel.ToString() + "'," + HEndFlag + "," + HStopflag +


                   ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "','" + HProcID + "')";


@@ -210,22 +210,29 @@


            }


        }


        /// <summary>


        /// 修改单据-保存按钮


        /// 保存按钮


        ///参数：string sql。


        ///返回值：object。


        /// </summary>


        [Route("Gy_Group/EditBill")]


        [Route("Gy_Group/ModifyByID")]


        [HttpPost]


        public object EditBill([FromBody] JObject oMain)


        public object ModifyByID([FromBody] JObject oMain)


        {


            try


            {


                DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();


                DAL.ClsGy_Group_View oDeptHlp = new DAL.ClsGy_Group_View();




                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();


                //string msg4 = sArray[2].ToString();


                //string msg5 = sArray[3].ToString();


                //反序列化


                msg1 = "[" + msg1.ToString() + "]";


                DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();


                List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1);


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


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




                long HItemID = list[0].HItemID;


                string HNumber = list[0].HNumber;


@@ -234,14 +241,19 @@


                long HParentID = list[0].HParentID;


                string HHelpCode = list[0].HHelpCode;


                string HRemark = list[0].HRemark;


                string HStopflag = list[0].HStopflag;


                bool HStopflag = list[0].HStopflag;


                bool HEndFlag = list[0].HEndFlag;


                string HUseFlag = list[0].HUseFlag;


                var HEmpQty = list[0].HEmpQty;


                var HBarCodeForBase = list[0].HBarCodeForBase;


                var HDeptID = list[0].HDeptID;


                var HProcID = list[0].HProcID;


                long HProcID = list[0].HProcID;


                var HDeptNumber = "";


                //var HEndFlag = 0;


                long HLevel = 1;


                //var HProcID = "";




                //判断权限


                ////判断权限


                //if (!ClsPub.Security_Log(msg5, 1, true, msg4))


                //{


                //    objJsonResult.code = "0";


@@ -250,6 +262,7 @@


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}




                //if (!DBUtility.ClsPub.AllowNumber(HNumber))


                //{


                //    objJsonResult.code = "0";


@@ -258,6 +271,7 @@


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}




                //if (oDept.HavSameNumber(HItemID, HNumber))


                //{


                //    objJsonResult.code = "0";


@@ -266,31 +280,46 @@


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                //若MAINDI重复则重新获取


                oCN.BeginTran();


                //主表


                oCN.RunProc("Update Gy_Group set " +


                    " HNumber='" + HNumber + "'" +


                    ",HName='" + HName + "'" +


                    ",HShortNumber='" + HShortNumber + "'" +


                    ",HHelpCode='" + HHelpCode + "'" +


                    ",HParentID=" + HParentID +


                    ",HStopflag='" + HStopflag + "'" +


                    ",HRemark= '" + HRemark + "'" +


                    ",HDeptID=" + HDeptID +


                    ",HEmpQty=" + HEmpQty +


                    ",HBarCodeForBase='" + HBarCodeForBase + "' " +


                    ", HProcID = '" + HProcID + "'  Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


                //修改子项目代码


                //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Group,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);


                //将上级 为非末级


                //oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


                //


                oCN.Commit();


                objJsonResult.code = "1";


                //保存


                //保存完毕后处理


                if (HItemID == 0)


                {


                    oCN.BeginTran();


                    oCN.RunProc("Insert into Gy_Group " +


                    " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                    ",HEmpQty,HDeptID,HDeptNumber,HProcID" +


                    ",HLevel,HEndFlag,HStopflag,HRemark,HBarCodeForBase) " +


                    " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +


                    "," + HEmpQty.ToString() + "," + HDeptID.ToString() + ",'" + HDeptNumber + "'," + HProcID.ToString() +


                    "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "','" + HBarCodeForBase + "')", ref DBUtility.ClsPub.sExeReturnInfo);


                    //修改上级为非末级代码


                    oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


                    oCN.Commit();


                }


                else


                {


                    //若MAINDI重复则重新获取


                    oCN.BeginTran();


                    oCN.RunProc("Update Gy_Group set " + 


                                 " HNumber='" + HNumber + "'" +


                                 ",HName='" + HName + "'" +


                                 ",HShortNumber='" + HShortNumber + "'" +


                                 ",HHelpCode='" + HHelpCode + "'" +


                                 ",HParentID=" + HParentID +


                                 ",HStopflag='" + HStopflag + "'" +


                                 ",HRemark= '" + HRemark + "'" +


                                 ",HDeptID=" + HDeptID +


                                 ",HEmpQty=" + HEmpQty +


                                 ",HBarCodeForBase='" + HBarCodeForBase + "' " +


                                 ", HProcID = '" + HProcID + "'  Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


                    oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


                    oCN.Commit();


                }


                objJsonResult.code = "0";


                objJsonResult.count = 1;


                objJsonResult.Message = "修改单据成功！";


                //objJsonResult.data = null;


                objJsonResult.Message = "保存成功！";


                //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");


                objJsonResult.data = 1;


                return objJsonResult;


            }


            catch (Exception e)


@@ -303,6 +332,100 @@


                return objJsonResult;


            }


        }


        ///// <summary>


        ///// 修改单据-保存按钮


        /////参数：string sql。


        /////返回值：object。


        ///// </summary>


        //[Route("Gy_Group/EditBill")]


        //[HttpPost]


        //public object EditBill([FromBody] JObject oMain)


        //{


        //    try


        //    {


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


        //        string msg1 = _value.ToString();


        //        //反序列化


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


        //        DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl();


        //        List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1);




        //        long HItemID = list[0].HItemID;


        //        string HNumber = list[0].HNumber;


        //        string HName = list[0].HName;


        //        string HShortNumber = list[0].HNumber;


        //        long HParentID = list[0].HParentID;


        //        string HHelpCode = list[0].HHelpCode;


        //        string HRemark = list[0].HRemark;


        //        string HStopflag = list[0].HStopflag;


        //        string HUseFlag = list[0].HUseFlag;


        //        var HEmpQty = list[0].HEmpQty;


        //        var HBarCodeForBase = list[0].HBarCodeForBase;


        //        var HDeptID = list[0].HDeptID;


        //        var HProcID = list[0].HProcID;




        //        //判断权限


        //        //if (!ClsPub.Security_Log(msg5, 1, true, msg4))


        //        //{


        //        //    objJsonResult.code = "0";


        //        //    objJsonResult.count = 0;


        //        //    objJsonResult.Message = "没有找到该功能模块！";


        //        //    objJsonResult.data = null;


        //        //    return objJsonResult;


        //        //}


        //        //if (!DBUtility.ClsPub.AllowNumber(HNumber))


        //        //{


        //        //    objJsonResult.code = "0";


        //        //    objJsonResult.count = 0;


        //        //    objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";


        //        //    objJsonResult.data = null;


        //        //    return objJsonResult;


        //        //}


        //        //if (oDept.HavSameNumber(HItemID, HNumber))


        //        //{


        //        //    objJsonResult.code = "0";


        //        //    objJsonResult.count = 0;


        //        //    objJsonResult.Message = "代码重复！";


        //        //    objJsonResult.data = null;


        //        //    return objJsonResult;


        //        //}


        //        //若MAINDI重复则重新获取


        //        oCN.BeginTran();


        //        //主表


        //        oCN.RunProc("Update Gy_Group set " +


        //            " HNumber='" + HNumber + "'" +


        //            ",HName='" + HName + "'" +


        //            ",HShortNumber='" + HShortNumber + "'" +


        //            ",HHelpCode='" + HHelpCode + "'" +


        //            ",HParentID=" + HParentID +


        //            ",HStopflag='" + HStopflag + "'" +


        //            ",HRemark= '" + HRemark + "'" +


        //            ",HDeptID=" + HDeptID +


        //            ",HEmpQty=" + HEmpQty +


        //            ",HBarCodeForBase='" + HBarCodeForBase + "' " +


        //            ", HProcID = '" + HProcID + "'  Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


        //        //修改子项目代码


        //        //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Group,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);


        //        //将上级 为非末级


        //        //oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


        //        //


        //        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;


        //    }


        //}


        /// <summary>


        /// 班组删除功能


        /// </summary>