// //查看重工记录 // private void dgv_Info_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { Maticsoft.Model.Rework temRek = (Maticsoft.Model.Rework)dgv_Info.SelectedItem; Maticsoft.Model.Rejected temRej = new Maticsoft.Model.Rejected(); Maticsoft.Model.Dispose temDis = new Maticsoft.Model.Dispose(); temRej = _M_Rejected.GetModel(temRek.RejectID); temDis = _M_Dispose.GetModel(decimal.Parse(temRek.DisposeID)); //不良显示 cmb_Reject.Text = temRej.Reject; txb_Search_RejectCode.Text = temRej.RejectCode; //在控件中显示图片 BitmapImage BI = new BitmapImage(); BI.BeginInit(); BI.StreamSource = new MemoryStream(temRej.Picture); //bufPic是图片二进制,byte类型 BI.EndInit(); image1.Source = BI; //image是XAML页面上定义的Image控件 //处理方法显示 cmb_DesposeMethod.Text = temDis.DisposeMethod; lab_ID.Content = temDis.ID; //处理结果 txb_SerialNumber.Text = temRek.SN; cmb_PigtaiType.Text = temRek.PigtailType; cmb_Result.Text = temRek.Result; txb_Operator.Text = temRek.ReworkID; txb_Verify.Text = temRek.VerifyID; txb_Length.Text = temRek.Length; } catch (System.Exception ex) { My_MessageBox.My_MessageBox_Message(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Rework model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Rework set "); strSql.Append("SN=@SN,"); strSql.Append("PigtailType=@PigtailType,"); strSql.Append("Count=@Count,"); strSql.Append("RejectID=@RejectID,"); strSql.Append("RejectDescribe=@RejectDescribe,"); strSql.Append("DisposeID=@DisposeID,"); strSql.Append("DisposeDescribe=@DisposeDescribe,"); strSql.Append("Length=@Length,"); strSql.Append("Result=@Result,"); strSql.Append("ReworkID=@ReworkID,"); strSql.Append("VerifyID=@VerifyID"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@SN", SqlDbType.VarChar, 50), new SqlParameter("@PigtailType", SqlDbType.VarChar, 50), new SqlParameter("@Count", SqlDbType.VarChar, 50), new SqlParameter("@RejectID", SqlDbType.VarChar, 50), new SqlParameter("@RejectDescribe", SqlDbType.VarChar, 255), new SqlParameter("@DisposeID", SqlDbType.VarChar, 50), new SqlParameter("@DisposeDescribe", SqlDbType.VarChar, 255), new SqlParameter("@Length", SqlDbType.VarChar, 50), new SqlParameter("@Result", SqlDbType.VarChar, 50), new SqlParameter("@ReworkID", SqlDbType.VarChar, 50), new SqlParameter("@VerifyID", SqlDbType.VarChar, 50), new SqlParameter("@ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.SN; parameters[1].Value = model.PigtailType; parameters[2].Value = model.Count; parameters[3].Value = model.RejectID; parameters[4].Value = model.RejectDescribe; parameters[5].Value = model.DisposeID; parameters[6].Value = model.DisposeDescribe; parameters[7].Value = model.Length; parameters[8].Value = model.Result; parameters[9].Value = model.ReworkID; parameters[10].Value = model.VerifyID; parameters[11].Value = model.ID; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Rework DataRowToModel(DataRow row) { Maticsoft.Model.Rework model = new Maticsoft.Model.Rework(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = decimal.Parse(row["ID"].ToString()); } if (row["SN"] != null) { model.SN = row["SN"].ToString(); } if (row["PigtailType"] != null) { model.PigtailType = row["PigtailType"].ToString(); } if (row["Count"] != null) { model.Count = row["Count"].ToString(); } if (row["RejectID"] != null) { model.RejectID = row["RejectID"].ToString(); } if (row["RejectDescribe"] != null) { model.RejectDescribe = row["RejectDescribe"].ToString(); } if (row["DisposeID"] != null) { model.DisposeID = row["DisposeID"].ToString(); } if (row["DisposeDescribe"] != null) { model.DisposeDescribe = row["DisposeDescribe"].ToString(); } if (row["Length"] != null) { model.Length = row["Length"].ToString(); } if (row["Result"] != null) { model.Result = row["Result"].ToString(); } if (row["ReworkID"] != null) { model.ReworkID = row["ReworkID"].ToString(); } if (row["VerifyID"] != null) { model.VerifyID = row["VerifyID"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Maticsoft.Model.Rework model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Rework("); strSql.Append("SN,PigtailType,Count,RejectID,RejectDescribe,DisposeID,DisposeDescribe,Length,Result,ReworkID,VerifyID)"); strSql.Append(" values ("); strSql.Append("@SN,@PigtailType,@Count,@RejectID,@RejectDescribe,@DisposeID,@DisposeDescribe,@Length,@Result,@ReworkID,@VerifyID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SN", SqlDbType.VarChar, 50), new SqlParameter("@PigtailType", SqlDbType.VarChar, 50), new SqlParameter("@Count", SqlDbType.VarChar, 50), new SqlParameter("@RejectID", SqlDbType.VarChar, 50), new SqlParameter("@RejectDescribe", SqlDbType.VarChar, 255), new SqlParameter("@DisposeID", SqlDbType.VarChar, 50), new SqlParameter("@DisposeDescribe", SqlDbType.VarChar, 255), new SqlParameter("@Length", SqlDbType.VarChar, 50), new SqlParameter("@Result", SqlDbType.VarChar, 50), new SqlParameter("@ReworkID", SqlDbType.VarChar, 50), new SqlParameter("@VerifyID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.SN; parameters[1].Value = model.PigtailType; parameters[2].Value = model.Count; parameters[3].Value = model.RejectID; parameters[4].Value = model.RejectDescribe; parameters[5].Value = model.DisposeID; parameters[6].Value = model.DisposeDescribe; parameters[7].Value = model.Length; parameters[8].Value = model.Result; parameters[9].Value = model.ReworkID; parameters[10].Value = model.VerifyID; object obj = dbs.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
private void ShowInfo(decimal ID) { Maticsoft.BLL.Rework bll = new Maticsoft.BLL.Rework(); Maticsoft.Model.Rework model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.lblSN.Text = model.SN; this.lblPigtailType.Text = model.PigtailType; this.lblCount.Text = model.Count; this.lblRejectID.Text = model.RejectID; this.lblRejectDescribe.Text = model.RejectDescribe; this.lblDisposeID.Text = model.DisposeID; this.lblDisposeDescribe.Text = model.DisposeDescribe; this.lblLength.Text = model.Length; this.lblResult.Text = model.Result; this.lblReworkID.Text = model.ReworkID; this.lblVerifyID.Text = model.VerifyID; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Rework GetModel(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SN,PigtailType,Count,RejectID,RejectDescribe,DisposeID,DisposeDescribe,Length,Result,ReworkID,VerifyID from tb_Rework "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Decimal) }; parameters[0].Value = ID; Maticsoft.Model.Rework model = new Maticsoft.Model.Rework(); DataSet ds = dbs.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtSN.Text.Trim().Length == 0) { strErr += "SN不能为空!\\n"; } if (this.txtPigtailType.Text.Trim().Length == 0) { strErr += "PigtailType不能为空!\\n"; } if (this.txtCount.Text.Trim().Length == 0) { strErr += "Count不能为空!\\n"; } if (this.txtRejectID.Text.Trim().Length == 0) { strErr += "RejectID不能为空!\\n"; } if (this.txtRejectDescribe.Text.Trim().Length == 0) { strErr += "RejectDescribe不能为空!\\n"; } if (this.txtDisposeID.Text.Trim().Length == 0) { strErr += "DisposeID不能为空!\\n"; } if (this.txtDisposeDescribe.Text.Trim().Length == 0) { strErr += "DisposeDescribe不能为空!\\n"; } if (this.txtLength.Text.Trim().Length == 0) { strErr += "Length不能为空!\\n"; } if (this.txtResult.Text.Trim().Length == 0) { strErr += "Result不能为空!\\n"; } if (this.txtReworkID.Text.Trim().Length == 0) { strErr += "ReworkID不能为空!\\n"; } if (this.txtVerifyID.Text.Trim().Length == 0) { strErr += "VerifyID不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } decimal ID = decimal.Parse(this.lblID.Text); string SN = this.txtSN.Text; string PigtailType = this.txtPigtailType.Text; string Count = this.txtCount.Text; string RejectID = this.txtRejectID.Text; string RejectDescribe = this.txtRejectDescribe.Text; string DisposeID = this.txtDisposeID.Text; string DisposeDescribe = this.txtDisposeDescribe.Text; string Length = this.txtLength.Text; string Result = this.txtResult.Text; string ReworkID = this.txtReworkID.Text; string VerifyID = this.txtVerifyID.Text; Maticsoft.Model.Rework model = new Maticsoft.Model.Rework(); model.ID = ID; model.SN = SN; model.PigtailType = PigtailType; model.Count = Count; model.RejectID = RejectID; model.RejectDescribe = RejectDescribe; model.DisposeID = DisposeID; model.DisposeDescribe = DisposeDescribe; model.Length = Length; model.Result = Result; model.ReworkID = ReworkID; model.VerifyID = VerifyID; Maticsoft.BLL.Rework bll = new Maticsoft.BLL.Rework(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }