YG-OPP-WCS-Client/WCS_Client/Frm/MBtn_Sys/FrmUpdatePalletizing.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.Data.Models;
using WCS_Client.UC;

namespace WCS_Client.Frm
{
    public partial class FrmUpdatePalletizing : Office2007Form
    {
        DataRow dr = null;
        public FrmUpdatePalletizing(DataRow datarow)
        {
            InitializeComponent();
            dr = datarow;

            nudPalletizingNo.Value = Convert.ToInt32(datarow["PalletizingNo"].ToString());
            nudSonTrayNo.Value = Convert.ToInt32(datarow["PalletizingSonTrayNo"].ToString());
            nudBoxNo.Value = Convert.ToInt32(datarow["PalletizingBoxNo"].ToString());
            txtSonTraycode.Text = datarow["PalletizingSonTrayCode"].ToString();
            txtBoxSize.Text = datarow["PalletizingBoxSize"].ToString();
            txtSonTraySize.Text = datarow["PalletizingSonTraySize"].ToString();
        }

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

        private void btnUpdateP_Click(object sender, EventArgs e)
        {
            if (nudPalletizingNo.Value == 0)
            {
                MessageUtil.ShowError("码垛编号不能为空");
                return;
            }
            //else if(nudSonTrayNo.Value == 0)
            //{
            //    MessageUtil.ShowError("子托盘编号不能为空");
            //    return;
            //}
            else if (nudBoxNo.Value == 0)
            {
                MessageUtil.ShowError("箱子编号不能为空");
                return;
            }
            else if (string.IsNullOrWhiteSpace(txtBoxSize.Text))
            {
                MessageUtil.ShowError("箱子尺寸不能为空");
                return;
            }
            //else if (string.IsNullOrWhiteSpace(txtSonTraySize.Text))
            //{
            //    MessageUtil.ShowError("子托盘尺寸不能为空");
            //    return;
            //}
            int id = Convert.ToInt32(dr["Id"].ToString());
            var palletizingCode = new WCS_PalletizingCode();
            palletizingCode.PalletizingNo = Convert.ToInt32(nudPalletizingNo.Value);
            palletizingCode.PalletizingSonTrayNo = Convert.ToInt32(nudSonTrayNo.Value);
            palletizingCode.PalletizingSonTrayCode = txtSonTraycode.Text.Trim();
            palletizingCode.PalletizingSonTraySize = txtSonTraySize.Text.Trim();
            palletizingCode.PalletizingBoxNo = Convert.ToInt32(nudBoxNo.Value);
            palletizingCode.PalletizingBoxSize = txtBoxSize.Text.Trim();
            string result = TryCachHelper.TryExecute((db) =>
            {
                if (db.Updateable<WCS_PalletizingCode>()
                      .UpdateColumns(it => new WCS_PalletizingCode
                      {
                          PalletizingNo = palletizingCode.PalletizingNo,
                          PalletizingSonTrayNo = palletizingCode.PalletizingSonTrayNo,
                          PalletizingSonTrayCode = palletizingCode.PalletizingSonTrayCode,
                          PalletizingSonTraySize = palletizingCode.PalletizingSonTraySize,
                          PalletizingBoxNo = palletizingCode.PalletizingBoxNo,
                          PalletizingBoxSize = palletizingCode.PalletizingBoxSize
                      })
                      .Where(v => v.Id == id).ExecuteCommand() < 0)
                {
                    throw new Exception(string.Format("码垛Id[{0}]修改参数失败", id));
                }
            });
            if (string.IsNullOrWhiteSpace(result))
            {
                result = string.Format("修改机械码垛信息成功");
            }
            MessageUtil.ShowTips(result);
        }
    }
}