| | |
|---|
| | | |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_OA_ErrMsgBackSelfQuery '" + HStatus + "','" + HBeginDate + "','" + HEndDate + "','" + HSourceID + "','" + user + "'", "h_p_QC_ErrManagerLedgerReport_Source"); |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_OA_ErrMsgBackSelfQuery '" + HStatus + "','" + HBeginDate + "','" + HEndDate + "','" + HSourceID + "','" + user + "'" , "h_p_OA_ErrMsgBackSelfQuery"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count != 0 || ds != null) |
|---|
| | | { |
|---|
| | |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | |
|---|
| | | string sql = "select a.HSourceBillNo 流转卡号,a.HSourceBillType 流转卡类型,a.HSourceInterID 流转卡主内码,a.HSourceEntryID 流转卡子内码,b.HNumber 物料代码,b.HName 物料名称,b.HModel 规格型号,a.HDatePlanQty 计划数量,a.HSourceID,c.HName 生产资源 from Sc_ICMOBillStatus_Tmp a " + |
|---|
| | | "left join Gy_Material b on a.HMaterID=b.HItemID left join Gy_Source c on a.HSourceID=c.HItemID where HSourceBillNo='" + HSourceBill + "'"; |
|---|
| | | "left join Gy_Material b on a.HMaterID=b.HItemID left join Gy_Source c on a.HSourceID=c.HItemID where HSourceBillNo='" + HSourceBill + "' and a.HICMOStatus=1"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "Sc_ICMOBillStatus_Tmp"); |
|---|
| | | |
|---|
| | | //添加列名 |
|---|
