| | |
| | | string sql1 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " + |
| | | "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + |
| | | "where a.HBillTypeID = '" + this.BillType + "' " + |
| | | "and a.HInterID = " + HCheckFlowID_select + " " + |
| | | //"and a.HInterID = " + HCheckFlowID_select + " " + |
| | | "and a.HStandard = 1 " + |
| | | "order by b.HFlowNo asc"; |
| | | DataSet ds1 = oCn.RunProcReturn(sql1, "Xt_CheckFlowMain"); |
| | | if (ds1 == null || ds1.Tables[0].Rows.Count == 0) |
| | |
| | | if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); |
| | | if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1205" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239") |
| | | if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1205" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239"|| HBillType == "1256") |
| | | { |
| | | //åå®¡æ ¸æ´æ° åæ¶åºå表 å¢å åºå 1201 1202 1203 1247 1244 1251 1210 |
| | | //åå®¡æ ¸æ´æ° åæ¶åºå表 åå°åºå 1205 1250 1206 1245 1239 |
| | |
| | | if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | string HBillType = ds.Tables[0].Rows[0]["HBillType"].ToString(); |
| | | if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239") |
| | | if (HBillType == "1201" || HBillType == "1202" || HBillType == "1203" || HBillType == "1247" || HBillType == "1244" || HBillType == "1251" || HBillType == "1210" || HBillType == "1250" || HBillType == "1206" || HBillType == "1245" || HBillType == "1239" || HBillType == "1256") |
| | | { |
| | | //å®¡æ ¸æ´æ° åæ¶åºå表 å¢å åºå 1201 1202 1203 1247 1244 1251 1210 |
| | | //å®¡æ ¸æ´æ° åæ¶åºå表 åå°åºå 1204 1250 1206 1245 1239 |