blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zzr99
2021-11-25 6e3a6edf27dda15e99e0d0917eea77f561e7a18f 
 WebAPI/Controllers/SBGL/Sb_EquipMaintainBillController.cs


@@ -31,13 +31,13 @@


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_Sc_EquipMaintainPlan " + sWhere + " order by hmainid desc", "h_v_Sc_EquipMaintainPlan");


                    ds = oCN.RunProcReturn("select * from h_v_Sc_EquipMaintain " + sWhere + " order by hmainid desc", "h_v_Sc_EquipMaintain");


                }


                else


                {


                    string sql1 = "select * from h_v_Sc_EquipMaintainPlan where 1 = 1";


                    string sql1 = "select * from h_v_Sc_EquipMaintain where 1 = 1";


                    string sql = sql1 + sWhere + " order by hmainid desc";


                    ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintainPlan");


                    ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintain");


                }


                if (ds == null || ds.Tables[0].Rows.Count == 0)


                {


@@ -165,7 +165,7 @@


                msg4 = msg4.Substring(1, msg4.Length - 2);


                msg4 = msg4.Replace("\\", "");


                msg4 = msg4.Replace("\n", "");  //\n


                //msg2 = msg2.Replace("'", "’");


                                                //msg2 = msg2.Replace("'", "’");


                List<Model.ClsSb_EquipMaintainBillSub> ls1 = new List<Model.ClsSb_EquipMaintainBillSub>();


                ls1 = oListModels.getObjectByJson_Sb_EquipMaintainBillSub(msg4);


                int j = 0;


@@ -177,11 +177,11 @@


                    //oItemSub.HCloseMan = "";       //行关闭


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HCloseType = false;   //关闭类型


                    //oItemSub.HRemark = "";         //备注


                                                   //oItemSub.HRemark = "";         //备注


                    oItemSub.HSourceInterID = 0;     // 源单主内码


                    oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceBillNo = "";  //源单单号


                    //oItemSub.HSourceBillType = ""; //源单类型


                                                   //oItemSub.HSourceBillNo = "";  //源单单号


                                                   //oItemSub.HSourceBillType = ""; //源单类型


                    oItemSub.HRelationQty = 0;     //关联数量


                                                   //oItemSub.HRelationMoney = 0;   //关联金额


                                                   //HMaterID = "";//配件代码


@@ -482,7 +482,7 @@


            try


            {


                DLL.ClsSb_EquipMaintainBill oBill = new DLL.ClsSb_EquipMaintainBill();


                List<Models.ClsSb_EquipMaintainBillMain > lsmain = new List<Models.ClsSb_EquipMaintainBillMain>();


                List<Models.ClsSb_EquipMaintainBillMain> lsmain = new List<Models.ClsSb_EquipMaintainBillMain>();


                msg2 = msg2.Replace("\\", "");


                msg2 = msg2.Replace("\n", "");  //\n


                lsmain = oListModels.getObjectByJson_Sb_EquipMaintainBillMainPDA(msg2);