public DataSet GetNewsDetail(int newsId) { if (1 > newsId) { return(new DataSet()); } string procedureName = "News_Browse"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@News_ID", SqlDbType.Int, -1, newsId) }; return(base.GetDataSet(procedureName, parameters)); }
public int DeleteNews(int newsId) { if (1 > newsId) { return(0); } string procedureName = "News_Delete"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@News_ID", SqlDbType.Int, -1, newsId) }; return(Convert.ToInt32(base.ExecStoredProcedure(procedureName, parameters))); }
public string GetInformationName(int informationId) { if (1 > informationId) { return(string.Empty); } string sql = "SELECT name FROM category WHERE id = @InformationId"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@InformationId", SqlDbType.Int, -1, informationId) }; return(base.GetSingleDataInColumn(sql, parameters, "name")); }
public DataSet GetInformation(int categoryId) { if (1 > categoryId) { return(new DataSet()); } string sql = "SELECT * FROM View_Information_List WHERE category_id = @CategoryId"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@CategoryId", SqlDbType.Int, -1, categoryId) }; return(base.GetDataSet(sql, parameters)); }
public int GetNewsPageCountOutline(int outlineId, int pageSize) { if (1 > outlineId || 1 > pageSize) { return(0); } string procedureName = "News_Calculate_Page_Outline"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@Outline_Type", SqlDbType.Int, -1, outlineId), BasicDAO.MakeInParameter("@Page_Size", SqlDbType.Int, -1, pageSize) }; return(Convert.ToInt32(base.ExecStoredProcedure(procedureName, parameters))); }
public string IsSupervisor(string alias, string cipher) { if (null == alias || null == cipher || alias.Equals(string.Empty) || cipher.Equals(string.Empty) || 20 < alias.Length || 20 < cipher.Length) { return(string.Empty); } string sql = "SELECT id FROM supervisor WHERE alias = @inAlias and cipher = @inCipher"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@inAlias", SqlDbType.NVarChar, alias.Length, alias), BasicDAO.MakeInParameter("@inCipher", SqlDbType.NVarChar, cipher.Length, cipher) }; return(base.GetSingleDataInColumn(sql, parameters, "id")); }
public int UpdateInformation(int informationId, string inArticle) { if (1 > informationId) { return(0); } string article = (null == inArticle) ? string.Empty : inArticle; string procedureName = "Information_Modify"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@Category_Id", SqlDbType.Int, -1, informationId), BasicDAO.MakeInParameter("@Article", SqlDbType.NVarChar, article.Length, article) }; return(Convert.ToInt32(base.ExecStoredProcedure(procedureName, parameters))); }
public int EditNews(int newsID, int categoryID, string title, string article) { if (1 > categoryID || null == title || null == article || title.Equals(string.Empty) || article.Equals(string.Empty)) { return(0); } string sql = "News_Edit"; SqlParameter[] parameter = { BasicDAO.MakeInParameter("@News_ID", SqlDbType.Int, -1, newsID), BasicDAO.MakeInParameter("@Category_ID", SqlDbType.Int, -1, categoryID), BasicDAO.MakeInParameter("@Title", SqlDbType.NChar, title.Length, title), BasicDAO.MakeInParameter("@Article", SqlDbType.NVarChar, article.Length, article) }; return(Convert.ToInt32(ExecStoredProcedure(sql, parameter).ToString())); }
public int PublishNews(int categoryId, int supervisorId, string title, string article) { if (1 > categoryId || 1 > supervisorId || null == title || null == article || title.Equals(string.Empty) || article.Equals(string.Empty)) { return(0); } string procedureName = "News_Publish"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@Category_ID", SqlDbType.Int, -1, categoryId), BasicDAO.MakeInParameter("@Supervisor_ID", SqlDbType.Int, -1, supervisorId), BasicDAO.MakeInParameter("@Title", SqlDbType.NVarChar, -1, title), BasicDAO.MakeInParameter("@Article", SqlDbType.NVarChar, -1, article) }; return(Convert.ToInt32(base.ExecStoredProcedure(procedureName, parameters))); }
public DataSet GetSingleOutlineNewsListWithPageNumber(int outlineId, int pageSize, int pageRequest) { if (1 > outlineId || 1 > pageSize || 1 > pageRequest) { return(new DataSet()); } string procedureName = "News_Get_List_Outline"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@Outline_Type", SqlDbType.Int, -1, outlineId), BasicDAO.MakeInParameter("@Page_Size", SqlDbType.Int, -1, pageSize), BasicDAO.MakeInParameter("@Page_Request", SqlDbType.Int, -1, pageRequest) }; DataSet result = base.ExecStoredProcedureGetDataSet(procedureName, parameters) as DataSet; return((null == result) ? new DataSet() : result); }
public DataSet GetAllCategory() { string sql = "SELECT * FROM outline"; DataTable outlines = base.GetDataTable(sql, null); DataSet dataSet = new DataSet(); foreach (DataRow dr in outlines.Rows) { sql = "SELECT * FROM category WHERE outline_id = @outlineId"; SqlParameter[] parameters = { BasicDAO.MakeInParameter("@outlineId", SqlDbType.Int, -1, Convert.ToInt32(dr["id"])) }; DataTable categoryTable = base.GetDataTable(sql, parameters); categoryTable.TableName = dr["id"].ToString(); dataSet.Tables.Add(categoryTable); } return(dataSet); }