918博天堂

?#pragma checksum "D:\wwwroot\kefucrm\wwwroot\Manager_Product.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "CF8DA705D6C98456D3EF31531618C28EBD5F2719"

#line 1 "D:\wwwroot\kefucrm\wwwroot\Manager_Product.aspx.cs"
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Text;


public partial class Manager_Product : System.Web.UI.Page
{
    public int i_userid = 0;
    public int currentPage = 1, pageSize = 12, allNum = 0;
    public StringBuilder sb = new StringBuilder();
    public string strTitle = "";
    public string rank = string.Empty;
    private Staff doStaff = null;
    List<Staff> listStaff = null;
    int i = 0;
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!String.IsNullOrEmpty(Request.QueryString["page"]))
        {
            currentPage = Convert.ToInt32(Request.QueryString["page"]);
        }
        if (Request.Cookies["sunid"] != null)
        {
            string strUserID = Request.Cookies["sunid"].Value.ToString();

            string _userid = Microsoft.JScript.GlobalObject.unescape(strUserID);
            _userid = Microsoft.JScript.GlobalObject.unescape(_userid);

            string decry_userid = Sun_Encrypt.AESDecrypt(_userid);
            if (SunFunction.IsNumber(decry_userid))
            {
                i_userid = Convert.ToInt32(decry_userid);
                try
                {
                    doStaff = new Staff(i_userid);
                    List<Product> list = Product.GetProductList(doStaff.companyid);
                    Repeater1.DataSource = list;
                    Repeater1.DataBind();
                }
                catch (Exception ex)
                {
                    Sun_KY.SqlAccess.h(ex.Message);
                }

            }
            else
            {
                Response.Write("解密不为数字");
            }

            //  BindResume(_id, userid);
        }
        else
        {
            Response.Write("获取用户信息失败，请沉新登陆");
        }
    }

    public string GetOrder()
    {
        return (++i).ToString();
    }

    public string GetProductType(int type)
    {
        string rt = string.Empty;
        if (type.Equals(1))
        {
            rt = "周期产品";
        }
        else
        {
            rt = "一次性产品";
        }
        return rt;
    }

    public string DelCustomerButton(int customerid)
    {
        string rt = string.Empty;
        if (doStaff.manager == 1)
        {
            rt = "<a href='javascript:void(0)' onclick='del_customer(" + customerid.ToString() + ")'>删除客户</a>";
        }
        return rt;
    }

    public string GetUserName(int userid)
    {
        string rt = string.Empty;
        for (int i = 0; i < listStaff.Count; i++)
        {
            if (listStaff[i].userid == userid)
            {
                rt = listStaff[i].username;
                break;
            }
        }
        return rt;
    }
    private void BindData(string rank, int userid, int currentpage, int pagesize)
    {
        SqlDataReader dr = null;
        try
        {
            using (SqlConnection conn = new SqlConnection(Sun_KY.SqlAccess.ConnectionString))
            {
                string sql = "sjm_GetABCCustomer";
                SqlParameter[] sp = new SqlParameter[5];
                sp[0] = new SqlParameter("@rank", SqlDbType.NVarChar, 10);
                sp[0].Value = rank;
                sp[1] = new SqlParameter("@userid", SqlDbType.Int);
                sp[1].Value = userid;
                sp[2] = new SqlParameter("@currentpage", SqlDbType.Int);
                sp[2].Value = currentpage;
                sp[3] = new SqlParameter("@pagesize", SqlDbType.Int);
                sp[3].Value = pagesize;
                sp[4] = new SqlParameter("@allnum", SqlDbType.Int);
                sp[4].Direction = ParameterDirection.Output;
                SqlCommand cmd = new SqlCommand();
                if (conn.State != ConnectionState.Open)
                    conn.Open();
                cmd.Connection = conn;
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(sp[0]);
                cmd.Parameters.Add(sp[1]);
                cmd.Parameters.Add(sp[2]);
                cmd.Parameters.Add(sp[3]);
                cmd.Parameters.Add(sp[4]);

                dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    Repeater1.DataSource = dr;
                    Repeater1.DataBind();
                }
                dr.Close();
                if (cmd.Parameters["@allnum"].Value != DBNull.Value)
                {
                    allNum = Convert.ToInt32(cmd.Parameters["@allnum"].Value);
                    BindNav(currentpage, pagesize, allNum);

                }
                cmd.Parameters.Clear();
                cmd.Dispose();

            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    private void BindNav(int currentpage, int pagesize, int allnum)
    {
        int i = 0;
        int allpage = 0;
        if (allnum % pagesize == 0)
        {
            allpage = allnum / pagesize;

        }
        else
        {
            allpage = allnum / pagesize + 1;
        }
        if (currentpage > 1)
        {
            sb.Append("<li><a href='Manager_Customer.aspx?class=" + rank + "&page=1'>首页</a></li>");
        }
        string activeCss = "";
        for (i = currentpage - 5; i <= currentpage; i++)
        {
            if (i > 0)
            {
                if (i == currentpage)
                {
                    activeCss = " class='active'";
                }
                sb.Append("<li" + activeCss + "><a href='Manager_Customer.aspx?class=" + rank + "&page=" + i + "'>" + i + "</a></li>"); ;
            }
        }
        for (i = currentpage + 1; i <= currentpage + 5; i++)
        {
            if (i < allpage)
            {
                sb.Append("<li><a href='Manager_Customer.aspx?class=" + rank + "&page=" + i + "'>" + i + "</a></li>");
            }
        }
        if (currentpage < allpage)
        {
            sb.Append("<li><a href='Manager_Customer.aspx?class=" + rank + "&page=" + allpage + "'>尾页</a></li>"); ;
        }
        sb.Append("<li><a href='javascript:void(0);'>共" + allnum + "笔纪录</a></li>");
    }

    public string GetBirthday(object yangli, object nongli)
    {
        string rt = string.Empty;
        if (yangli != DBNull.Value)
        {
            rt = Convert.ToDateTime(yangli).ToString("yyyy-MM-dd") + " [阳]<br>";
        }
        if (nongli != DBNull.Value)
        {
            rt += Convert.ToDateTime(nongli).ToString("yyyy-MM-dd") + " [农]";
        }
        return rt;
    }


}

#line default
#line hidden