项目管理：列表列名改为中文

duhe

2023-07-14 5a54c45733f6570db9476eb53fe840c312beb17f

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

@@ -106,7 +106,7 @@
                {
                    oCN.BeginTran();
                    string sql = "Insert into  Gy_ProjectStage" +
                        " (HNumber,HName,HShortNumber,HParentID,HLevel,HEndFlag,HStopflag,HRemark,HHelpCode,HMakeEmp,HUSEORGID,HStageNote,HRelationGoods,HIsKey,HRate) " +
                        " (HNumber,HName,HShortNumber,HParentID,HLevel,HEndFlag,HStopflag,HRemark,HHelpCode,HMakeEmp,HCREATEORGID,HStageNote,HRelationGoods,HIsKey,HRate) " +
                        " Values(" +
                        "'" + HNumber + "'" +
                        ",'" + HName + "'" +
@@ -146,8 +146,8 @@
                        ",HHelpCode='" + HHelpCode + "'" +
                        ",HMakeEmp='" + HMakeEmp + "'" +
                        ",HModifyEmp = '" + HModifyEmp + "'" +
                        ",HModifyTime = getDate()" + 
                        ",HUSEORGID=" + HUSEORGID + "" +
                        ",HModifyTime = getDate()" +
                        ",HCREATEORGID=" + HUSEORGID + "" +
                        ",HStageNote='" + HStageNote + "'" +
                        ",HRelationGoods='" + HRelationGoods + "'" +
                        ",HIsKey=" + Convert.ToString(HIsKey ? 1 : 0) + "" +
@@ -203,13 +203,13 @@

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from Gy_ProjectStage order by HNumber ", "Gy_ProjectStage");
                    ds = oCN.RunProcReturn("select * from h_v_Gy_ProjectStage order by é˜¶æ®µç¼–码 ", "h_v_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");
                    string sql1 = "select * from h_v_Gy_ProjectStage where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by é˜¶æ®µç¼–码 ";
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_ProjectStage");
                }

                //添加列名
@@ -846,13 +846,13 @@

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from PM_ProjectStageBillMain order by HBillNo desc ", "PM_ProjectStageBillMain");
                    ds = oCN.RunProcReturn("select * from h_v_PM_ProjectStageBill order by å•æ®å· desc", "h_v_PM_ProjectStageBill");
                }
                else
                {
                    string sql1 = "select * from PM_ProjectStageBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HBillNo desc ";
                    ds = oCN.RunProcReturn(sql, "PM_ProjectStageBillMain");
                    string sql1 = "select * from h_v_PM_ProjectStageBill where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by å•æ®å· desc";
                    ds = oCN.RunProcReturn(sql, "h_v_PM_ProjectStageBill");
                }

                //添加列名
@@ -1647,13 +1647,13 @@

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from PM_ProjectReportBillMain order by HBillNo desc ", "PM_ProjectReportBillMain");
                    ds = oCN.RunProcReturn("select * from h_v_PM_ProjectReportBillList order by å•æ®å· ", "h_v_PM_ProjectReportBillList");
                }
                else
                {
                    string sql1 = "select * from PM_ProjectReportBillMain where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by HBillNo desc ";
                    ds = oCN.RunProcReturn(sql, "PM_ProjectReportBillMain");
                    string sql1 = "select * from h_v_PM_ProjectReportBillList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by å•æ®å· ";
                    ds = oCN.RunProcReturn(sql, "h_v_PM_ProjectReportBillList");
                }

                //添加列名