| | |
|---|
| | | |
|---|
| | | public static DataSet Sc_GetMESProductReportBillList(string sWhere) |
|---|
| | | { |
|---|
| | | string sql = string.Format(@"select a.HInterID, a.HBillNo,a.HDate,a.HBillType,a.HBillStatus,a.HMaterID,m.HNumber HMaterCode,m.HName HMaterName,m.HModel HMaterSpec |
|---|
| | | ,a.HSourceID,s.HNumber HSourceCode,s.HName HSourceName,a.HGroupID,g.HNumber HGroupCode,g.HName HGroupName |
|---|
| | | ,a.HWorkManID,e.HName HWorkManName,a.HMaker,a.HMakeDate, a.HReportType |
|---|
| | | ,a.HQty,a.HICMOBillNo,a.HICMOInterID,a.HICMOEntryID |
|---|
| | | ,a.HSourceInterID,a.HSourceEntryID,a.HSourceBillNo, a.HSourceBillType |
|---|
| | | from Sc_ICMOBillWorkQtyStatus_Tmp a |
|---|
| | | left join Gy_Material m on a.HMaterID=m.hitemid |
|---|
| | | left join Gy_Source s on a.HSourceID=s.HItemID |
|---|
| | | left join Gy_Group g on a.HGroupID=g.HItemID |
|---|
| | | left join Gy_Employee e on a.HWorkManID=e.HItemID " + sWhere + " and HRelationInterID='0'"); |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "Sc_ICMOBillWorkQtyStatus_Tmp"); |
|---|
| | | string sql = ""; |
|---|
| | | if (sWhere != null && sWhere != "") |
|---|
| | | { |
|---|
| | | sql = "select * from h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform " + sWhere; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | sql = "select * from h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform " ; |
|---|
| | | } |
|---|
| | | |
|---|
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform"); |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "保存失败！"; |
|---|
| | | objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo; |
|---|
| | | objJsonResult.data = 1; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
