|  |  | 
 |  |  |         { | 
 |  |  |             if (sWhere == null || sWhere.Equals("")) | 
 |  |  |             { | 
 |  |  |                 return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairOutBillList " + sWhere, "h_v_Sc_MouldRepairOutBillList"); | 
 |  |  |                 return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldRepairOutBillList order by 日期 desc" + sWhere, "h_v_Sc_MouldRepairOutBillList"); | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 string sql1 = "select * from h_v_Sc_MouldRepairOutBillList where 1 = 1 "; | 
 |  |  |                 string sql = sql1 + sWhere; | 
 |  |  |                 string sql = sql1 + sWhere+ "order by 日期 desc"; | 
 |  |  |                 return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairOutBillList"); | 
 |  |  |             } | 
 |  |  |  | 
 |  |  | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |                 if (oBill.omodel.HChecker != "") | 
 |  |  |                 if (oBill.omodel.HChecker != ""&& oBill.omodel.HChecker != null) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |                 bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                 bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                 if (IsDete) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "1"; | 
 |  |  | 
 |  |  |                     } | 
 |  |  |                     //oItem.HMaker = ""; | 
 |  |  |                     UserName = oItem.HMaker;  //制单人 | 
 |  |  |                     oItem.HBillType = "3801"; | 
 |  |  |                     oItem.HBillSubType = "3801"; | 
 |  |  |                     oItem.HBillType = "3825"; | 
 |  |  |                     oItem.HBillSubType = "3825"; | 
 |  |  |                     //oItem.HBillNo = "";    //单据号 | 
 |  |  |                     //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));//  --日期 | 
 |  |  |                     //oItem.HInnerBillNo = "";  //  --内部单据号 |