测试器具加设备

zzr99

2021-10-21 c0e0cc4fa24c38785054ec759f0fee75a3bae5f7

 WebAPI/Controllers/SBGL/Gy_EquipTypeController.cs

@@ -28,7 +28,7 @@
        {
            try
            {
                ds = Sc_GetEquipTypeList(sWhere);
                ds = oCN.RunProcReturn("select HItemID,HParentID,HNumber,HName,HLevel, case when HEndFlag<>0 then 'Y'else ' 'end HEndFlag,case when HStopFlag <> 0 then 'Y'else ' 'end HStopFlag, HRemark, HUseFlag from Gy_EquipFileType where 1=1 " + sWhere, "Gy_EquipFileType");
                if (ds == null)
                {
                    objJsonResult.code = "0";
@@ -54,21 +54,6 @@
                objJsonResult.data = null;
                return objJsonResult;
            }
        }

        public static DataSet Sc_GetEquipTypeList(string sWhere)
        {
            string sql1 = string.Format(@"select * from h_v_Gy_EquipTypeList");
            if (sWhere == null || sWhere.Equals(""))
            {
                return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by HItemID desc", "h_v_Gy_EquipTypeList");
            }
            else
            {
                string sql = sql1 + sWhere + " order by HItemID desc";
                return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_EquipTypeList");
            }

        }

        #endregion
@@ -122,91 +107,165 @@

        #endregion

        #region 设备分类保存/编辑
        [Route("Gy_EquipType/SaveEquipTypeList")]
        #region 模治具分类新增保存
        /// <summary>
        /// 模治具分类-保存按钮
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_EquipType/AddBill")]
        [HttpPost]
        public object SaveEquipTypeList([FromBody] JObject msg)
        public object AddBill([FromBody] JObject oMain)
        {
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string refSav = sArray[1].ToString();

            ListModels oListModels = new ListModels();
            try
            {
                DLL.ClsGy_EquipTypeBill oBill = new DLL.ClsGy_EquipTypeBill();
                List<Models.ClsGy_EquipFileType> lsmain = new List<Models.ClsGy_EquipFileType>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_Gy_EquipFileType(msg2);
                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();

                long HItemID = lsmain[0].HItemID;
                string HNumber = lsmain[0].HNumber;
                string HName = lsmain[0].HName;
                string HShortNumber = lsmain[0].HNumber;
                long HParentID = lsmain[0].HParentID;
                long HLevel = lsmain[0].HLevel;
                string HHelpCode = lsmain[0].HHelpCode;
                string HRemark = lsmain[0].HRemark;
                bool HStopflag = lsmain[0].HStopflag;
                string HUseFlag = lsmain[0].HUseFlag;
                bool HEndFlag = lsmain[0].HEndFlag;
                //反序列化
                msg2 = "[" + msg2.ToString() + "]";

                if (refSav == "Add")
                List<Models.ClsGy_EquipFileType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileType>>(msg2);

                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                string HShortNumber = list[0].HNumber;
                long HParentID = list[0].HParentID;
                long HLevel = list[0].HLevel;
                string HHelpCode = list[0].HHelpCode;
                string HRemark = list[0].HRemark;
                bool HStopflag = list[0].HStopflag;
                string HUseFlag = list[0].HUseFlag;
                bool HEndFlag = list[0].HEndFlag;


                if (!DBUtility.ClsPub.AllowNumber(HNumber))
                {
                        //若MAINDI重复则重新获取
                        oCN.BeginTran();
                        //主表
                        oCN.RunProc("Insert into Gy_EquipFileType " +
                           " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                           ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime) " +
                           " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID +
                           "," + HLevel + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo);
                        //修改上级为非末级代码
                        oCN.RunProc("Update Gy_EquipFileType 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;
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (refSav == "Update")
                {
                        oCN.BeginTran();
                        //主表
                        oCN.RunProc("Update Gy_EquipFileType set " +
                            " HNumber='" + HNumber + "'" +
                            ",HName='" + HName + "'" +
                            ",HShortNumber='" +HShortNumber + "'" +
                            ",HHelpCode='" + HHelpCode + "'" +
                            ",HParentID=" + HParentID +
                            ",HStopflag='" + HStopflag + "'" +
                            ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                        //修改子项目代码
                        //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
                        //将上级 为非末级
                        oCN.RunProc("Update Gy_EquipFileType 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;
                }



                //若MAINDI重复则重新获取
                oCN.BeginTran();
                //主表
                oCN.RunProc("Insert into Gy_EquipFileType " +
                   " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                   ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime) " +
                   " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID +
                   "," + HLevel + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
                oCN.RunProc("Update Gy_EquipFileType 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 = "保存失败！" + e.ToString();
                objJsonResult.data = 1;
                objJsonResult.Message = "Exception！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
            return false;
        }
        #endregion

        #region 模治具分类修改保存
        /// <summary>
        /// 修改单据-保存按钮
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_EquipType/EditBill")]
        [HttpPost]
        public object EditBill([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();

                //反序列化
                msg2 = "[" + msg2.ToString() + "]";
                List<Models.ClsGy_EquipFileType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_EquipFileType>>(msg2);

                long HItemID = int.Parse(msg3);
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                string HShortNumber = list[0].HNumber;
                long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID;
                string HHelpCode = list[0].HHelpCode;
                string HRemark = list[0].HRemark;
                bool HStopflag = list[0].HStopflag;
                string HUseFlag = list[0].HUseFlag;

                if (!DBUtility.ClsPub.AllowNumber(HNumber))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                DataSet DS = oCN.RunProcReturn("Select * from Gy_EquipFileType Where HStopflag=0 and HNumber='" + HItemID + "' and HItemID<>" + HNumber, "Gy_EquipFileType", ref Pub_Class.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count != 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }


                //若MAINDI重复则重新获取
                oCN.BeginTran();
                //主表
                oCN.RunProc("Update Gy_EquipFileType set " +
                    " HNumber='" + HNumber + "'" +
                    ",HName='" + HName + "'" +
                    ",HShortNumber='" + HShortNumber + "'" +
                    ",HHelpCode='" + HHelpCode + "'" +
                    ",HParentID=" + HParentID +
                    ",HStopflag='" + HStopflag + "'" +
                    ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                //修改子项目代码
                //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
                //将上级 为非末级
                oCN.RunProc("Update Gy_EquipFileType 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;
            }
        }
        #endregion