public NewREMARKWP(WP_RVO rvo, SummonRVO rvos, IRole uvo)
{
this.RVO = rvo;
this.RVOS = rvos;
this.UVO = uvo;
InitializeComponent();
}
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(SummonRVO 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("IDSUMMON", RVO.IDSUMMON);
DA.InsertCommand.Parameters.AddWithValue("REMARK", RVO.REMARK);
DA.InsertCommand.CommandText = "insert into " + Base.BaseName + "..REMARKSUMMON (DATEREMARK,DOCUMENTNAME,IDCREATOR,IDSUMMON,REMARK) " +
" values (@DATEREMARK,@DOCUMENTNAME,@IDCREATOR,@IDSUMMON,@REMARK)";
DA.InsertCommand.Connection.Open();
DA.InsertCommand.ExecuteNonQuery();
DA.InsertCommand.Connection.Close();
}
internal void Edit(SummonRVO 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("IDSUMMON", RVO.IDSUMMON);
DA.UpdateCommand.Parameters.AddWithValue("REMARK", RVO.REMARK);
DA.UpdateCommand.CommandText = "update " + Base.BaseName + "..REMARKSUMMON set CLOSED = @CLOSED, CLOSINGCOMMENT=@CLOSINGCOMMENT " +
", DATECLOSE=@DATECLOSE, DATEREMARK=@DATEREMARK, DOCUMENTNAME=@DOCUMENTNAME,IDCLOSER=@IDCLOSER " +
", IDCREATOR=@IDCREATOR, IDSUMMON=@IDSUMMON, REMARK = @REMARK " +
" where ID = @ID";
DA.UpdateCommand.Connection.Open();
DA.UpdateCommand.ExecuteNonQuery();
DA.UpdateCommand.Connection.Close();
}
internal SummonRVO GetRemarkByID(string id)
{
DA.SelectCommand.CommandText = "select * from " + Base.BaseName + "..REMARKSUMMON where ID = " + id;
int i = DA.Fill(DS, "t");
if (i == 0)
{
return(null);
}
SummonRVO RVO = new SummonRVO();
RVO.ID = id;
RVO.CLOSED = (bool)DS.Tables["t"].Rows[0]["CLOSED"];
RVO.CLOSINGCOMMENT = DS.Tables["t"].Rows[0]["CLOSINGCOMMENT"].ToString();
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.IDSUMMON = DS.Tables["t"].Rows[0]["IDSUMMON"].ToString();
RVO.REMARK = DS.Tables["t"].Rows[0]["REMARK"].ToString();
return(RVO);
}
