using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DevExpress.XtraEditors; using ICSSoft.Base.Config.AppConfig; using System.Data.Linq; using System.Linq; using ICSSoft.Base.Language.Tool; using System.Reflection; using ICSSoft.Base.Config.DBHelper; using ICSSoft.Base.ReferForm; using ICSSoft.Base.Report; using ICSSoft.Base.ReferForm.AppReferForm; using ICSSoft.Frame.Data.Entity; using ICSSoft.Frame.Data.BLL; namespace ICSSoft.Frame.APP { public partial class FormICSItemBackAdd : DevExpress.XtraEditors.XtraForm { String guid = ""; ICSItemBack entity = new ICSItemBack(); #region 构造函数 public FormICSItemBackAdd() { InitializeComponent(); } public FormICSItemBackAdd(String id) { InitializeComponent(); guid = id; } #endregion #region 关闭 退出 private void btnClose_Click(object sender, EventArgs e) { this.Close(); } #endregion #region 移动窗体 private const int WM_NCHITTEST = 0x84; private const int HTCLIENT = 0x1; private const int HTCAPTION = 0x2; //首先必须了解Windows的消息传递机制，当有鼠标活动消息时， //系统发送WM_NCHITTEST 消息给窗体作为判断消息发生地的根据。 nchittest //假如你点击的是标题栏，窗体收到的消息值就是 HTCAPTION ， //同样地，若接受到的消息是 HTCLIENT，说明用户点击的是客户区，也就是鼠标消息发生在客户区。 //重写窗体，使窗体可以不通过自带标题栏实现移动 protected override void WndProc(ref Message m) { //当重载窗体的 WndProc 方法时，可以截获 WM_NCHITTEST 消息并改些该消息， //当判断鼠标事件发生在客户区时，改写改消息，发送 HTCAPTION 给窗体， //这样，窗体收到的消息就时 HTCAPTION ，在客户区通过鼠标来拖动窗体就如同通过标题栏来拖动一样。 //注意：当你重载 WndProc 并改写鼠标事件后，整个窗体的鼠标事件也就随之改变了。 switch (m.Msg) { case WM_NCHITTEST: base.WndProc(ref m); if ((int)m.Result == HTCLIENT) m.Result = (IntPtr)HTCAPTION; return; } //拦截双击标题栏、移动窗体的系统消息 if (m.Msg != 0xA3) { base.WndProc(ref m); } } #endregion #region 新增 修改 private void save_Click(object sender, EventArgs e) { if (txtCode.Text.Trim() == "") { ICSBaseSimpleCode.AppshowMessageBox("工单号不能为空!"); return; } if (cmbSEQ.Text.Trim() == "") { ICSBaseSimpleCode.AppshowMessageBox("生产订单行号不能为空!"); return; } if (cmbInvCode.Text.Trim() == "") { ICSBaseSimpleCode.AppshowMessageBox("物料代码不能为空!"); return; } if (txtQTY.Text.Trim() == "") { ICSBaseSimpleCode.AppshowMessageBox("数量不能为空!"); return; } entity.MOCODE = txtCode.Text.Trim(); entity.MOSEQ = cmbSEQ.Text.Trim(); entity.INVCode = cmbInvCode.Text.Trim(); entity.QTY =Convert.ToDecimal(txtQTY.Text.Trim()); entity.STATUS = "初始"; entity.MUSER = AppConfig.UserId; entity.MUSERName = AppConfig.UserName; entity.MTIME = Convert.ToDateTime(AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss").ToString()); entity.WorkPoint = AppConfig.WorkPointCode; entity.EATTRIBUTE1 = null; try { ICSItemBackBLL.AddandEdit(entity, AppConfig.AppConnectString); this.Close(); ICSBaseSimpleCode.AppshowMessageBox("操作成功"); } catch (Exception ex) { ICSBaseSimpleCode.AppshowMessageBox(ex.Message); } } #endregion #region 取消 private void can_Click(object sender, EventArgs e) { this.Close(); } #endregion #region 页面加载 private void FormICSItemBackAdd_Load(object sender, EventArgs e) { init(); if (guid != "") { lblTitle.Text = "退料信息修改"; txtCode.Properties.ReadOnly = true; cmbSEQ.Properties.ReadOnly = true; cmbInvCode.Properties.ReadOnly = true; entity = ICSItemBackBLL.select(guid, AppConfig.AppConnectString); txtCode.Text = entity.MOCODE; cmbSEQ.Text = entity.MOSEQ; cmbInvCode.Text = entity.INVCode; txtQTY.Text =entity.QTY.ToString(); txtMUSERName.Text = entity.MUSERName; txtMTIME.Text = Convert.ToDateTime(entity.MTIME).ToString(); } else { lblTitle.Text = "退料信息新增"; txtMUSERName.Text = AppConfig.UserName; txtMTIME.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } } #endregion #region 初始化查询条件 private void init() { #region 单据号 string sql = "SELECT DISTINCT MOCODE AS [工单号] FROM ICSMO WHERE WorkPoint='{0}' ORDER BY MOCODE"; sql = string.Format(sql, AppConfig.WorkPointCode); DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0]; txtCode.Properties.ValueMember = "生产订单号"; txtCode.Properties.DisplayMember = "生产订单号"; txtCode.Properties.DataSource = dt; txtCode.Properties.NullText = "";//空时的值 txtCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体 txtCode.Properties.ValidateOnEnterKey = true;//回车确认 txtCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard txtCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 //自适应宽度 txtCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; #endregion } #endregion private void txtCode_EditValueChanged(object sender, EventArgs e) { try { cmbSEQ.Properties.Items.Clear(); cmbSEQ.Text = ""; string Code = txtCode.EditValue.ToString(); string sql = "SELECT DISTINCT MOSEQ FROM ICSMO WHERE WorkPoint='{0}' AND MOCODE='{1}' ORDER BY MOSEQ"; sql = string.Format(sql, AppConfig.WorkPointCode, Code); DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0]; //cmbSEQ.Properties.Items.Add(""); cmbSEQ.Properties.Items.AddRange(dt.AsEnumerable().Select(a => a["MOSEQ"]).ToList()); if (cmbSEQ.Properties.Items.Count > 0) cmbSEQ.SelectedIndex = 0; } catch (Exception ex) { ICSBaseSimpleCode.AppshowMessageBox(ex.ToString()); } } private void cmbSEQ_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbSEQ.Properties.Items.Count <= 0) { return; } cmbInvCode.Properties.Items.Clear(); cmbInvCode.Text = ""; string Code = txtCode.EditValue.ToString(); string sql = "SELECT DISTINCT MOBITEMCODE FROM ICSMOBOM WHERE WorkPoint='{0}' AND MOCODE='{1}' AND SEQ='{2}' ORDER BY MOBITEMCODE"; sql = string.Format(sql, AppConfig.WorkPointCode, Code,cmbSEQ.Text.Trim()); DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0]; cmbInvCode.Properties.Items.AddRange(dt.AsEnumerable().Select(a => a["MOBITEMCODE"]).ToList()); if (cmbInvCode.Properties.Items.Count > 0) cmbInvCode.SelectedIndex = 0; } catch (Exception ex) { ICSBaseSimpleCode.AppshowMessageBox(ex.ToString()); } } } }