using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Shapes; using System.Data; using static System.Collections.Specialized.BitVector32; using System.Net.NetworkInformation; using SiaSun.LMS.Model; namespace SiaSun.LMS.WPFClient.MANAGE { public partial class MANAGE_IN_LOCAL : AvalonDock.DocumentContent { public MANAGE_IN_LOCAL(string MANAGE_TYPE_CODE) { InitializeComponent(); //this.cbDeviceCode.DisplayMemberPath = "NAME"; //this.cbDeviceCode.SelectedValuePath = "VALUE"; //DataTable dtDeviceCode = new DataTable(); //dtDeviceCode.Columns.Add("NAME", Type.GetType("System.String")); //dtDeviceCode.Columns.Add("VALUE", Type.GetType("System.Int32")); //dtDeviceCode.Rows.Add("11002 入库站台", 31682); //dtDeviceCode.Rows.Add("11028 入库站台", 31683); //this.cbDeviceCode.ItemsSource = dtDeviceCode.DefaultView; this.cbDongjie.DisplayMemberPath = "ITEM_LIST_NAME"; this.cbDongjie.SelectedValuePath = "ITEM_LIST_CODE"; try { string strSQL = string.Format(@"SELECT ITEM_LIST_CODE,ITEM_LIST_NAME FROM V_SYS_ITEM WHERE ITEM_CODE='DONG_JIE' ORDER BY ITEM_LIST_ORDER"); DataTable dt = MainApp._I_BaseService.GetList(strSQL); DataRow dr = dt.NewRow(); this.cbDongjie.ItemsSource = dt.DefaultView; if (this.cbDongjie.Items.Count > 0) { this.cbDongjie.SelectedIndex = 0; } if (MainApp._USER.USER_NAME.Contains("管理员")) { this.cbDongjie.IsEnabled = true; } } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } private void BtnSave_Click(object sender, RoutedEventArgs e) { bool bResult = true; string sResult = string.Empty; if (string.IsNullOrEmpty(this.tbStock_barcode.Text)) { MessageBox.Show("托盘条码为空"); return; } if (string.IsNullOrEmpty(this.tbGoods_code.Text)) { MessageBox.Show("物料条码为空"); return; } //if (string.IsNullOrWhiteSpace(this.tbDeviceCode.Text)) //{ // MessageBox.Show("入库站台为空"); // return; //} //if (this.tbDeviceCode.Text != "11002" && // this.tbDeviceCode.Text != "11028") //{ // MessageBox.Show("入库站台只能是 11002 或 11028"); // return; //} if (!Common.RegexValid.GetCodeCheck(this.tbStock_barcode.Text, "StockCodeCheck")) { MessageBox.Show("托盘条码规则不正确"); return; } int iZupanCellID = 0; //DataTable dtZupan = MainApp._I_BaseService.GetList($"select CELL_ID from WH_CELL where CELL_CODE='{this.tbDeviceCode.Text}'"); //if (dtZupan.Rows.Count == 0) //{ // MessageBox.Show($"未找到站台编码 {this.tbDeviceCode.Text}"); // return; //} //else //{ // iZupanCellID = Convert.ToInt32(dtZupan.Rows[0]["CELL_ID"]); //} DataTable dtZupan = MainApp._I_BaseService.GetList("select CELL_ID from WH_CELL where CELL_CODE='99999'"); if (dtZupan.Rows.Count == 0) { MessageBox.Show("未找到组盘区"); return; } else { iZupanCellID = Convert.ToInt32(dtZupan.Rows[0]["CELL_ID"]); } string sGoodsBarcode = this.tbGoods_code.Text.Trim(); string[] strArr = sGoodsBarcode.Split('-'); if (strArr.Length != 7) { MessageBox.Show("物料条码规则不正确"); return; } DataTable gOODS_MAIN = MainApp._I_BaseService.GetList(string.Format(@"select goods_id from goods_main where goods_code = '{0}'", strArr[1])); if (gOODS_MAIN == null || gOODS_MAIN.Rows.Count < 1) { MessageBox.Show(string.Format(@"{0} 物料信息不存在", strArr[1])); return; } Model.MANAGE_MAIN mANAGE_MAIN = new Model.MANAGE_MAIN(); Model.MANAGE_LIST mANAGE_LIST = new Model.MANAGE_LIST(); List lsMANAGE_LIST = new List(); mANAGE_MAIN.STOCK_BARCODE = this.tbStock_barcode.Text; mANAGE_MAIN.MANAGE_TYPE_CODE = "ManageIn"; mANAGE_MAIN.MANAGE_OPERATOR = MainApp._USER.USER_NAME; mANAGE_MAIN.MANAGE_BEGIN_TIME = Common.StringUtil.GetDateTime(); mANAGE_MAIN.MANAGE_STATUS = "Waiting"; mANAGE_MAIN.START_CELL_ID = iZupanCellID; mANAGE_MAIN.END_CELL_ID = 0; mANAGE_LIST.GOODS_ID = Convert.ToInt32(gOODS_MAIN.Rows[0]["GOODS_ID"].ToString()); mANAGE_LIST.MANAGE_ID = 0; mANAGE_LIST.MANAGE_LIST_QUANTITY = Convert.ToDecimal(strArr[5]); mANAGE_LIST.PLAN_LIST_ID = 0; mANAGE_LIST.GOODS_PROPERTY1 = sGoodsBarcode; mANAGE_LIST.GOODS_PROPERTY2 = strArr[0] + "-" + strArr[1] + "-" + strArr[2] + "-" + strArr[4]; mANAGE_LIST.GOODS_PROPERTY3 = strArr[2]; //mANAGE_LIST.GOODS_PROPERTY5 = MainApp._I_ManageService.GetGoodsProperty05(this.tbDeviceCode.Text); mANAGE_LIST.GOODS_PROPERTY5 = "0"; //mANAGE_LIST.GOODS_PROPERTY8 = "0"; mANAGE_LIST.GOODS_PROPERTY9 = this.cbDongjie.SelectedValue.ToString(); mANAGE_LIST.STORAGE_LIST_ID = 0; lsMANAGE_LIST.Add(mANAGE_LIST); bResult = MainApp._I_BaseService.Invoke("ManageIn", "ManageCreate", new object[] { mANAGE_MAIN, lsMANAGE_LIST, true,//事务 true,//检查库存 true,//是否完成 false//是否下达任务 },out sResult); if (bResult) { MessageBox.Show("组盘入库成功"); BtnClear_Click(null, null); return; } else { MessageBox.Show(sResult); return; } } private void BtnClear_Click(object sender, RoutedEventArgs e) { //this.tbDeviceCode.Text = string.Empty; this.tbStock_barcode.Text = string.Empty; this.tbGoods_code.Text = string.Empty; //this.cbDeviceCode.SelectedIndex = -1; this.tbStock_barcode.Focus(); } //private void tbDeviceCode_KeyDown(object sender, KeyEventArgs e) //{ // if (e.Key == Key.Enter) // { // if (string.IsNullOrWhiteSpace(this.tbDeviceCode.Text)) // { // return; // } // if (string.IsNullOrWhiteSpace(this.tbStock_barcode.Text)) // { // this.tbStock_barcode.Focus(); // } // } //} private void tbStock_barcode_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { if (string.IsNullOrWhiteSpace(this.tbStock_barcode.Text)) { return; } this.tbStock_barcode.Text = this.tbStock_barcode.Text.ToUpper(); if (string.IsNullOrWhiteSpace(this.tbGoods_code.Text)) { this.tbGoods_code.Focus(); } } } private void tbGoods_code_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { if (string.IsNullOrWhiteSpace(this.tbGoods_code.Text)) { return; } this.tbGoods_code.Text = this.tbGoods_code.Text.ToUpper(); BtnSave_Click(null, null); } } } }