|  |  | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 CallGoodsBill ca = JsonConvert.DeserializeObject<CallGoodsBill>(sWhere); | 
 |  |  |                 oCN.RunProc($"exec h_p_JIT_BackGoodsBillList_Query '{ca.HBillNo}','{ca.MaterialNumber}','{ca.MaterialName}','{ca.MaterialModel}'," + | 
 |  |  |                     $"'{ca.ProcMul}','{ca.HDeptName}',{ca.HOrgID},'{ca.Hmaker}','{ca.HPZStatus}','{ca.HCKStatus}','{ca.HBeginDate}','{ca.HEndDate.AddDays(1).AddSeconds(-1)}'"); | 
 |  |  |  | 
 |  |  |                 if (ca.HPZStatus == "全部" && ca.HCKStatus == "全部") | 
 |  |  |                 { | 
 |  |  |                     ds = oCN.RunProcReturn("select * from ##h_p_JIT_BackGoodsBillList_Query1 where 1=1 " + ca.Arbitrarily + "", "##h_p_JIT_BackGoodsBillList_Query1"); | 
 |  |  |                 } | 
 |  |  |                 else if (ca.HPZStatus != "全部" && ca.HCKStatus == "全部") | 
 |  |  |                 { | 
 |  |  |                     ds = oCN.RunProcReturn("select * from ##h_p_JIT_BackGoodsBillList_Query2 where 1=1 " + ca.Arbitrarily + "", "##h_p_JIT_BackGoodsBillList_Query2"); | 
 |  |  |                 } | 
 |  |  |                 else if (ca.HPZStatus == "全部" && ca.HCKStatus != "全部") | 
 |  |  |                 { | 
 |  |  |                     ds = oCN.RunProcReturn("select * from ##h_p_JIT_BackGoodsBillList_Query3 where 1=1 " + ca.Arbitrarily + "", "##h_p_JIT_BackGoodsBillList_Query3"); | 
 |  |  |                 } | 
 |  |  |                 else if (ca.HPZStatus != "全部" && ca.HCKStatus != "全部") | 
 |  |  |                 { | 
 |  |  |                     ds = oCN.RunProcReturn("select * from ##h_p_JIT_BackGoodsBillList_Query4 where 1=1 " + ca.Arbitrarily + "", "##h_p_JIT_BackGoodsBillList_Query4"); | 
 |  |  |                 } | 
 |  |  |                 ds = oCN.RunProcReturn($"exec h_p_JIT_BackGoodsBillList_Query '{ca.HBillNo}','{ca.MaterialNumber}','{ca.MaterialName}','{ca.MaterialModel}'," + | 
 |  |  |                     $"'{ca.ProcMul}','{ca.HDeptName}',{ca.HOrgID},'{ca.Hmaker}','{ca.HPZStatus}','{ca.HCKStatus}','{ca.HBeginDate}','{ca.HEndDate.AddDays(1).AddSeconds(-1)}'", "h_p_JIT_BackGoodsBillList_Query"); | 
 |  |  |  | 
 |  |  |                 objJsonResult.code = "1"; | 
 |  |  |                 objJsonResult.count = 1; |