基础资料 项目阶段和列表

duhe

2023-07-06 ee9154e9095cc830b1a80811930ca53a0705be0b

 WebAPI/Controllers/ÏîÄ¿¹ÜÀí/ÏîÄ¿½×¶Î/Gy_ProjectStageController.cs

@@ -1,5 +1,6 @@
using DBUtility;
using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
@@ -20,7 +21,7 @@



        #region é¡¹ç›®é˜¶æ®µ æ–°å¢ž
        #region é¡¹ç›®é˜¶æ®µ æ–°å¢ž/编辑
        #region é¡¹ç›®é˜¶æ®µ æ–°å¢ž/编辑 ä¿¡æ¯åˆ—表
        public class Gy_ProjectStage_eidt_add
        {
@@ -28,7 +29,7 @@
            public string HNumber;
            public string HName;
            public long HParentID;
            public bool HStopFlag;
            public bool HStopflag;
            public string HRemark;
            public string HHelpCode;
            public int HUSEORGID;
@@ -43,9 +44,9 @@
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_ProjectStage/AddNew")]
        [Route("Gy_ProjectStage/AddNewProjectStage")]
        [HttpPost]
        public object AddNew([FromBody] JObject oMain)
        public object AddNewProjectStage([FromBody] JObject oMain)
        {
            try
            {
@@ -58,15 +59,15 @@
                string msg2 = sArray[0].ToString();
                string user = sArray[1].ToString();//用户名

                ////判断是否有编辑权限
                //if (!DBUtility.ClsPub.Security_Log("Gy_Process_Edit", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无权限编辑!";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //判断是否有编辑权限
                if (!DBUtility.ClsPub.Security_Log("PM_ProjectStage_edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无权限编辑!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //string msg3 = sArray[1].ToString();
                //string msg4 = sArray[2].ToString();
@@ -84,7 +85,7 @@
                long HParentID = list[0].HParentID;
                long HLevel = ClsPub.GetLevel(list[0].HNumber.Trim());
                bool HEndFlag = true;
                bool HStopFlag = list[0].HStopFlag;
                bool HStopflag = list[0].HStopflag;
                string HRemark = list[0].HRemark;
                string HHelpCode = list[0].HHelpCode;
                string HMakeEmp = user;
@@ -109,7 +110,7 @@
                        "," + HParentID.ToString() + "" +
                        "," + HLevel.ToString() + "" +
                        "," + Convert.ToString(HEndFlag ? 1 : 0) + "" +
                        "," + Convert.ToString(HStopFlag ? 1 : 0) + "" +
                        "," + Convert.ToString(HStopflag ? 1 : 0) + "" +
                        ",'" + HRemark + "'" +
                        ",'" + HHelpCode + "'" +
                        ",'" + HMakeEmp + "'" +
@@ -128,42 +129,29 @@
                else
                {
                    ////若MAINDI重复则重新获取
                    //oCN.BeginTran();
                    //oCN.RunProc("Update Gy_Process set " +
                    //    " HNumber='" + HNumber + "'" +
                    //    ",HName='" + HName + "'" +
                    //    ",HHelpCode='" + HHelpCode + "'" +
                    //    ",HShortNumber='" + HShortNumber + "'" +
                    //    ",HParentID= " + HParentID +
                    //    ",HTypeFlow= '" + HTypeFlow + "'" +
                    //    ",HTypeCount= '" + HTypeCount + "'" +
                    //    ",HDeptNumber='" + HDeptNumber + "'" +
                    //    ",HSNo= " + HSNo +
                    //    ",HLevel= " + HLevel +
                    //    ",HEndFlag= '" + HEndFlag + "'" +
                    //    ",HTProcessFlag= '" + HTProcessFlag + "'" +
                    //    ",HStopflag= '" + HStopflag + "'" +
                    //    ",HRemark='" + HRemark + "'" +
                    //    ",HDeptID= " + HDeptID +
                    //    ",HBarCodeForBase='" + HBarCode + "'" +
                    //    ",HProcessID_K3= " + HProcessID_K3 +
                    //    ",HBillSubType='" + HBillSubType + "'" +
                    //    ",HAutoTrunFlag= '" + HAutoTrunFlag + "'" +
                    //    ",HFixPrice= " + HFixPrice +
                    //    ",HOverFixPrice= " + HOverFixPrice +
                    //    ",HProcMulID= " + HProcMulID +
                    //    ",HWorkCenterID= " + HWorkCenterID +
                    //    ",HBadWHID= " + HBadWHID +
                    //    ",HWasterWHID= " + HWasterWHID +
                    //    ",HBadCountDevelopWHID= " + HBadCountDevelopWHID +
                    //    ",HWWBadWHID= " + HWWBadWHID +
                    //    ",HWWWasterWHID= " + HWWWasterWHID +
                    //    ",HWHID= " + HWHID +
                    //    ",HProcCheckNote='" + HProcCheckNote + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                    ////修改上级为非末级代码
                    //oCN.RunProc("Update Gy_Process set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    ////
                    //oCN.Commit();
                    oCN.BeginTran();
                    string sql = "Update Gy_ProjectStage set " +
                        "HNumber='" + HNumber + "'" +
                        ",HName='" + HName + "'" +
                        ",HShortNumber='" + HShortNumber + "'" +
                        ",HParentID=" + HParentID.ToString() + "" +
                        ",HLevel=" + HLevel.ToString() + "" +
                        ",HEndFlag=" + Convert.ToString(HEndFlag ? 1 : 0) + "" +
                        ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + "" +
                        ",HRemark='" + HRemark + "'" +
                        ",HHelpCode='" + HHelpCode + "'" +
                        ",HMakeEmp='" + HMakeEmp + "'" +
                        ",HUSEORGID=" + HUSEORGID + "" +
                        ",HStageNote='" + HStageNote + "'" +
                        ",HRelationGoods='" + HRelationGoods + "'" +
                        ",HIsKey=" + Convert.ToString(HIsKey ? 1 : 0) + "" +
                        ",HRate=" + HRate + "" +
                        " where HItemID=" + HItemID;
                    oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo);
                    //修改上级为非末级代码
                    oCN.RunProc("Update Gy_ProjectStage set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    //
                    oCN.Commit();
                }
                objJsonResult.code = "0";
                objJsonResult.count = 1;
@@ -183,5 +171,190 @@
            }
        }
        #endregion

        #region é¡¹ç›®é˜¶æ®µ æŸ¥è¯¢
        /// <summary>
        /// è¿”回项目阶段列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_ProjectStage/list")]
        [HttpGet]
        public object getProjectStageList(string sWhere, string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                //查看权限
                //if (!DBUtility.ClsPub.Security_Log("Gy_ProjectStage_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无查看权限！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from Gy_ProjectStage order by HNumber ", "Gy_ProjectStage");
                }
                else
                {
                    string sql1 = "select * from Gy_ProjectStage where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HNumber ";
                    ds = oCN.RunProcReturn(sql, "Gy_ProjectStage");
                }

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region é¡¹ç›®é˜¶æ®µ æŸ¥è¯¢æŒ‡å®šé¡¹ç›®é˜¶æ®µè®°å½•
        /// <summary>
        /// æ ¹æ®åŸºç¡€èµ„æ–™ID æŸ¥æ‰¾è®°å½•
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_ProjectStage/cx")]
        [HttpGet]
        public object cx(long HInterID)
        {
            try
            {

                ds = oCN.RunProcReturn("select * from Gy_ProjectStage where HitemID=" + HInterID, "Gy_ProjectStage");

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region é¡¹ç›®é˜¶æ®µ åˆ é™¤
        /// <summary>
        /// é¡¹ç›®é˜¶æ®µåˆ—表删除功能
        /// </summary>
        /// <returns></returns>
        [Route("DeltetGy_ProjectStage")]
        [HttpGet]
        public object DeltetGy_ProjectStage(string HItemID, string user)
        {
            DataSet ds;
            DataSet ds1;
            try
            {
                //删除权限
                if (!DBUtility.ClsPub.Security_Log("PM_ProjectStage_delete", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无删除权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (string.IsNullOrWhiteSpace(HItemID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HItemID为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.BeginTran();//开始事务
                ds = oCN.RunProcReturn("select * from Gy_ProjectStage where HItemID=" + HItemID, "Gy_ProjectStage");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有数据，无法删除！";
                    objJsonResult.data = null;
                    return objJsonResult; ;
                }
                //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]);
                //if (HStopflag)
                //{
                //    oCN.RollBack();//回滚事务
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "数据已删除无法再次删除！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                ds1 = oCN.RunProcReturn("Select HItemID from  Gy_ProjectStage  Where HParentID='" + HItemID + "'", " Gy_ProjectStage");
                if (ds1.Tables[0].Rows.Count != 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "此项目存在子项目，不能删除！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]);
                if (HUseFlag == "已使用")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "此项目已使用，不能删除！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.RunProc("delete from  Gy_ProjectStage  where HItemID=" + HItemID);
                oCN.Commit();//提交事务
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "* æ•°æ®åˆ é™¤æˆåŠŸï¼";
                objJsonResult.data = null;
                return objJsonResult; ;

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
    }
}