public T_Nguoidung_Chucnang GetOneFromT_UserMenuByID(Int32 UserMenu_ID) { try { return((T_Nguoidung_Chucnang)HPCDataProvider.Instance().GetObjectByID(UserMenu_ID.ToString(), "T_UserMenu", "UserMenu_ID")); } catch (Exception ex) { throw ex; } }
public DataSet Sp_DuyetAnhDinhKem(string WhereCondition) { try { return(HPCDataProvider.Instance().GetStoreDataSet("Sp_DuyetAnhDinhKem", new string[] { "@Where" }, new object[] { WhereCondition })); } catch (Exception ex) { throw ex; } }
public DataSet ListPhotoOfNews(string _where) { try { return(HPCDataProvider.Instance().GetStoreDataSet("[Sp_ListPhotosTopForSelect]", new string[] { "@WhereCondition" }, new object[] { _where })); } catch (Exception ex) { throw ex; } }
public void DeleteFromT_Anh(int _Maanh) { try { HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_Anh", new string[] { "@Ma_Anh" }, new object[] { _Maanh }); } catch (Exception ex) { throw ex; } }
public DataSet Sp_SelectTulieuanhDynamic(string WhereCondition, string order) { try { return(HPCDataProvider.Instance().GetStoreDataSet("Sp_SelectTuLieuAnh_Dynamic", new string[] { "@WhereCondition", "@OrderByExpression" }, new object[] { WhereCondition, order })); } catch (Exception ex) { throw ex; } }
public void DeleteFrom_T_Album_Photo(Int32 ID) { try { HPCDataProvider.Instance().ExecStore("[CMS_DeleteOneFromT_Album_Photo]", new string[] { "@Alb_Photo_ID" }, new object[] { ID }); } catch (Exception ex) { throw ex; } }
public void UpdateStatus_AlbumPhoto(int Cat_Album_ID, int Status, int Creator, DateTime Date_Create) { try { HPCDataProvider.Instance().ExecStore("[CMS_UpdateStatus_AlbumPhoto]", new string[] { "@Alb_Photo_ID", "@Status", "@Creator", "@Date_Create" }, new object[] { Cat_Album_ID, Status, Creator, Date_Create }); } catch (Exception ex) { throw ex; } }
public DataSet Check_Doituong(string MaDT, string TenDT) { try { return(HPCDataProvider.Instance().GetDataSet("T_Doituong", "Ten_Doituong, Ma_Doituong", " Ma_Doituong = N'" + MaDT + "' or Ten_Doituong = N'" + TenDT + "'")); } catch (Exception ex) { throw ex; } }
public DataSet Select_TenDoiTuong(string _tenDT) { try { return(HPCDataProvider.Instance().GetDataSet("T_Doituong", "Ten_Doituong", " Ten_Doituong like '%" + _tenDT + "%' ")); } catch (Exception ex) { throw ex; } }
public DataSet BindGridT_Nguoidung_Chucnang(int PageIndex, int PageSize, string WhereCondition) { try { return(HPCDataProvider.Instance().GetStoreDataSet("Sp_ListT_UserMenuDynamic", new string[] { "@PageIndex", "@PageSize", "@where" }, new object[] { PageIndex, PageSize, WhereCondition })); } catch (Exception ex) { throw ex; } }
public void InsertT_Doituong_AnPham(string MaDT, int MaAnPham) { try { HPCDataProvider.Instance().ExecStore("Sp_InsertT_Doituong_Anpham", new string[] { "@MaDT", "@MaAnPham" }, new object[] { MaDT, MaAnPham }); } catch (Exception ex) { throw ex; } }
public void InsertT_Nguoidung_Chucnang(T_Nguoidung_Chucnang _T_UserMenu) { try { HPCDataProvider.Instance().InsertObject(_T_UserMenu); } catch (Exception ex) { throw ex; } }
public void UpdateFromT_Nguoidung_ChucnangDynamic(string WhereCondition) { try { HPCDataProvider.Instance().ExecStore("Sp_UpdateT_UserMenuDynamic", new string[] { "@WhereCondition" }, new object[] { WhereCondition }); } catch (Exception ex) { throw ex; } }
public void DeleteFromT_Nguoidung_ChucnangByID(Int32 UserMenu_ID) { try { HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_UserMenu", new string[] { "@UserMenu_ID" }, new object[] { UserMenu_ID }); } catch (Exception ex) { throw ex; } }
public DataSet Bind_T_Album_PhotoDynamic(int PageIndex, int PageSize, string WhereCondition) { try { return(HPCDataProvider.Instance().GetStoreDataSet("[CMS_ListT_Album_PhotoDynamic]", new string[] { "@PageIndex", "@PageSize", "@where" }, new object[] { PageIndex, PageSize, WhereCondition })); } catch (Exception ex) { throw ex; } }
public DataSet Select_STT(string _maDT) { try { return(HPCDataProvider.Instance().GetDataSet("T_Doituong", "STT", " Ma_Doituong like '%" + _maDT + "%' ")); } catch (Exception ex) { throw ex; } }
public DataSet Bind_T_Album_Photo(int CatID) { try { return(HPCDataProvider.Instance().GetStoreDataSet("[CMS_ListT_Album_Photo]", new string[] { "@CatID" }, new object[] { CatID })); } catch (Exception ex) { throw ex; } }
public int InsertT_Doituong(T_Doituong _Obj) { try { return(HPCDataProvider.Instance().InsertObjectReturn(_Obj, "Sp_InsertT_Doituong")); } catch (Exception ex) { throw ex; } }
public void Insert_T_Album_Photo_From_T_Album_Photo(int Cat_Album_ID, int CopyFrom, int Lang_Id) { try { HPCDataProvider.Instance().ExecStore("[CMS_Insert_T_Album_Photo_From_T_Album_Photo]", new string[] { "@Alb_Photo_ID", "@CopyFrom", "@Lang_Id " }, new object[] { Cat_Album_ID, CopyFrom, Lang_Id }); } catch (Exception ex) { throw ex; } }
public void DeleteOneFromT_Doituong(int _Id) { try { HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_Doituong", new string[] { "@ID" }, new object[] { _Id }); } catch (Exception ex) { throw ex; } }
public T_Album_Photo GetOneFromT_Album_PhotoByID(Int32 _ID) { try { return((T_Album_Photo)HPCDataProvider.Instance().GetObjectByID(_ID.ToString(), "T_Album_Photo", "Alb_Photo_ID")); } catch (Exception ex) { throw ex; } }
public void DeleteOneFromT_Doituong_AnPham(int _Id, int _maanpham) { try { HPCDataProvider.Instance().ExecStore("Sp_DeleteOneFromT_Doituong_AnPham", new string[] { "@ID", "@Ma_Anpham" }, new object[] { _Id, _maanpham }); } catch (Exception ex) { throw ex; } }
public void UpdateinfoT_Anh(string WhereCondition) { try { HPCDataProvider.Instance().ExecStore("Sp_UpdateT_AnhDynamic", new string[] { "@WhereCondition" }, new object[] { WhereCondition }); } catch (Exception ex) { throw ex; } }
public void UpdatePosition_Doituong(string MaDT, int MaAnpham, string cssLeft, string cssTop) { try { HPCDataProvider.Instance().ExecStore("Sp_UpdatePosition_DoiTuong", new string[] { "@Ma_Doituong", "@Ma_Anpham", "@CssLeft", "@CssTop" }, new object[] { MaDT, MaAnpham, cssLeft, cssTop }); } catch (Exception ex) { throw ex; } }
public DataSet GetListImageByTinbai(Int32 ID) { try { return(HPCDataProvider.Instance().GetStoreDataSet("Sp_GetListImageByTinbai", new string[] { "@Ma_TinBai" }, new object[] { ID })); } catch (Exception ex) { throw ex; } }
public T_Butdanh GetOneFrom_BDID(Double _ID) { try { return((T_Butdanh)HPCDataProvider.Instance().GetObjectByID(_ID.ToString(), "T_Butdanh", "BD_ID")); } catch (Exception ex) { throw ex; } }
public T_Anh GetOneFromT_AnhByID(Int32 ID) { try { return((T_Anh)HPCDataProvider.Instance().GetObjectByID(ID.ToString(), "T_Anh", "Ma_Anh")); } catch (Exception ex) { throw ex; } }
public void Copy_To_T_Album_Photo(int Cat_Album_ID, int Cat_Album_ID_New, int Lang_ID, DateTime DateModify, int UserModify) { try { HPCDataProvider.Instance().ExecStore("[CMS_Copy_T_Album_Photo]", new string[] { "@Cat_Album_ID", "@Cat_Album_ID_New", "@Lang_ID", "@DateModify", "@UserModify" }, new object[] { Cat_Album_ID, Cat_Album_ID_New, Lang_ID, DateModify, UserModify }); } catch (Exception ex) { throw ex; } }
public int InsertUpdateT_Anh(T_Anh _Obj) { try { return(HPCDataProvider.Instance().InsertObjectReturn(_Obj, "Sp_Insert_UpdateT_Anh")); } catch (Exception ex) { throw ex; } }
public void AutoInsertT_Layout_Sobao(int _masobao, int _maAnpham) { try { HPCDataProvider.Instance().ExecStore("[sp_AutoInsert_T_Layout_Sobao]", new string[] { "@Ma_SoBao", "@Ma_AnPham" }, new object[] { _masobao, _maAnpham }); } catch (Exception ex) { throw ex; } }