| | |
|---|
| | | string sql = $"/*dialect*/update t1 set t1.FHLockedSub=1 from Sc_WorkBillSortBillSub t1 join Sc_WorkBillSortBillMain t2 on t1.FID = t2.FID where FHMASTERDATE between DATEADD(day,-1,getdate()) and DATEADD(day,{day - 1},getdate())"; |
|---|
| | | sqlList.Add(sql); |
|---|
| | | int result = DBServiceHelper.ExecuteBatch(Context, sqlList); |
|---|
| | | if (result > 0) |
|---|
| | | { |
|---|
| | | //if (result > 0) |
|---|
| | | //{ |
|---|
| | | //锁定后生成日计划用料清单 及 提料计划 |
|---|
| | | DayPlanPPBomBillBatch(); |
|---|
| | | Extraction(); |
|---|
| | | SearchList(); |
|---|
| | | this.View.ShowMessage("操作成功"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | this.View.ShowMessage("操作失败，联系管理员！"); |
|---|
| | | //} |
|---|
| | | //else |
|---|
| | | // this.View.ShowMessage("操作失败，联系管理员！"); |
|---|
| | | } |
|---|
| | | /// <summary> |
|---|
| | | /// 解锁 |
|---|
