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); }