/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Maticsoft.Model.BoxInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_BoxInfo("); strSql.Append("BatchNo,BoxSN,Qty,Type,State)"); strSql.Append(" values ("); strSql.Append("@BatchNo,@BoxSN,@Qty,@Type,@State)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@BatchNo", SqlDbType.VarChar, 30), new SqlParameter("@BoxSN", SqlDbType.VarChar, 50), new SqlParameter("@Qty", SqlDbType.VarChar, 30), new SqlParameter("@Type", SqlDbType.VarChar, 30), new SqlParameter("@State", SqlDbType.VarChar, 30) }; parameters[0].Value = model.BatchNo; parameters[1].Value = model.BoxSN; parameters[2].Value = model.Qty; parameters[3].Value = model.Type; parameters[4].Value = model.State; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.BoxInfo DataRowToModel(DataRow row) { Maticsoft.Model.BoxInfo model = new Maticsoft.Model.BoxInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = decimal.Parse(row["ID"].ToString()); } if (row["BatchNo"] != null) { model.BatchNo = row["BatchNo"].ToString(); } if (row["BoxSN"] != null) { model.BoxSN = row["BoxSN"].ToString(); } if (row["Qty"] != null) { model.Qty = row["Qty"].ToString(); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["State"] != null) { model.State = row["State"].ToString(); } } return(model); }
private void ShowInfo(decimal ID) { Maticsoft.BLL.BoxInfo bll = new Maticsoft.BLL.BoxInfo(); Maticsoft.Model.BoxInfo model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.txtBatchNo.Text = model.BatchNo; this.txtBoxSN.Text = model.BoxSN; this.txtQty.Text = model.Qty; this.txtType.Text = model.Type; this.txtState.Text = model.State; }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtBatchNo.Text.Trim().Length == 0) { strErr += "BatchNo不能为空!\\n"; } if (this.txtBoxSN.Text.Trim().Length == 0) { strErr += "BoxSN不能为空!\\n"; } if (this.txtQty.Text.Trim().Length == 0) { strErr += "Qty不能为空!\\n"; } if (this.txtType.Text.Trim().Length == 0) { strErr += "Type不能为空!\\n"; } if (this.txtState.Text.Trim().Length == 0) { strErr += "State不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } decimal ID = decimal.Parse(this.lblID.Text); string BatchNo = this.txtBatchNo.Text; string BoxSN = this.txtBoxSN.Text; string Qty = this.txtQty.Text; string Type = this.txtType.Text; string State = this.txtState.Text; Maticsoft.Model.BoxInfo model = new Maticsoft.Model.BoxInfo(); model.ID = ID; model.BatchNo = BatchNo; model.BoxSN = BoxSN; model.Qty = Qty; model.Type = Type; model.State = State; Maticsoft.BLL.BoxInfo bll = new Maticsoft.BLL.BoxInfo(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.BoxInfo GetModel(string sqlWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT TOP (1) ID, BatchNo, BoxSN, Qty, Type, State FROM tb_BoxInfo WHERE "); strSql.Append(sqlWhere); strSql.Append("ORDER BY ID"); Maticsoft.Model.BoxInfo model = new Maticsoft.Model.BoxInfo(); DataSet ds = dbs.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { Maticsoft.Model.BoxInfo tem = new Model.BoxInfo(); return(tem); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.BoxInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_BoxInfo set "); strSql.Append("BatchNo=@BatchNo,"); strSql.Append("BoxSN=@BoxSN,"); strSql.Append("Qty=@Qty,"); strSql.Append("Type=@Type,"); strSql.Append("State=@State"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@BatchNo", SqlDbType.VarChar, 30), new SqlParameter("@BoxSN", SqlDbType.VarChar, 50), new SqlParameter("@Qty", SqlDbType.VarChar, 30), new SqlParameter("@Type", SqlDbType.VarChar, 30), new SqlParameter("@State", SqlDbType.VarChar, 30), new SqlParameter("@ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.BatchNo; parameters[1].Value = model.BoxSN; parameters[2].Value = model.Qty; parameters[3].Value = model.Type; parameters[4].Value = model.State; parameters[5].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
// //扫描箱号 // private void txb_BoxSN_KeyUp(object sender, KeyEventArgs e) { if (e.Key == System.Windows.Input.Key.Enter && txb_BoxSN.IsFocused) { //获取箱号 Maticsoft.BLL.BoxInfo _M_BoxInfo = new Maticsoft.BLL.BoxInfo(); _GTT_BoxInfo = _M_BoxInfo.GetModel("(BatchNo = '" + cmb_BatchNo.Text.Trim() + "') AND (State = 'NotEncasement') AND (BoxSN = '" + txb_BoxSN.Text.Trim() + "')"); if (_GTT_BoxInfo.BoxSN != null) { //验证通过 SolidColorBrush myBrush = new SolidColorBrush(_Mycolor); //定义纯色绘制 变量 lab_BoxResult.Text = "PASS"; lab_BoxResult.Foreground = myBrush; //箱子总量 txb_BoxCount.Text = _GTT_BoxInfo.Qty; txb_BoxSN.IsEnabled = false; //显示箱子已包装数量 Encasement _M_Encasement = new Encasement(); txb_SackCount.Text = _M_Encasement.GetBoxCount("(BoxID = '" + _GTT_BoxInfo.ID + "')").ToString(); //在 ListBox 控件中显示 view.Source = _M_Encasement.GetModelList("(BoxID = '" + _GTT_BoxInfo.ID + "')"); lab_EncasementRecordCount.Text = lsv_SerialNumberList.Items.Count.ToString(); //判断是否箱子装满 if (txb_SackCount.Text.Trim() == txb_BoxCount.Text.Trim()) { txb_SerialNumber.IsEnabled = false; } } else { lab_BoxResult.Text = "FAIL"; lab_BoxResult.Foreground = Brushes.Red; My_MessageBox.My_MessageBox_Message("此箱号不属于此批号,或此箱号已装箱!\r\n请更换箱号后重试!"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.BoxInfo GetModel(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,BatchNo,BoxSN,Qty,Type,State from tb_BoxInfo "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Decimal) }; parameters[0].Value = ID; Maticsoft.Model.BoxInfo model = new Maticsoft.Model.BoxInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
// //保存装箱信息 // private void btn_Save_PackSettinh_Click(object sender, System.Windows.RoutedEventArgs e) { try { //****保存装箱设置 EncasementSet _M_EncasementSet = new EncasementSet(); Maticsoft.Model.EncasementSet _EncasementSet = _M_EncasementSet.GetModel(cmb_Pak_BatchNo.Text.Trim()); if (_EncasementSet.BatchNo == null) { _EncasementSet.BatchNo = cmb_Pak_BatchNo.Text.Trim(); _EncasementSet.Device = txb_Pak_Device.Text.Trim(); _EncasementSet.DeviceQty = txb_Pak_DeviceCount.Text.Trim(); _EncasementSet.SackQty = txb_Pak_SackQty.Text.Trim(); _M_EncasementSet.Add(_EncasementSet); //添加 } else { _EncasementSet.BatchNo = cmb_Pak_BatchNo.Text.Trim(); _EncasementSet.Device = txb_Pak_Device.Text.Trim(); _EncasementSet.DeviceQty = txb_Pak_DeviceCount.Text.Trim(); _EncasementSet.SackQty = txb_Pak_SackQty.Text.Trim(); _M_EncasementSet.Update(_EncasementSet); } //保存箱号 ObservableCollection<Maticsoft.Model.BoxInfo> _BoxInfo = new ObservableCollection<Maticsoft.Model.BoxInfo>(); Maticsoft.Model.BoxInfo _TemBoxInfo = new Maticsoft.Model.BoxInfo(); BoxInfo _M_BoxInfo = new BoxInfo(); foreach (Customer Temcutomer in customers) { _TemBoxInfo = _M_BoxInfo.GetModel("BoxSN = '"+Temcutomer.BoxSN+"'"); if (_TemBoxInfo.BoxSN == null) //如果不存在则添加 否则 更新 { _TemBoxInfo.BatchNo = cmb_Pak_BatchNo.Text.Trim(); _TemBoxInfo.Type = "BoxSN"; _TemBoxInfo.State = "NotEncasement"; _TemBoxInfo.BoxSN = Temcutomer.BoxSN; _TemBoxInfo.Qty = Temcutomer.Qty; _M_BoxInfo.Add(_TemBoxInfo); } else { _TemBoxInfo.BatchNo = cmb_Pak_BatchNo.Text.Trim(); _TemBoxInfo.Type = "BoxSN"; // _TemBoxInfo.State = "NotEncasement"; _TemBoxInfo.BoxSN = Temcutomer.BoxSN; _TemBoxInfo.Qty = Temcutomer.Qty; _M_BoxInfo.Update(_TemBoxInfo); } } My_MessageBox.My_MessageBox_Message("保存完成!"); customers.Clear(); } catch (System.Exception ex) { My_MessageBox.My_MessageBox_Message(ex.Message); } }