| | |
|---|
| | | this.View.ShowErrMessage(_result); |
|---|
| | | return; |
|---|
| | | } |
|---|
| | | //校验生产用料清单是否审核 |
|---|
| | | foreach (DynamicObject current in entityDataObjoct) |
|---|
| | | { |
|---|
| | | //根据生产订单号和物料查询是否存在明细 +生产订单明细行号 |
|---|
| | | sql = string.Format(@"/*dialect*/SELECT FBILLNO FROM T_PRD_PPBOM T1 |
|---|
| | | WHERE T1.FMOBILLNO = '{0}' AND T1.FMATERIALID = '{1}' AND T1.FMOENTRYSEQ = '{2}' and FDOCUMENTSTATUS <>'C' |
|---|
| | | ", Convert.ToString(current["FSCOrderNo"]), Convert.ToString(current["FMatrailId_Id"]), Convert.ToString(current["FSRCBILLENTRYSEQ"])); |
|---|
| | | DataTable dt = new DataTable(); |
|---|
| | | dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0]; |
|---|
| | | if (dt.Rows.Count > 0) |
|---|
| | | _result += "序号：" + Convert.ToString(current["SEQ"]) + ",生产订单号：" + Convert.ToString(current["FSCOrderNo"]) + ",生产订单明细行号：" + Convert.ToString(current["FSRCBILLENTRYSEQ"]) + "物料" + (current["FMatrailId"] as DynamicObject)["Number"] + "对应的生产用料清单：" + dt.Rows[0][0] + "未审核"; |
|---|
| | | } |
|---|
| | | if (_result != "") |
|---|
| | | { |
|---|
| | | this.View.ShowErrMessage(_result); |
|---|
| | | return; |
|---|
| | | } |
|---|
| | | foreach (DynamicObject current in entityDataObjoct) |
|---|
| | | { |
|---|
| | | if (Convert.ToInt32(current["FNoScheduled"]) < 0) |
|---|
| | |
|---|
| | | } |
|---|
| | | return string.Empty; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void WriteImportLog() |
|---|
| | | { |
|---|
| | | try |
|---|
