1

duhe

2023-07-09 1e1425d8a7cfad573ff77f2cb3a84064bc056a81

 WebAPI/Controllers/项目管理/工程项目/PM_ProjectBillController.cs

@@ -227,7 +227,6 @@

                ds = oCN.RunProcReturn("select * from PM_ProjectBillMain where HInterID = " + HInterID + " and HBillNo = '" + HBillNo + "'", "PM_ProjectBillMain");

                oCN.BeginTran();
                if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//鏂板
                {
                    string sql = "insert into PM_ProjectBillMain" +
@@ -318,7 +317,6 @@
                objJsonResult = AddBillSub1(msg3, HInterID, HBillNo, OperationType);
                objJsonResult = AddBillSub2(msg4, HInterID, HBillNo, OperationType);

                oCN.Commit();

                if (objJsonResult.code == "0")
                {
@@ -469,12 +467,12 @@

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