public static void UpdateMulti(LienKet LK_Active)
{
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("LK_ID", LK_Active.multiID);
obj[1] = new SqlParameter("LK_Active", LK_Active.Active);
SqlHelper.ExecuteNonQuery(DAL.con(), CommandType.StoredProcedure, "sp_tblLienket_Update_UpdateMultiById_hungpm", obj);
}
public static LienKet Update(LienKet Updated)
{
LienKet Item = new LienKet();
SqlParameter[] obj = new SqlParameter[16];
obj[0] = new SqlParameter("LK_ID", Updated.ID);
obj[1] = new SqlParameter("LK_Ten", Updated.Ten);
obj[2] = new SqlParameter("LK_MoTa", Updated.MoTa);
obj[3] = new SqlParameter("LK_Anh", Updated.Anh);
obj[4] = new SqlParameter("LK_NgayTao", Updated.NgayTao);
obj[5] = new SqlParameter("LK_NguoiTao", Updated.NguoiTao);
obj[6] = new SqlParameter("LK_RowId", Updated.RowId);
obj[7] = new SqlParameter("LK_Active", Updated.Active);
obj[8] = new SqlParameter("LK_ThuTu", Updated.ThuTu);
obj[9] = new SqlParameter("LK_NgayCapNhat", Updated.NgayCapNhat);
obj[10] = new SqlParameter("LK_NguoiCapNhat", Updated.NguoiCapNhat);
obj[11] = new SqlParameter("LK_NgayDang", Updated.NgayDang);
string htl = string.Format("{0:dd/MM/yy}", Updated.NgayDang);
if (htl != "01/01/01")
{
obj[11] = new SqlParameter("LK_NgayDang", Updated.NgayDang);
}
else
{
obj[11] = new SqlParameter("LK_NgayDang", DBNull.Value);
}
obj[12] = new SqlParameter("LK_NgayHetHan", Updated.NgayHetHan);
string htl1 = string.Format("{0:dd/MM/yy}", Updated.NgayHetHan);
if (htl != "01/01/01")
{
obj[12] = new SqlParameter("LK_NgayHetHan", Updated.NgayHetHan);
}
else
{
obj[12] = new SqlParameter("LK_NgayHetHan", DBNull.Value);
}
obj[13] = new SqlParameter("LK_HetHan", Updated.HetHan);
obj[14] = new SqlParameter("LK_Moi", Updated.Moi);
obj[15] = new SqlParameter("LK_url", Updated.url);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienket_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static LienKet SelectById(Int64 LK_ID)
{
LienKet Item = new LienKet();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("LK_ID", LK_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblLienket_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static void UpdateHetHanMulti(LienKet LKHetHan)
{
SqlParameter[] obj = new SqlParameter[3];
obj[0] = new SqlParameter("LK_ID", LKHetHan.multiID);
obj[1] = new SqlParameter("LK_HetHan", LKHetHan.HetHan);
obj[2] = new SqlParameter("LK_NgayHetHan", LKHetHan.NgayHetHan);
string htl = string.Format("{0:dd/MM/yy}", LKHetHan.NgayHetHan);
if (htl != "01/01/01")
{
obj[2] = new SqlParameter("LK_NgayHetHan", LKHetHan.NgayHetHan);
}
else
{
obj[2] = new SqlParameter("LK_NgayHetHan", DBNull.Value);
}
SqlHelper.ExecuteNonQuery(DAL.con(), CommandType.StoredProcedure, "sp_tblLienket_Update_UpdateHetHanMultiById_hungpm", obj);
}
public static LienKet getFromReader(IDataReader rd)
{
LienKet Item = new LienKet();
if (rd.FieldExists("LK_ID"))
{
Item.ID = (Int64)(rd["LK_ID"]);
}
if (rd.FieldExists("LK_Ten"))
{
Item.Ten = (String)(rd["LK_Ten"]);
}
if (rd.FieldExists("LK_url"))
{
Item.url = (String)(rd["LK_url"]);
}
if (rd.FieldExists("LK_MoTa"))
{
Item.MoTa = (String)(rd["LK_MoTa"]);
}
if (rd.FieldExists("LK_Anh"))
{
Item.Anh = (String)(rd["LK_Anh"]);
}
if (rd.FieldExists("LK_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["LK_NgayTao"]);
}
if (rd.FieldExists("LK_NguoiTao"))
{
Item.NguoiTao = (String)(rd["LK_NguoiTao"]);
}
if (rd.FieldExists("LK_RowId"))
{
Item.RowId = (Guid)(rd["LK_RowId"]);
}
if (rd.FieldExists("LK_Active"))
{
Item.Active = (Boolean)(rd["LK_Active"]);
}
if (rd.FieldExists("LK_ThuTu"))
{
Item.ThuTu = (Int32)(rd["LK_ThuTu"]);
}
if (rd.FieldExists("LK_NgayCapNhat"))
{
Item.NgayCapNhat = (DateTime)(rd["LK_NgayCapNhat"]);
}
if (rd.FieldExists("LK_NguoiCapNhat"))
{
Item.NguoiCapNhat = (String)(rd["LK_NguoiCapNhat"]);
}
if (rd.FieldExists("LK_NgayDang"))
{
Item.NgayDang = (DateTime)(rd["LK_NgayDang"]);
}
if (rd.FieldExists("LK_NgayHetHan"))
{
Item.NgayHetHan = (DateTime)(rd["LK_NgayHetHan"]);
}
if (rd.FieldExists("LK_HetHan"))
{
Item.HetHan = (Boolean)(rd["LK_HetHan"]);
}
if (rd.FieldExists("LK_Moi"))
{
Item.Moi = (Boolean)(rd["LK_Moi"]);
}
return(Item);
}
