conlistctrl.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 Contact_Ctrls_ConListCtrl : PageBaseUserCtrl
{
    public WYX.Dataport.Dataport dataport = new WYX.Dataport.Dataport();
    public string tblName = "ITSV_CustomerContract";//表名
    public string fldName = "code";//主键字段名
    public int IsReCount = 0;//是否
    public int OrderType = 1;//排序  0升，非0降
    public string strWhere = "";//条件
    private int PageSize = 15;

    public bool IsEdit
    {
        get { return _IsEdit; }
        set 
        {
            isEdit = value ? "true" : "";
            btnAddContact.Visible = value;
            gvConList.Columns[8].Visible = value;
            gvConList.Columns[9].Visible = value;
            _IsEdit = value;
        }
    }
    private bool _IsEdit;
    private string isEdit;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (CurrentUser == null)
            return;

        ddlDatetime.Attributes.Add("onchange", "SetSearchTime();");

        if (!IsPostBack)
        {
            SetData();
        }
    }

    #region 初始化页面
    /// <summary>
    /// 初始化页面
    /// </summary>
    private void SetData()
    {
        BindProid();
        BindProject();
        BindCustomer();
        BindPerson();

        SetPagerAndGvConList();
    }

    /// <summary>
    /// 设置Pager 和 GridView
    /// </summary>
    private void SetPagerAndGvConList()
    {
        strWhere = GetSqlWhere();
        this.gvConList.PageSize = PageSize;
        this.pager.PageSize = PageSize;
        this.pager.RecordCount = this.GetRecordCount(strWhere);
        BindPager();
        BindGvConList();
    }
    #endregion

    #region 邦定字典项
    /// <summary>
    /// 邦定联络阶段
    /// </summary>
    private void BindProid()
    {
        this.BindDictionary(ddlProid, "102");
        ddlProid.Items.Insert(0, "--联络阶段--");
    }

    /// <summary>
    /// 邦定项目
    /// </summary>
    private void BindProject()
    {
        //this.BindDictionary(ddlProject, "103");
        string sql = "SELECT * FROM dictionary where parent_id = 103 order by dict_name";
        DataTable dt = null;
        try
        {
            dt = dataport.GetTableResult(sql);
        }
        catch
        {
            dt = null;
        }
        if (dt == null || dt.Rows.Count == 0)
        {
            this.ddlProject.Items.Insert(0, new ListItem("--相关项目--"));
            return;
        }

        this.ddlProject.DataSource = dt;
        this.ddlProject.DataTextField = "dict_name";
        this.ddlProject.DataValueField = "dict_code";
        this.ddlProject.DataBind();
        ddlProject.Items.Insert(0, "--相关项目--");
    }

    /// <summary>
    /// 邦定客户
    /// </summary>
    private void BindCustomer()
    {
        string sql = "SELECT code, name FROM ITSV_CustomerManager where is_delete = 0 order by name";
        DataTable dt = null;
        try
        {
            dt = dataport.GetTableResult(sql);
        }
        catch
        {
            dt = null;
        }
        if (dt == null || dt.Rows.Count == 0)
        {
            this.ddlConName.Items.Insert(0, new ListItem("--客户名称--"));
            return;
        }

        this.ddlConName.DataSource = dt;
        this.ddlConName.DataTextField = "name";
        this.ddlConName.DataValueField = "code";
        this.ddlConName.DataBind();
        this.ddlConName.Items.Insert(0, new ListItem("--客户名称--"));
    }

    /// <summary>
    /// 邦定我方人员
    /// </summary>
    private void BindPerson()
    {
        string sql = "SELECT account, user_id, name FROM Users WHERE (inuse = 1) and account = '" + CurrentUser.account + "'";
        if (this.GetSystemRole(CurrentUser.account) || !_IsEdit)
        {
            sql = "SELECT account, user_id, name FROM Users WHERE (inuse = 1)";
        }

        DataTable dt = null;
        try
        {
            dt = dataport.GetTableResult(sql);
        }
        catch
        {
            dt = null;
        }
        if (dt == null || dt.Rows.Count == 0)
        {
            this.ddlUser.Items.Insert(0, new ListItem("--我方人员--"));
            return;
        }

        this.ddlUser.DataSource = dt;
        this.ddlUser.DataTextField = "name";
        this.ddlUser.DataValueField = "user_id";
        this.ddlUser.DataBind();
        this.ddlUser.Items.Insert(0, new ListItem("--我方人员--"));
    }
    #endregion

    #region 读取数据
    /// <summary>
    /// 功    能：分页
    /// </summary>
    /// <param name="tblName">表名</param>
    /// <param name="fldName">主键字段名</param>
    /// <param name="PageSize">页尺寸</param>
    /// <param name="PageIndex">页码</param>
    /// <param name="IsReCount">返回记录总数, 非 0 值则返回</param>
    /// <param name="OrderType">设置排序类型, 非 0 值则降序</param>
    /// <param name="strWhere">查询条件 (注意: 不要加 where)</param>
    /// <returns>ds</returns>
    public DataSet Minutepage(string tblName, string fldName, int PageSize, int PageIndex, int IsReCount, int OrderType, string sqlWhere)
    {
        string sql = "exec UP_GetRecordByPage '" + tblName + "','" + fldName + "'," + PageSize + "," + PageIndex + "," + IsReCount + "," + OrderType + ",'" + sqlWhere + "' ";
        DataSet ds = dataport.GetDataSet(sql);
        return ds;
    }

    /// <summary>
    /// 返回dataSet
    /// </summary>
    /// <returns></returns>
    public DataSet GetDataSetByPage(string sqlWhere)
    {
        DataSet ds = Minutepage(tblName, fldName, PageSize, pager.CurrentPageIndex, IsReCount, OrderType, sqlWhere);
        return ds;
    }

    /// <summary>
    /// 读取纪录总数
    /// </summary>
    /// <param name="strWhere"></param>
    /// <returns></returns>
    private int GetRecordCount(string sqlWhere)
    {
        string sql = "select count(*) from ITSV_CustomerContract where " + sqlWhere.Replace("''","'");
        string record = dataport.GetRowResultID(sql);
        if (record == null || !IsInt(record))
        {
            return 0;
        }

        return int.Parse(record);
    }

    /// <summary>
    /// 读取是否已经进行销售预测
    /// </summary>
    /// <param name="conId"></param>
    /// <returns></returns>
    private int GetSaleCount(int conId)
    {
        String sql = "select count(*) from itsv_sale where contract_id = " + conId;
        string count = dataport.GetRowResultID(sql);
        if (count != null && IsInt(count))
            return int.Parse(count);
        else
            return 0;
    }
    #endregion

    #region 邦定GridView
    /// <summary>
    /// 邦定GridView
    /// </summary>
    private void BindGvConList()
    {
        DataSet ds = GetDataSetByPage(strWhere);
        if (ds == null)
        {
            return;
        }

        DataTable dt = ds.Tables[0];
        if (dt.Rows.Count == 0)
        {
            dt = GvAddEmptyRow(ds);
            gvConList.DataSource = dt;
            gvConList.DataBind();
            return;
        }

        gvConList.DataSource = dt;
        gvConList.DataKeyNames = new string[1] { "code" };
        gvConList.DataBind();
    }

    /// <summary>
    /// 增加一个空行来显示表头
    /// </summary>
    /// <param name="ds"></param>
    /// <returns></returns>
    private DataTable GvAddEmptyRow(DataSet ds)
    {
        DataTable dt = ds.Tables[0];
        DataRow newRow = dt.NewRow();
        dt.Rows.Add(newRow);
        return dt;
    }