// //供应商编号 // private void txb_MaterialPath_PreviewKeyUp(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { Maticsoft.BLL.Material_Receive _M_Material_Receive = new Maticsoft.BLL.Material_Receive(); string dt = DateTime.Now.ToString(); if (txb_Count.Text != "" && _WTT_User_Receive != null) { Maticsoft.Model.Material_Receive _Material_receive = new Maticsoft.Model.Material_Receive() { Client = txb_Client.Text.Trim(), ClientNum = txb_MaterialPath.Text.Trim(), Count = txb_Count.Text.Trim(), Orm_ID = _WTT_Orm_ID, UserID = txb_JobNumber_Receive.Text.Trim(), WorkStationID = _WTT_WK.Wo_ID.ToString(), DataTime = DateTime.Now }; _M_Material_Receive.Add(_Material_receive); // txb_MaterialPath.Text = ""; DataSet temds = _M_MaterReceive.GetList("Orm_ID = '" + _WTT_Orm_ID + "'"); dgv_Receive_Record.ItemsSource = temds.Tables[0].DefaultView; _yetCount = _M_MaterReceive.Get_Count(_WTT_Orm_ID); //已领用量 txb_YetCount.Text = _yetCount.ToString("0.00"); } else { My_MessageBox.My_MessageBox_Message("数量未设置,或领用人未验证,完成后重试! "); } } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtReceiveID.Text.Trim().Length == 0) { strErr += "ReceiveID不能为空!\\n"; } if (this.txtMaterialNum.Text.Trim().Length == 0) { strErr += "MaterialNum不能为空!\\n"; } if (this.txtClientNum.Text.Trim().Length == 0) { strErr += "ClientNum不能为空!\\n"; } if (this.txtCount.Text.Trim().Length == 0) { strErr += "Count不能为空!\\n"; } if (this.txtUserID.Text.Trim().Length == 0) { strErr += "UserID不能为空!\\n"; } if (this.txtWorkStationID.Text.Trim().Length == 0) { strErr += "WorkStationID不能为空!\\n"; } if (!PageValidate.IsDateTime(txtDataTime.Text)) { strErr += "DataTime格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string ReceiveID = this.txtReceiveID.Text; string MaterialNum = this.txtMaterialNum.Text; string ClientNum = this.txtClientNum.Text; string Count = this.txtCount.Text; string UserID = this.txtUserID.Text; string WorkStationID = this.txtWorkStationID.Text; DateTime DataTime = DateTime.Parse(this.txtDataTime.Text); Maticsoft.Model.Material_Receive model = new Maticsoft.Model.Material_Receive(); model.ReceiveID = ReceiveID; model.MaterialNum = MaterialNum; model.ClientNum = ClientNum; model.Count = Count; model.UserID = UserID; model.WorkStationID = WorkStationID; model.DataTime = DataTime; Maticsoft.BLL.Material_Receive bll = new Maticsoft.BLL.Material_Receive(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(decimal Re_ID) { Maticsoft.BLL.Material_Receive bll = new Maticsoft.BLL.Material_Receive(); Maticsoft.Model.Material_Receive model = bll.GetModel(Re_ID); this.lblRe_ID.Text = model.Re_ID.ToString(); this.lblReceiveID.Text = model.ReceiveID; this.lblMaterialNum.Text = model.MaterialNum; this.lblClientNum.Text = model.ClientNum; this.lblCount.Text = model.Count; this.lblUserID.Text = model.UserID; this.lblWorkStationID.Text = model.WorkStationID; this.lblDataTime.Text = model.DataTime.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Material_Receive model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Material_Receive set "); strSql.Append("Orm_ID=@Orm_ID,"); strSql.Append("Client=@Client,"); strSql.Append("ClientNum=@ClientNum,"); strSql.Append("Count=@Count,"); strSql.Append("UserID=@UserID,"); strSql.Append("WorkStationID=@WorkStationID,"); strSql.Append("DataTime=@DataTime"); strSql.Append(" where Re_ID=@Re_ID"); SqlParameter[] parameters = { new SqlParameter("@Orm_ID", SqlDbType.VarChar, 15), new SqlParameter("@Client", SqlDbType.VarChar, 50), new SqlParameter("@ClientNum", SqlDbType.VarChar, 50), new SqlParameter("@Count", SqlDbType.VarChar, 15), new SqlParameter("@UserID", SqlDbType.VarChar, 15), new SqlParameter("@WorkStationID", SqlDbType.VarChar, 15), new SqlParameter("@DataTime", SqlDbType.DateTime), new SqlParameter("@Re_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.Orm_ID; parameters[1].Value = model.Client; parameters[2].Value = model.ClientNum; parameters[3].Value = model.Count; parameters[4].Value = model.UserID; parameters[5].Value = model.WorkStationID; parameters[6].Value = model.DataTime; parameters[7].Value = model.Re_ID; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
// //领取记录 // private void dgv_Receive_Record_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { Set_IsEn(true, false); DataRowView dr = (DataRowView)dgv_Receive_Record.SelectedItem; decimal.TryParse(dr["Re_ID"].ToString(), out _WTT_Rece_ID); _MRce = _M_MaterReceive.GetModel(_WTT_Rece_ID); if (_MRce != null) { txb_Client.Text = _MRce.Client; txb_MaterialPath.Text = _MRce.ClientNum; txb_Count.Text = _MRce.Count; } } catch { // My_MessageBox.My_MessageBox_Erry(ex.Message + "\r\n弹出此错题的原因是您选择的列为空列!"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Material_Receive DataRowToModel(DataRow row) { Maticsoft.Model.Material_Receive model = new Maticsoft.Model.Material_Receive(); if (row != null) { if (row["Re_ID"] != null && row["Re_ID"].ToString() != "") { model.Re_ID = decimal.Parse(row["Re_ID"].ToString()); } if (row["Orm_ID"] != null) { model.Orm_ID = row["Orm_ID"].ToString(); } if (row["Client"] != null) { model.Client = row["Client"].ToString(); } if (row["ClientNum"] != null) { model.ClientNum = row["ClientNum"].ToString(); } if (row["Count"] != null) { model.Count = row["Count"].ToString(); } if (row["UserID"] != null) { model.UserID = row["UserID"].ToString(); } if (row["WorkStationID"] != null) { model.WorkStationID = row["WorkStationID"].ToString(); } if (row["DataTime"] != null && row["DataTime"].ToString() != "") { model.DataTime = DateTime.Parse(row["DataTime"].ToString()); } } return(model); }
// //保存 // private void btn_Save_Click(object sender, RoutedEventArgs e) { if (txb_UserName_Receive.Text != "") { Maticsoft.BLL.Material_Receive _M_Material_Receive = new Maticsoft.BLL.Material_Receive(); string dt = DateTime.Now.ToString(); if (txb_Count.Text != "" && _WTT_User_Receive != null) { Maticsoft.Model.Material_Receive _Material_receive = new Maticsoft.Model.Material_Receive() { Client = txb_Client.Text.Trim(), ClientNum = txb_MaterialPath.Text.Trim(), Count = txb_Count.Text.Trim(), Orm_ID = _WTT_Orm_ID, UserID = txb_JobNumber_Receive.Text.Trim(), WorkStationID = _WTT_WK.Wo_ID.ToString(), DataTime = DateTime.Now, Re_ID = _WTT_Rece_ID }; _M_Material_Receive.Update(_Material_receive); // txb_MaterialPath.Text = ""; DataSet temds = _M_MaterReceive.GetList("Orm_ID = '" + _WTT_Orm_ID + "'"); dgv_Receive_Record.ItemsSource = temds.Tables[0].DefaultView; _yetCount = _M_MaterReceive.Get_Count(_WTT_Orm_ID); //已领用量 txb_YetCount.Text = _yetCount.ToString("0.00"); } else { My_MessageBox.My_MessageBox_Message("数量未设置,或领用人未验证,完成后重试! "); } } else { My_MessageBox.My_MessageBox_Erry("请先输入修改人的工号!"); } }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Maticsoft.Model.Material_Receive model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Material_Receive("); strSql.Append("Orm_ID,Client,ClientNum,Count,UserID,WorkStationID,DataTime)"); strSql.Append(" values ("); strSql.Append("@Orm_ID,@Client,@ClientNum,@Count,@UserID,@WorkStationID,@DataTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Orm_ID", SqlDbType.VarChar, 15), new SqlParameter("@Client", SqlDbType.VarChar, 50), new SqlParameter("@ClientNum", SqlDbType.VarChar, 50), new SqlParameter("@Count", SqlDbType.VarChar, 15), new SqlParameter("@UserID", SqlDbType.VarChar, 15), new SqlParameter("@WorkStationID", SqlDbType.VarChar, 15), new SqlParameter("@DataTime", SqlDbType.DateTime) }; parameters[0].Value = model.Orm_ID; parameters[1].Value = model.Client; parameters[2].Value = model.ClientNum; parameters[3].Value = model.Count; parameters[4].Value = model.UserID; parameters[5].Value = model.WorkStationID; parameters[6].Value = model.DataTime; object obj = dbs.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Material_Receive GetModel(decimal Re_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Re_ID,Orm_ID,Client,ClientNum,Count,UserID,WorkStationID,DataTime from tb_Material_Receive "); strSql.Append(" where Re_ID=@Re_ID"); SqlParameter[] parameters = { new SqlParameter("@Re_ID", SqlDbType.Decimal) }; parameters[0].Value = Re_ID; Maticsoft.Model.Material_Receive model = new Maticsoft.Model.Material_Receive(); DataSet ds = dbs.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }