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); }