public int UpdateNSX(NhaSanXuat NSX) { List<SqlParameter> paramList = new List<SqlParameter>(); SqlParameter param = new SqlParameter(); param = new SqlParameter("@MaNSX", SqlDbType.Int); param.Value = NSX.MaNSX; paramList.Add(param); param = new SqlParameter("@TenNSX", SqlDbType.NVarChar); param.Value = NSX.TenNSX.Replace("'", "''"); paramList.Add(param); param = new SqlParameter("@DiaChi", SqlDbType.NVarChar); param.Value = NSX.DiaChi.Replace("'", "''"); paramList.Add(param); param = new SqlParameter("@DienThoai", SqlDbType.NVarChar); param.Value = NSX.DienThoai.Replace("'", "''"); paramList.Add(param); param = new SqlParameter("@Fax", SqlDbType.NVarChar); param.Value = NSX.Fax.Replace("'", "''"); paramList.Add(param); param = new SqlParameter("@Email", SqlDbType.NVarChar); param.Value = NSX.Email.Replace("'", "''"); paramList.Add(param); param = new SqlParameter("@GhiChu", SqlDbType.NVarChar); param.Value = NSX.GhiChu.Replace("'", "''"); paramList.Add(param); int i = dbHelper.ExecuteNonQuery("NSX_Update", paramList); return i; }
public Boolean UpdateNSX(NhaSanXuat NSX) { SystemLog systemLog = new SystemLog(QuanLy.IDUser, DateTime.Now.ToString(), "Sửa nhà sản xuất"); busUser.SetSystemLog(systemLog); if (NsxQ.UpdateNSX(NSX) > 0) { return true; } else return false; }
public ArrayList SelectAllNsx(string _TenNsx) { SqlDataReader rd = dbHelper.ExecuteQuery("GetNSXBYTenNSX N'%" + _TenNsx.Replace("'", "''") + "%'"); ArrayList arrNsx = new ArrayList(); while (rd.Read()) { NhaSanXuat NSX = new NhaSanXuat(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetString(3), rd.GetString(4), rd.GetString(5), rd.GetString(6)); arrNsx.Add(NSX); } rd.Close(); return arrNsx; }