| | |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select * from Sc_AssemblyBillMain WITH(NOLOCK) where HMainSourceInterID=" + HProcExchInterID + " and HMainSourceEntryID=" + HProcExchEntryID, "Sc_AssemblyBillMain"); |
|---|
| | | DateTime HDate=DateTime.Now; |
|---|
| | | //当产品没有配件的时候 查询 不良记录 |
|---|
| | | //先判断上料防错是否存在，存在就用上料防错日期，不存在就去查询生产质量汇报单子表的制单日期 |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select * from Sc_QualityReportBillSub WITH(NOLOCK) where HProcExchInterID=" + HProcExchInterID + " and HProcExchEntryID=" + HProcExchEntryID+ " and HBarCode='" + HBadCodeSN + "'", "Sc_AssemblyBillMain"); |
|---|
