public Boolean UpdateDVT(DonViTinh DVT) {
SystemLog systemLog = new SystemLog(QuanLy.IDUser, DateTime.Now.ToString(), "Sửa đơn vị tính");
busUser.SetSystemLog(systemLog);
if (DvtQ.UpdateDVT(DVT) > 0)
{
return true;
}
else return false;
}
public ArrayList SelectAllDVT()
{
SqlDataReader rd = dbHelper.ExecuteQuery("GetAllDVT");
ArrayList arrDVT = new ArrayList();
while (rd.Read())
{
DonViTinh DVT = new DonViTinh(rd.GetInt32(0), rd.GetString(1));
arrDVT.Add(DVT);
}
rd.Close();
return arrDVT;
}
public int UpdateDVT(DonViTinh DVT)
{
List<SqlParameter> paramList = new List<SqlParameter>();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@MaDVT", SqlDbType.Int);
param.Value = DVT.MaDVT;
paramList.Add(param);
param = new SqlParameter("@TenDVT", SqlDbType.NVarChar);
param.Value = DVT.Ten.Replace("'", "''");
paramList.Add(param);
int i = dbHelper.ExecuteNonQuery("UpdateDVT", paramList);
return i;
}