public NewREMARKWP(WP_RVO rvo, SummonRVO rvos, IRole uvo) { this.RVO = rvo; this.RVOS = rvos; this.UVO = uvo; InitializeComponent(); }
internal WP_RVO GetRemarkByID(string id) { DA.SelectCommand.CommandText = "select * from " + Base.BaseName + "..REMARKWP where ID = " + id; int i = DA.Fill(DS, "t"); if (i == 0) { return(null); } WP_RVO RVO = new WP_RVO(); RVO.ID = id; RVO.CLOSED = (bool)DS.Tables["t"].Rows[0]["CLOSED"]; RVO.CLOSINGCOMMENT = DS.Tables["t"].Rows[0]["CLOSINGCOMMENT"].ToString(); //Type ty = o.GetType(); RVO.DATECLOSE = (DS.Tables["t"].Rows[0]["DATECLOSE"].GetType() == typeof(DBNull)) ? DateTime.Now : (DateTime)DS.Tables["t"].Rows[0]["DATECLOSE"]; RVO.DATEREMARK = (DateTime)DS.Tables["t"].Rows[0]["DATEREMARK"]; RVO.DOCUMENTNAME = DS.Tables["t"].Rows[0]["DOCUMENTNAME"].ToString(); RVO.IDCLOSER = DS.Tables["t"].Rows[0]["IDCLOSER"].ToString(); RVO.IDCREATOR = DS.Tables["t"].Rows[0]["IDCREATOR"].ToString(); RVO.IDWP = DS.Tables["t"].Rows[0]["IDWP"].ToString(); RVO.REMARK = DS.Tables["t"].Rows[0]["REMARK"].ToString(); return(RVO); }
private void button2_Click(object sender, EventArgs e) { if (this.RemarkType == "WP") { RVO = WP_RVO.RemarkVOByID(this.ID); DBRemarkWP dbr = new DBRemarkWP(UVO); RVO.CLOSED = true; RVO.CLOSINGCOMMENT = textBox1.Text; RVO.DATECLOSE = DateTime.Now; RVO.IDCLOSER = UVO.id; dbr.Edit(RVO); } else { SummonRVO RVO = SummonRVO.RemarkVOByID(this.ID); DBRemarkSUMMON dbr = new DBRemarkSUMMON(); RVO.CLOSED = true; RVO.CLOSINGCOMMENT = textBox1.Text; RVO.DATECLOSE = DateTime.Now; RVO.IDCLOSER = UVO.id; dbr.Edit(RVO); } MessageBox.Show("Замечание успешно отработано!"); Close(); }
public void AddNew(WP_RVO RVO) { DA.InsertCommand.Parameters.AddWithValue("DATEREMARK", RVO.DATEREMARK); DA.InsertCommand.Parameters.AddWithValue("DOCUMENTNAME", RVO.DOCUMENTNAME); DA.InsertCommand.Parameters.AddWithValue("IDCREATOR", RVO.IDCREATOR); DA.InsertCommand.Parameters.AddWithValue("IDWP", RVO.IDWP); DA.InsertCommand.Parameters.AddWithValue("REMARK", RVO.REMARK); DA.InsertCommand.CommandText = "insert into " + Base.BaseName + "..REMARKWP (DATEREMARK,DOCUMENTNAME,IDCREATOR,IDWP,REMARK) " + " values (@DATEREMARK,@DOCUMENTNAME,@IDCREATOR,@IDWP,@REMARK)"; DA.InsertCommand.Connection.Open(); DA.InsertCommand.ExecuteNonQuery(); DA.InsertCommand.Connection.Close(); }
internal void Edit(WP_RVO RVO) { DA.UpdateCommand.Parameters.AddWithValue("ID", RVO.ID); DA.UpdateCommand.Parameters.AddWithValue("CLOSED", RVO.CLOSED); DA.UpdateCommand.Parameters.AddWithValue("CLOSINGCOMMENT", ((object)RVO.CLOSINGCOMMENT) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("DATECLOSE", ((object)RVO.DATECLOSE) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("DATEREMARK", RVO.DATEREMARK); DA.UpdateCommand.Parameters.AddWithValue("DOCUMENTNAME", RVO.DOCUMENTNAME); DA.UpdateCommand.Parameters.AddWithValue("IDCLOSER", ((object)RVO.IDCLOSER) ?? DBNull.Value); DA.UpdateCommand.Parameters.AddWithValue("IDCREATOR", RVO.IDCREATOR); DA.UpdateCommand.Parameters.AddWithValue("IDWP", RVO.IDWP); DA.UpdateCommand.Parameters.AddWithValue("REMARK", RVO.REMARK); DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..REMARKWP set CLOSED = @CLOSED, CLOSINGCOMMENT=@CLOSINGCOMMENT " + ", DATECLOSE=@DATECLOSE, DATEREMARK=@DATEREMARK, DOCUMENTNAME=@DOCUMENTNAME,IDCLOSER=@IDCLOSER " + ", IDCREATOR=@IDCREATOR, IDWP=@IDWP, REMARK = @REMARK " + " where ID = @ID"; DA.UpdateCommand.Connection.Open(); DA.UpdateCommand.ExecuteNonQuery(); DA.UpdateCommand.Connection.Close(); }