public static bool UpdateQuyDinh(QuyDinh qd)
{
var cm = CreateCommand();
cm.CommandText = @"Exec update_row_QuyDinh @ID, @MT, @GT, @DV";
cm.Parameters.Add(new SqlParameter("@ID", qd.ID));
cm.Parameters.Add(new SqlParameter("@MT", qd.MoTa));
cm.Parameters.Add(new SqlParameter("@GT", qd.GiaTri));
cm.Parameters.Add(new SqlParameter("@DV", qd.DonVi));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static QuyDinh Read(SqlDataReader reader)
{
var qd = new QuyDinh()
{
ID = reader.GetString(iID),
MoTa = reader.GetString(iMoTa),
GiaTri = reader.GetFloat(iGiaTri),
DonVi = reader.GetString(iDonVi)
};
byte[] bytes = Encoding.Default.GetBytes(qd.MoTa);
qd.MoTa = Encoding.UTF8.GetString(bytes);
return(qd);
}
public static List <QuyDinh> DSQuyDinh()
{
var lqd = new List <QuyDinh>();
var cm = CreateCommand();
cm.CommandText = @"SELECT * FROM QUYDINH";
var reader = cm.ExecuteReader();
while (reader.Read())
{
lqd.Add(QuyDinh.Read(reader));
}
cn.Close();
return(lqd);
}