| | |
|---|
| | | as DynamicObjectCollection; |
|---|
| | | foreach (var entryRow in entryRows) |
|---|
| | | { |
|---|
| | | |
|---|
| | | string srcFormId = "PRD_PPBOM"; |
|---|
| | | string srcSrcBillNo = entryRow["FPPBOMBILLNO"]?.ToString(); |
|---|
| | | string FPPBOMFID = entryRow["FPPOMFID"]?.ToString(); |
|---|
| | |
|---|
| | | if (FentryIdList.Count > 0) |
|---|
| | | { |
|---|
| | | string FentryId = string.Join(",", FentryIdList.ToArray()); |
|---|
| | | sql = string.Format(@"/*dialect*/ |
|---|
| | | update a set FBASEQTY = FQTY |
|---|
| | | from T_STK_STKTRANSFERINENTRY_LK a |
|---|
| | | join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID |
|---|
| | | where |
|---|
| | | --a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and |
|---|
| | | a.FENTRYID in ({0})", FentryId); |
|---|
| | | sqlList.Add(sql); |
|---|
| | | // sql = string.Format(@"/*dialect*/ |
|---|
| | | //update a set FBASEQTY = FQTY |
|---|
| | | //from T_STK_STKTRANSFERINENTRY_LK a |
|---|
| | | //join T_STK_STKTRANSFERINENTRY b on a.FENTRYID = b.FENTRYID |
|---|
| | | //where |
|---|
| | | //--a.FSTABLENAME = 'T_PRD_PPBOMENTRY' and |
|---|
| | | //a.FENTRYID in ({0})", FentryId); |
|---|
| | | // sqlList.Add(sql); |
|---|
| | | sql = string.Format(@"/*dialect*/update T_STK_STKTRANSFERINENTRY_R |
|---|
| | | set FSrcBillTypeId = 'PRD_PPBOM',FSRCBILLNO=b.FPPBOMBILLNO |
|---|
| | | ,FTRANSRESERVELINK=1 |
|---|
