public static bool updateThiNghiemByID(DTO.clsThiNghiemDTO TN)
{
string query = "UPDATE ThiNghiem SET XuatXu=@XuatXu,SearchXuatXu=@SearchXuatXu,NgayLayMau=@NgayLayMau,NgayNhanMau=@NgayNhanMau,NgayThuMau=@NgayThuMau,LyDoThiNghiem=@LyDoThiNghiem,PhuTrachLayMau=@PhuTrachLayMau,GhiChu=@GhiChu,Updated_at=@Updated_at,Updated_by=@Updated_by,Copy=0 WHERE ID=@ID";
OleDbParameter[] paras = new OleDbParameter[11];
paras[0] = new OleDbParameter("@XuatXu", TN.XuatXu);
paras[1] = new OleDbParameter("@SearchXuatXu", TN.SearchXuatXu);
paras[2] = new OleDbParameter("@NgayLayMau", OleDbType.DBDate);
paras[2].Value = TN.NgayLayMau;
paras[3] = new OleDbParameter("@NgayNhanMau", OleDbType.DBDate);
paras[3].Value = TN.NgayNhanMau;
paras[4] = new OleDbParameter("@NgayThuMau", OleDbType.DBDate);
paras[4].Value = TN.NgayThuMau;
paras[5] = new OleDbParameter("@LyDoThiNghiem", TN.LyDoThiNghiem);
paras[6] = new OleDbParameter("@PhuTrachLayMau", TN.PhuTrachLayMau);
paras[7] = new OleDbParameter("@GhiChu", TN.GhiChu);
paras[8] = new OleDbParameter("@Updated_at", OleDbType.Date);
paras[8].Value = DateTime.Now;
paras[9] = new OleDbParameter("@Updated_by", TN.Updated_by);
paras[10] = new OleDbParameter("@ID", TN.ID);
return(DAO.DataProvider.ExecuteUpdateQuery(query, paras) == 1);
}
public static bool addThiNghiem(DTO.clsThiNghiemDTO TN)
{
string query = "INSERT INTO ThiNghiem(ID,XuatXu,SearchXuatXu,NgayLayMau,NgayNhanMau,NgayThuMau,LyDoThiNghiem,PhuTrachLayMau,GhiChu,ID_LoaiThiNghiem,Created_at,Created_by) VALUES (@ID,@XuatXu,@SearchXuatXu,@NgayLayMau,@NgayNhanMau,@NgayThuMau,@LyDoThiNghiem,@PhuTrachLayMau,@GhiChu,@ID_LoaiThiNghiem,@Created_at,@Created_by)";
OleDbParameter[] para = new OleDbParameter[12];
para[0] = new OleDbParameter("@ID", TN.ID);
para[1] = new OleDbParameter("@XuatXu", TN.XuatXu);
para[2] = new OleDbParameter("@SearchXuatXu", TN.SearchXuatXu);
para[3] = new OleDbParameter("@NgayLayMau", OleDbType.DBDate);
para[3].Value = TN.NgayLayMau;
para[4] = new OleDbParameter("@NgayNhanMau", OleDbType.DBDate);
para[4].Value = TN.NgayNhanMau;
para[5] = new OleDbParameter("@NgayThuMau", OleDbType.DBDate);
para[5].Value = TN.NgayThuMau;
para[6] = new OleDbParameter("@LyDoThiNghiem", TN.LyDoThiNghiem);
para[7] = new OleDbParameter("@PhuTrachLayMau", TN.PhuTrachLayMau);
para[8] = new OleDbParameter("@GhiChu", TN.GhiChu);
para[9] = new OleDbParameter("@ID_LoaiThiNghiem", TN.ID_LoaiThiNghiem);
para[10] = new OleDbParameter("@Created_at", OleDbType.Date);
para[10].Value = TN.Created_at;
para[11] = new OleDbParameter("@Created_by", TN.Created_by);
return(DAO.DataProvider.ExecuteInsertQuery(query, para) == 1);
}
