1

沈泽

2021-10-25 be7d60d084799979d9b257eb3670b8998e3e58bc

 WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs

@@ -114,7 +114,7 @@
        public object DeltetXt_DataDictionary_Table(string HItemID)
        {
            DataSet ds;
            DataSet ds1;
            //DataSet ds1;
            try
            {
                //删除权限
@@ -146,15 +146,15 @@
                    objJsonResult.data = null;
                    return objJsonResult; ;
                }
                ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table  Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table");
                if (ds1.Tables[0].Rows.Count != 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "此项目存在子项目，不能删除！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table  Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table");
                //if (ds1.Tables[0].Rows.Count != 0)
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "此项目存在子项目，不能删除！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
               
              
                oCN.RunProc("delete from Xt_DataDictionary_Table where HItemID=" + HItemID);
@@ -285,7 +285,7 @@
                ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" +
                ",HModifyEmp" +
                ") " +
                " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HTableName + "'"+
                " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'"+
                ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" +
                ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" +
                ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" +
@@ -328,7 +328,7 @@
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();
                string msg3 = sArray[1].ToString();
                //string msg3 = sArray[1].ToString();
                //string msg4 = sArray[2].ToString();
                //string msg5 = sArray[3].ToString();
                //反序列化
@@ -362,7 +362,7 @@
                ",HFieldName,HFieldCaption,HDataType,HDefaultValue,HRemark" +
                ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" +
                ",HModifyEmp" +
                ") " + " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HTableName + "'" +
                ") " + " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'" +
                ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" +
                ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" +
                ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" +
@@ -378,19 +378,18 @@
                    oCN.RunProc("Update Xt_DataDictionary_Table set " +
                        " HModNameID= "+ HModNameID +
                        " HBillTypeID= " + HBillTypeID +
                        " HBillTypeID= " + HBillTypeID +
                        ",HTableName='" + HTableName + "'" +
                        ",HTableCaption='" + HTableCaption + "'" +
                        ",HFieldName='" + HFieldName + "'" +
                        ",HDataType='" + HDataType + "'" +
                        ",HFieldName='" + HFieldName + "'" +
                        ",HFieldCaption='" + HFieldCaption + "'" +
                        ",HRemark='" + HRemark + "'" +
                        //",HRemark='" + HRemark + "'" +
                        ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
                        ",HMakeTime='" + HMakeTime + "'" +
                        ",HMakeEmp='" + HMakeEmp + "'" +
                        ",HModifyTime='" + HModifyTime + "'" +
                        ",HModifyEmp='" + HModifyEmp + "'" +
                        ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
                        //",HUpdater='" + HUpdater + "'" +
                        //",HUpdateDate= getdate()" +
                        ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);