| | |
| | | { |
| | | ds = oCN.RunProcReturn(string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec, |
| | | 批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust, |
| | | 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark |
| | | 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldRepairInBillList"), "h_v_Sc_MouldRepairInBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | |
| | | //string sql1 = "select HRepairCheckID,HRepairCheckContent,HManagerID,HRemark from Sc_MouldRepairCheckBillSub where 1 = 1 "; |
| | | string sql1 = string.Format(@"SELECT HMaterID,模具代码 HMaterCode,模具名称 HMaterName,规格型号 HMaterSpec, |
| | | 批次 HBatchNo,设计寿命 HDesignLife, 剩余寿命 HLeaveLife, 使用寿命 HUseLife,应收数量 HQtyMust, |
| | | 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark |
| | | 实收数量 HQty, HWHID, 仓库代码 HWHCode,仓库 HWHName,子备注 HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldRepairInBillList where 1=1 "); |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldRepairInBillList"); |