customermanage.ascx.cs

CRM管理系统 CRM管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class CustomerManage_Ctrls_CustomerManage :PageBaseUserCtrl
{
    public WYX.Dataport.Dataport dataport = new WYX.Dataport.Dataport();
    public string tblName = "ITSV_CustomerManager";//表名
    public string fldName = "code";//主键字段名
    public int IsReCount = 0;//是否
    public int OrderType = 1;//排序  0升，非0降
    public string strWhere = "";//条件
    private int PageSize = 15;

    public bool IsShow
    {
        get { return _isShow; }
        set
        {
            GridView1.Columns[7].Visible = value;
            btnAdd.Visible = value;
            _isShow = value;
        }
    }
    private bool _isShow;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (CurrentUser == null)
        {
            return;
        }
        if (!Page.IsPostBack)
        {
            GetTrack();
            GetComType();
            GetRelation();
            SetData();
        }
    }

    /// <summary>
    /// 读取名称
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    protected string GetName(object obj)
    {
        if (obj == null || obj.ToString() == "")
        {
            return "";
        }
        else
        {
            string sql = " select dict_name from dictionary where dict_code = " + Convert.ToInt32(obj.ToString()) + "";
            try
            {
                return dataport.GetRowResultID(sql);
            }
            catch
            {
                return "";
            }
        }
    }
    /// <summary>
    /// 读取名称
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    protected string GetUserName(object obj)
    {
        if (obj == null || obj.ToString() == "")
        {
            return "";
        }
        else
        {
            string sql = " select name from Users where user_id = " + Convert.ToInt32(obj.ToString()) + "";
            try
            {
                return dataport.GetRowResultID(sql);
            }
            catch
            {
                return "";
            }
        }
    }
    /// <summary>
    /// 读取名称
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    protected string GetUser(string UserId)
    {
        if (UserId == null || UserId == "")
        {
            return "";
        }
        else
        {
            string sql = " select name from Users where user_id = " + Convert.ToInt32(UserId) + "";
            try
            {
                return dataport.GetRowResultID(sql);
            }
            catch
            {
                return "";
            }
        }
    }
    #region  绑定数据
    /// <summary>
    /// 绑定客户类型
    /// </summary>
    private void GetTrack()
    {
        string sql = null;
        if (GetSystemRole(this.CurrentUser.account) || !_isShow)
        {
            sql = " SELECT user_id,account,name FROM Users";
        }
        else
        {
            sql = " SELECT user_id,account,name FROM Users where account = '" + this.CurrentUser.account + "'";
        }
        DataTable dt = null;
        try
        {
            dt = dataport.GetTableResult(sql);
        }
        catch
        {
            dt = null;
        }
        if (dt == null || dt.Rows.Count == 0)
        {
            ddlTrack.DataSource = dt;
            ddlTrack.DataBind();
            ddlTrack.Items.Add("请选择...");
            return;
        }
        ddlTrack.DataSource = dt;
        ddlTrack.DataTextField = "name";
        ddlTrack.DataValueField = "user_id";
        ddlTrack.DataBind();
        ddlTrack.Items.Insert(0, new ListItem("请选择...", "0"));
    }
    /// <summary>
    /// 绑定客户类型
    /// </summary>
    private void GetComType()
    {
        this.BindDictionary(this.ddlComType, "105", true);
    }
    /// <summary>
    /// 绑定关系程度
    /// </summary>
    private void GetRelation()
    {
        this.BindDictionary(this.ddlRelation, "104", true);
    }  
    #endregion
    /// <summary>
    /// 获取用户ID
    /// </summary>
    /// <param name="Code"></param>
    /// <returns></returns>
    protected string GetUserID(string UserCode)
    {
        if (UserCode.Trim().Replace("'", "\"").Length > 0)
        {
            string sql = " select user_id from users where account = '" + UserCode + "'";
            try
            {
                return dataport.GetRowResultID(sql);
            }
            catch
            {
                return "0";
            }
        }
        else
        {
            return "0";
        }
    }
    /// <summary>
    /// 初始化数据
    /// </summary>
    protected void SetData()
    {
        strWhere = condition();
        BindGridView();
    }
    /// <summary>
    /// 绑定GridView数据
    /// </summary>
    private void BindGridView()
    {
        GridView1.PageSize = this.PageSize;
        pager.PageSize = this.PageSize;

        DataSet ds = GetDataSetByPage(strWhere);

        int rowCount = GetRecordCount(strWhere);
        pager.RecordCount = rowCount;
        BindPager();

        if (rowCount > 0)
        {
            try
            {
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataKeyNames = new string[] { "code"};
                GridView1.DataBind();
            }
            catch (Exception)
            {
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataBind();
            }
        }
        else
        {
            DataTable dt = AddEmputyData(ds);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }
    /// <summary>
    /// 增加一个空行来显示表头
    /// </summary>
    /// <param name="ds"></param>
    /// <returns></returns>
    private DataTable AddEmputyData(DataSet ds)
    {
        DataTable dt = ds.Tables[0];
        DataRow newRow = dt.NewRow();
        dt.Rows.Add(newRow);
        return dt;
    }
    /// <summary>
    /// 返回dataSet
    /// </summary>
    /// <param name="sqlWhere"></param>
    /// <returns></returns>
    public DataSet GetDataSetByPage(string sqlWhere)
    {
        DataSet ds = Minutepage(tblName, fldName, pager.PageSize, pager.CurrentPageIndex, IsReCount, OrderType, sqlWhere);
        return ds;
    }
    /// <summary>
    /// 读取纪录数
    /// </summary>
    /// <returns></returns>
    private int GetRecordCount(string sqlWhere)
    {
        string sql = "SELECT count(*) FROM ITSV_CustomerManager where " + sqlWhere.Replace("''", "'");
        try
        {
            string reCount = dataport.GetRowResultID(sql);
            if (reCount == null || !IsInt(reCount))
            {
                return 0;
            }

            return int.Parse(reCount);
        }
        catch
        {
            return 0;
        }
    }
    /// <summary>
    /// 参数的设置
    /// </summary>
    private string condition()
    {
        string sqlWhere = null;
        if (GetSystemRole(this.CurrentUser.account) || !_isShow)
        {
            sqlWhere = " 1=1 and is_delete = 0 and is_use = 0";
        }
        else
        {
            sqlWhere = " 1=1 and is_delete = 0 and is_use = 0 and tracking_persen = ''" + this.CurrentUser.user_id + "''";
        }
        System.Text.StringBuilder sbWhere = new System.Text.StringBuilder(sqlWhere);

        if (this.ddlComType.SelectedItem != null && ddlComType.SelectedIndex > 0)
        {
            sbWhere.Append(" and type = ''");
            sbWhere.Append(ddlComType.SelectedValue);
            sbWhere.Append("''");
        }

        if (this.ddlRelation.SelectedItem != null && ddlRelation.SelectedIndex > 0)
        {
            sbWhere.Append(" and relation = ''");
            sbWhere.Append(ddlRelation.SelectedValue);
            sbWhere.Append("''");
        }

        if (this.txtComName.Text.Trim().Length > 0)
        {
            sbWhere.Append(" and name like ''%");
            sbWhere.Append(txtComName.Text.Trim().Replace("'", "\""));
            sbWhere.Append("%''");
        }

        if (this.ddlTrack.SelectedItem != null && ddlTrack.SelectedIndex > 0)
        {
            sbWhere.Append(" and tracking_persen = ''");
            sbWhere.Append(ddlTrack.SelectedValue);
            sbWhere.Append("''");