/// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="conn">数据库连接</param>
        /// <param name="configservice">基本配置信息</param>
        /// <param name="handlersevice">所有操作方法句柄</param>
        /// <param name="adminhandlers">管理员操作方法</param>
        public AdminLoginHandlers(Connection conn, ConfigService configservice,HandlerService handlersevice, AdminHandlers adminhandlers)
        {
            base.conn = conn;

            base.handlerService = handlersevice;
            this._adminh = adminhandlers;
            this.Initialization();
        }
Beispiel #2
0
        /// <summary>
        /// �����趨�������Ҳ�ѯ���������ҳ
        /// </summary>
        /// <param name="errText">������Ϣ</param>
        /// <param name="tableName">����</param>
        /// <param name="arrShowField">��Ҫ������ʾ���ֶμ�</param>
        /// <param name="strConditionField">��ѯ�����ֶμ�(Ϊ����in�IJ�ѯ����hashtable�ij�string)</param>
        /// <param name="arrSortField">�����ֶμ�</param>
        /// <param name="pageSize">ÿҳ��ʾ�ļ�¼����</param>
        /// <param name="page">Ҫ��ʾ��ҳ����</param>
        /// <param name="ads_out_Data">���صĽ�����ݼ�</param>
        /// <returns>�ɹ�����1 ʧ��С��0</returns>
        public static int GetPage(PageSearchItem sItem,Connection conn, ref int curPage, ref int pageCount, ref int counts, ref DataSet ads_out_Data)
        {
            //������Ҫ��ʾ���ֶμ���SQL��
            StringBuilder strShowField = new StringBuilder();
            for (int i = 0; i < sItem.arrShowField.Count; i++)
            {
                if (i == 0)
                {
                    strShowField.Append(sItem.arrShowField[i]);
                }
                else
                {
                    strShowField.Append(", " + sItem.arrShowField[i]);
                }
            }

            //��������SQL��
            StringBuilder strSortField = new StringBuilder();
            for (int i = 0; i < sItem.arrSortField.Count; i++)
            {
                if (i == 0)
                {
                    strSortField.Append(sItem.arrSortField[i]);
                }
                else
                {
                    strSortField.Append(", " + sItem.arrSortField[i]);
                }
            }

            SqlParameter sp0 = new SqlParameter("@tblName", SqlDbType.NVarChar, 50); sp0.Value = sItem.tableName;
            SqlParameter sp1 = new SqlParameter("@fldName", SqlDbType.NVarChar, 500); sp1.Value = strShowField.ToString();
            SqlParameter sp2 = new SqlParameter("@fldSort", SqlDbType.NVarChar, 200); sp2.Value = strSortField.ToString();
            SqlParameter sp3 = new SqlParameter("@strCondition", SqlDbType.NVarChar, 4000); sp3.Value = sItem.strCondition;
            SqlParameter sp4 = new SqlParameter("@pageSize", SqlDbType.Int, 4); sp4.Value = sItem.pageSize.ToString();
            SqlParameter sp5 = new SqlParameter("@page", SqlDbType.Int, 4); sp5.Value = sItem.page.ToString();

            SqlParameter sp6 = new SqlParameter("@curpage", SqlDbType.Int, 4); sp6.Direction = ParameterDirection.Output;
            SqlParameter sp7 = new SqlParameter("@pageCount", SqlDbType.Int, 4); sp7.Direction = ParameterDirection.Output;
            SqlParameter sp8 = new SqlParameter("@counts", SqlDbType.Int, 4); sp8.Direction = ParameterDirection.Output;
            SqlParameter sp9 = new SqlParameter("@retval", SqlDbType.Int, 4); sp9.Direction = ParameterDirection.Output;

            string[] reValues = conn.GetDataSet("SP_TCG_GetPage", new SqlParameter[] { sp0, sp1, sp2, sp3, sp4, sp5, sp6, sp7, sp8, sp9 }, new int[] { 6, 7, 8, 9 }, ref ads_out_Data);
            if(reValues!=null)
            {
                //�ܼ�¼��
                counts = (int)Convert.ChangeType(reValues[2], typeof(int));
                //��ҳ��
                pageCount = (int)Convert.ChangeType(reValues[1], typeof(int));
                //��ǰҳ��
                curPage = (int)Convert.ChangeType(reValues[0], typeof(int));

                return (int)Convert.ChangeType(reValues[3], typeof(int));
            }

            return -19000000;
        }
 public DataTable GetAllNewsSpecialityInfoByCache(Connection conn, bool readdb)
 {
     if (readdb)
     {
         return this.GetAllNewsSpecialityInfo(conn);
     }
     else
     {
         DataTable dt = (DataTable)CachingService.Get("AllNewsSpeciality");
         if (dt == null)
         {
             dt = this.GetAllNewsSpecialityInfo(conn);
             CachingService.Set("AllNewsSpeciality", dt, null);
         }
         return dt;
     }
 }
 /// <summary>
 /// ����ID�����Դ����
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="id"></param>
 /// <returns></returns>
 public Speciality GetNewsSpecialityInfoById(Connection conn, int id)
 {
     string SQL = "SELECT iId,iSiteId,iParent,vcTitle,vcExplain,dUpDateDate FROM Speciality (NOLOCK) WHERE iId=" + id.ToString();
     DataTable dt = conn.GetDataTable(SQL);
     if (dt == null) return null;
     if (dt.Rows.Count != 1) return null;
     Speciality item = new Speciality();
     DataRow Row = dt.Rows[0];
     item.iId = (int)Row["iId"];
     item.iSiteId = (int)Row["iSiteId"];
     item.iParent = (int)Row["iParent"];
     item.vcTitle = (string)Row["vcTitle"];
     item.vcExplain = (string)Row["vcExplain"];
     item.dUpDateDate = (DateTime)Row["dUpDateDate"];
     dt.Clear();
     dt.Dispose();
     dt = null;
     Row.Delete();
     return item;
 }
 /// <summary>
 /// ɾ������
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="adminname"></param>
 /// <param name="ids"></param>
 /// <returns></returns>
 public int NewSpecialityDel(Connection conn, string adminname, string ids)
 {
     SqlParameter sp0 = new SqlParameter("@vcAdminName", SqlDbType.VarChar, 50); sp0.Value = adminname;
     SqlParameter sp1 = new SqlParameter("@vcip", SqlDbType.VarChar, 15); sp1.Value = objectHandlers.UserIp;
     SqlParameter sp2 = new SqlParameter("@cAction", SqlDbType.Char, 2); sp2.Value = "03";
     SqlParameter sp3 = new SqlParameter("@IDs", SqlDbType.VarChar, 200); sp3.Value = ids;
     SqlParameter sp4 = new SqlParameter("@reValue", SqlDbType.Int); sp4.Direction = ParameterDirection.Output;
     string[] reValues = conn.Execute("SP_News_SpecialityAdmin", new SqlParameter[] { sp0, sp1, sp2, sp3, sp4 }, new int[] { 4 });
     if (reValues != null)
     {
         int rtn = (int)Convert.ChangeType(reValues[0], typeof(int));
         return rtn;
     }
     return -19000000;
 }
 /// <summary>
 /// ���������Դ����
 /// </summary>
 /// <param name="conn"></param>
 /// <returns></returns>
 public DataTable GetAllNewsSpecialityInfo(Connection conn)
 {
     string SQL = "SELECT iId,iSiteId,iParent,vcTitle,vcExplain,dUpDateDate FROM Speciality (NOLOCK)";
     return conn.GetDataTable(SQL);
 }
 /// <summary>
 /// �޸���Ѷ����
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="adminname"></param>
 /// <param name="nif"></param>
 /// <returns></returns>
 public int NewsSpecialityMdy(Connection conn, string adminname, Speciality nif)
 {
     SqlParameter sp0 = new SqlParameter("@vcAdminName", SqlDbType.VarChar, 50); sp0.Value = adminname;
     SqlParameter sp1 = new SqlParameter("@vcip", SqlDbType.VarChar, 15); sp1.Value = objectHandlers.UserIp;
     SqlParameter sp2 = new SqlParameter("@iSiteId", SqlDbType.Int, 4); sp2.Value = nif.iSiteId;
     SqlParameter sp3 = new SqlParameter("@iParent", SqlDbType.Int, 4); sp3.Value = nif.iParent;
     SqlParameter sp4 = new SqlParameter("@vcTitle", SqlDbType.VarChar, 50); sp4.Value = nif.vcTitle;
     SqlParameter sp5 = new SqlParameter("@vcExplain", SqlDbType.VarChar, 50); sp5.Value = nif.vcExplain;
     SqlParameter sp6 = new SqlParameter("@cAction", SqlDbType.Char, 2); sp6.Value = "02";
     SqlParameter sp7 = new SqlParameter("@iId", SqlDbType.Int, 4); sp7.Value = nif.iId;
     SqlParameter sp8 = new SqlParameter("@reValue", SqlDbType.Int); sp8.Direction = ParameterDirection.Output;
     string[] reValues = conn.Execute("SP_News_SpecialityAdmin", new SqlParameter[] { sp0, sp1, sp2, sp3, sp4, sp5, sp6,sp7,sp8 }, new int[] { 8 });
     if (reValues != null)
     {
         int rtn = (int)Convert.ChangeType(reValues[0], typeof(int));
         return rtn;
     }
     return -19000000;
 }