conlistctrl.ascx.cs

CRM管理系统 CRM管理系统

    #endregion

    #region 绑定分页
    /// <summary>
    /// 绑定分页
    /// </summary>
    private void BindPager()
    {
        pager.ShowCustomInfoSection = Wuqi.Webdiyer.ShowCustomInfoSection.Left;
        pager.ShowInputBox = Wuqi.Webdiyer.ShowInputBox.Always;
        pager.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
        pager.NumericButtonCount = 8;
        pager.AlwaysShow = true;
        pager.UrlPaging = false;
        pager.Wrap = false;
        pager.ShowPageIndex = false;
        pager.FirstPageText = "首页";
        pager.PrevPageText = "上一页";
        pager.NextPageText = "下一页";
        pager.LastPageText = "最后页";
        pager.SubmitButtonText = "跳转";
        pager.InputBoxStyle = "Height:14px;font-size:11px;";

        pager.CustomInfoHTML = "记录总数：<font color=\"blue\"><b>" + pager.RecordCount.ToString() + "</b></font>";
        pager.CustomInfoHTML += " 总页数：<font color=\"blue\"><b>" + pager.PageCount.ToString() + "</b></font>";
        pager.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + pager.CurrentPageIndex.ToString() + "</b></font>";
    }
    #endregion

    #region 查询条件
    /// <summary>
    /// 查询条件
    /// </summary>
    /// <returns></returns>
    private string GetSqlWhere()
    {

        System.Text.StringBuilder sbWhere = new System.Text.StringBuilder("1=1");
        if (txtConTitle.Text.Trim().Length > 0)
        {
            sbWhere.Append(" and title like ''%" + txtConTitle.Text.Trim().Replace("'", "\"") + "%''");
        }

        if (ddlConName.SelectedItem != null && ddlConName.SelectedIndex > 0)
        {
            sbWhere.Append(" and customer_id = " + ddlConName.SelectedValue + "");
        }

        if (ddlProid.SelectedItem != null && ddlProid.SelectedIndex > 0)
        {
            sbWhere.Append(" and period = " + ddlProid.SelectedValue + "");
        }

        if (ddlProject.SelectedItem != null && ddlProject.SelectedIndex > 0)
        {
            sbWhere.Append(" and project = ''" + ddlProject.SelectedValue + "''");
        }

        if (ddlUser.SelectedItem != null && ddlUser.SelectedIndex > 0)
        {
            sbWhere.Append(" and contract_person = " + ddlUser.SelectedValue + "");
        }
        else
        {
            sbWhere.Append(" and contract_person in (");
            for (int i = 1; i < ddlUser.Items.Count; i++)
            {
                if (i == ddlUser.Items.Count - 1)
                {
                    ListItem item = ddlUser.Items[i];
                    sbWhere.Append(item.Value);
                }
                else
                {
                    ListItem item = ddlUser.Items[i];
                    sbWhere.Append(item.Value + ",");
                }
            }
            sbWhere.Append(")");
        }

        if (txtBegin.Text.Trim().Length > 0 && IsDate(txtBegin.Text.Trim()))
        {
            sbWhere.Append(" and contract_time  >= ''" + txtBegin.Text.Trim() + "''");
        }

        if (txtEnd.Text.Trim().Length > 0 && IsDate(txtEnd.Text.Trim()))
        {
            sbWhere.Append(" and contract_time  < ''" + DateTime.Parse(txtEnd.Text.Trim()).AddDays(1).ToShortDateString() + "''");
        }

        return sbWhere.ToString();
    }
    #endregion

    #region 字典数据显示
    /// <summary>
    /// 字典数据显示
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    public string GetDictName(object obj)
    {
        if (obj == null)
            return null;

        string str = obj.ToString();
        Itsv.Model.dictionary dict = this.GetDictionaryMonel(obj.ToString());
        if (dict == null)
        {
            return obj.ToString();
        }
        return dict.dict_name;
    }

    /// <summary>
    /// 读取我方人员
    /// </summary>
    /// <returns></returns>
    public string GetUserName(object obj)
    {
        if (obj == null || !IsNuberic(obj.ToString()))
            return null;

        long userid = Convert.ToInt64(obj.ToString());
        string sql = "SELECT name FROM Users where user_id = " + userid;
        return dataport.GetRowResultID(sql);
    }

    /// <summary>
    /// 读取客户人员
    /// </summary>
    /// <returns></returns>
    public string GetCustomName(object obj)
    {
        if (obj == null || !IsNuberic(obj.ToString()))
            return null;

        long userid = Convert.ToInt64(obj.ToString());
        string sql = "SELECT name FROM ITSV_CustomerManager where code = " + userid;
        return dataport.GetRowResultID(sql);
    }

    /// <summary>
    /// 读取客户人员名称
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    public string GetCustomerPerson(object obj)
    {
        if (obj == null || !IsNuberic(obj.ToString()))
            return null;

        long CustomerPersonId = Convert.ToInt64(obj.ToString());
        string sql = "SELECT first_name FROM ITSV_customer_person where code = " + CustomerPersonId;
        return dataport.GetRowResultID(sql);
    }

    #endregion

    protected void btnAddContact_Click(object sender, EventArgs e)
    {
        Response.Redirect("ConAdd.aspx");
    }

    protected void gvConList_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvConList.PageIndex = e.NewPageIndex;
        SetPagerAndGvConList();
    }
 
    protected void pager_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        pager.CurrentPageIndex = e.NewPageIndex;
        gvConList.PageIndex = e.NewPageIndex - 1;
        SetPagerAndGvConList();
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        SetPagerAndGvConList();
    }
    protected void gvConList_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            //当鼠标停留时更改背景色
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#ededFF'");
            //当鼠标移开时还原背景色
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");

            int code = 0;
            LinkButton lbtnSale = (LinkButton)e.Row.FindControl("lbtnSale");
            LinkButton lbtnDelete = (LinkButton)e.Row.FindControl("lbtnDelete");
            LinkButton lbtnTitle = (LinkButton)e.Row.FindControl("lbtnTitle");

            try
            {
                code = Convert.ToInt32(gvConList.DataKeys[e.Row.RowIndex].Value.ToString());
            }
            catch
            {
                lbtnSale.Visible = false;
                lbtnDelete.Visible = false;
                return;
            }
            Label lblConDateTime = (Label)e.Row.FindControl("lblConDateTime");
            if (lblConDateTime != null && IsDate(lblConDateTime.Text))
            {
                lblConDateTime.Text = DateTime.Parse(lblConDateTime.Text).ToShortDateString();
            }

            if (lbtnSale != null)
            {
                lbtnSale.CommandArgument = e.Row.RowIndex.ToString();
                this.ShowModalWindow(lbtnSale, "onclick", "SaleAdd.aspx?conId=" + code, 750, 600);

                int count = GetSaleCount(code);
                if (count > 0)
                {
                    lbtnSale.Text = "编辑预测";
                    lbtnSale.ForeColor = System.Drawing.Color.Blue;
                }
                else
                {
                    lbtnSale.Text = "添加预测";
                    lbtnSale.ForeColor = System.Drawing.Color.Red;
                }
            }
            lbtnDelete.CommandArgument = e.Row.RowIndex.ToString();
            lbtnDelete.Attributes.Add("onclick", "javascript:return confirm('当你删除此条信息后相应的销售预测信息也将删除，您确实要删除此条联络信息吗？');");

            if (lbtnTitle != null)
            {
                lbtnTitle.Attributes.Add("onclick", "window.open('ConShow.aspx?isedit=" + isEdit + "&code=" + code + "','_blank', 'width=750, height=600');");
            }
        }
    }
    protected void gvConList_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        String title = null;
        if (e.CommandName == "lbtnDelete")
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument.ToString());
            int code = Convert.ToInt32(gvConList.DataKeys[rowIndex].Value.ToString());
            title = ((LinkButton)gvConList.Rows[rowIndex].FindControl("lbtnTitle")).Text;
            string sql = "DELETE FROM ITSV_sale where contract_id = " + code + ";";
            sql += "DELETE FROM ITSV_CustomerContract where code = " + code;
            
            if (!dataport.ExeSql(sql))
            {
                ShowMessage("对不起，数据删除失败，请您重试!!");
                return;
            }
            else
            {
                if (title != "")
                {
                    this.WriteUserAction("删除联络\"" + title + "\"的信息");
                }
            }
            SetPagerAndGvConList();
        }
    }
    protected void btnClear_Click(object sender, EventArgs e)
    {
        txtConTitle.Text = "";
        ddlConName.SelectedIndex = 0;
        ddlDatetime.SelectedIndex = 2;
        ddlProid.SelectedIndex = 0;
        ddlProject.SelectedIndex = 0;
        ddlUser.SelectedIndex = 0;
        txtBegin.Text = "";
        txtEnd.Text = "";
        SetPagerAndGvConList();
    }
}