private void btn_Sua_Click(object sender, EventArgs e)
{
if (ID != "")
{
DataTable dt = new DataTable();
DataTable dskh = new DataTable();
using (SqlConnection cnn = Class.datatabase.getConnection())
{
cnn.Open();
SqlDataAdapter adap = new SqlDataAdapter(@"select * from SMSTuyBienStore Where IdCongTy=@IdCongTy and IdSMSTuyBien=@IdSMSTuyBien", cnn);
adap.SelectCommand.Parameters.AddWithValue("@IdCongTy", Class.CompanyInfo.idcongty);
adap.SelectCommand.Parameters.AddWithValue("@IdSMSTuyBien", Convert.ToInt64(ID));
adap.Fill(dt);
SqlDataAdapter adap1 = new SqlDataAdapter(@"select kh.* from KhachHang kh, TinNhan tn Where kh.IdCongTy=@IdCongTy and tn.IdKhachHang=kh.IdKhachHang and tn.IdSMSTuyBien=@IdSMSTuyBien", cnn);
adap1.SelectCommand.Parameters.AddWithValue("@IdCongTy", Class.CompanyInfo.idcongty);
adap1.SelectCommand.Parameters.AddWithValue("@IdSMSTuyBien", Convert.ToInt64(ID));
adap1.Fill(dskh);
cnn.Close();
}
FrmSMSTuyBien frm = new FrmSMSTuyBien();
frm.Id = ID;
frm.txt_GioNhan.Text = dt.Rows[0][5].ToString();
frm.txt_SMS.Text = dt.Rows[0][3].ToString();
frm.dt_NgayNhan.Value = Convert.ToDateTime(dt.Rows[0][6].ToString());
frm.dskh = dskh;
frm.ShowDialog();
}
else
{
MessageBox.Show("Hãy chọn lịch muốn sửa!");
}
}
private void btn_DatLich_Click(object sender, EventArgs e)
{
FrmSMSTuyBien frm = new FrmSMSTuyBien();
frm.ShowDialog();
}