public static LoaiHopThuMODEL getLoaiHopThuByID(int id) { LoaiHopThuMODEL loaiHopThuModel = new LoaiHopThuMODEL(); //String sql = ConfigurationManager.AppSettings["sql.getLoaiHopThuByID"]; //SqlCommand objCommand = new SqlCommand(sql); //objCommand.Parameters.AddWithValue("@id", id); //DataTable result = DataUtil.executeQuery(objCommand); SqlParameter[] parameter = new SqlParameter[1]; int i = 0; parameter[i] = new SqlParameter("ID", SqlDbType.VarChar); parameter[i++].Value = id; DataTable result = DataUtil.executeStore("sp_getLoaiHopThuByID", parameter); foreach (DataRow row in result.Rows) { loaiHopThuModel.Id = row["ID"].ToString(); loaiHopThuModel.Ten = row["Ten"].ToString(); loaiHopThuModel.Ghi_Chu = row["Ghi_chu"].ToString(); loaiHopThuModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString(); loaiHopThuModel.User11 = row["User1"].ToString(); loaiHopThuModel.User21 = row["User2"].ToString(); loaiHopThuModel.User31 = row["User3"].ToString(); loaiHopThuModel.User41 = row["User4"].ToString(); loaiHopThuModel.User51 = row["User5"].ToString(); } return(loaiHopThuModel); }
private void but_Edit_Click(object sender, EventArgs e) { but_Add.Enabled = false; if (Constants.id.Equals("")) { MessageBox.Show("bạn chưa chọn dòng để thay đổi. Xin hãy chọn lại:", "Thông Báo"); } else { pnl_InboxType.Visible = true; Constants.choose = 2; loaiHopThuModel = LoaiHopThuDAO.getLoaiHopThuByID(Convert.ToInt32(Constants.id)); txt_IDInbox.Text = loaiHopThuModel.Id; txt_NameInbox.Text = loaiHopThuModel.Ten; txt_Note.Text = loaiHopThuModel.Ghi_Chu; but_Ok.Text = "Cập Nhật"; } }
public static bool insertLoaiHopThu(LoaiHopThuMODEL loaiHopThuModel) { try { SqlParameter[] parameter = new SqlParameter[8]; int i = 0; //parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar); //parameter[i++].Value = loaiHopThuModel.Id; parameter[i] = new SqlParameter("Ten", SqlDbType.NVarChar); parameter[i++].Value = loaiHopThuModel.Ten; parameter[i] = new SqlParameter("Ghi_chu", SqlDbType.NVarChar); parameter[i++].Value = loaiHopThuModel.Ghi_Chu; parameter[i] = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User1", SqlDbType.VarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User2", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User3", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User4", SqlDbType.NVarChar); parameter[i++].Value = ""; parameter[i] = new SqlParameter("User5", SqlDbType.NVarChar); parameter[i++].Value = ""; Boolean kq = DataUtil.executeNonStore("sp_SMS_InertLoaiHopThu", parameter); return(kq); } catch (Exception) { throw; } }