YG-OPP-WCS-Client/WCS_Client/Frm/MBtn_Task/FrmUpdatePriority.cs

using DevComponents.DotNetBar;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WCS_Client.UC;
using WCS_Client.Utility;

namespace WCS_Client.Frm
{
    public partial class FrmUpdatePriority : Office2007Form
    {
        DataRow dr = null;DataTable dt = null;
        public FrmUpdatePriority(DataTable datarow)
        {
            InitializeComponent();
            dt = datarow;
            //dr = datarow;
            //lbltask_no.Text = dr["ID"].ToString();
            //lblwmstask_no.Text = dr["WMSTASK"].ToString();
            //lblBarCode.Text = dr["BARCODE"].ToString();
            //lblStartAddress.Text = dr["ADDRFROM"].ToString();
            //lblwcsNextAddress.Text = dr["ADDRNEXT"].ToString();
            //lblEndAddress.Text = dr["ADDRTO"].ToString();
            //nudPriority.Value = Convert.ToInt32(dr["Priority"].ToString());
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(txtReason.Text))
            {
                MessageBox.Show("请输入原因");
                return;
            }
            var result = MessageUtil.ShowYesNoAndWarning(string.Format("确定要变更优先级吗？"));
            if (result == DialogResult.Yes)
            {
                //dt = dt.Clone();
                string res = "";
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    var dr = dt.Rows[i];
                    var task_no = Convert.ToInt32(dr["ID"].ToString());
                    int priority = Convert.ToInt32(dr["Priority"].ToString());
                     res = TryCachHelper.TryTranExecute((db) =>
                    {
                        var task = db.Queryable<WCS_TASK>().First(v => v.ID == task_no);
                        if (task == null)
                        {
                            throw new Exception(string.Format("未查询到WCS任务[{0}]信息", task_no));
                        }
                        else
                        {
                            if (db.Updateable<WCS_TASK>()
                                  .UpdateColumns(it => new WCS_TASK
                                  {
                                      Priority = priority,
                                      UPDATEUSER = CurrentHelper.User.Use_Name,
                                      UPDATETIME = DateTime.Now
                                  })
                                  .Where(v => v.ID == task_no).ExecuteCommand() < 0)
                            {
                                throw new Exception(string.Format("WCS任务[{0}]调整优先级失败", task_no));
                            }
                            //string msg = string.Format("任务[{0}]调整优先级为[{1}]成功。", task_no, priority);
                        }
                    });
                    if (string.IsNullOrWhiteSpace(res))
                    {
                        //res = string.Format("任务[{0}]调整优先级[{1}]成功。", task_no.ToString(), priority);
                    }
                }
                MessageBox.Show(res);
                //string massge = BaseWorkflow.UpdateTaskPriority(Convert.ToInt32(lbltask_no.Text.Trim()), (int)nudPriority.Value);
                //MessageUtil.ShowTips(res);
                this.Close();
            }
        }
    }
}