saleexportbyprojectctrl.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_SaleExportByProjectCtrl : PageBaseUserCtrl
{
    WYX.Dataport.Dataport dp = new WYX.Dataport.Dataport();
    int projectId = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
        btnCancel.Attributes.Add("onclick", "window.close();");
        Response.CacheControl = "no-cache";
        Response.AddHeader("Pragma", "no-cache");
        Response.Expires = 0;

        if (Request.QueryString["project"] != null && IsNuberic(Request.QueryString["project"]))
        {
            projectId = Convert.ToInt32(Request.QueryString["project"]);
        }
        else
        {
            ShowAndClose("您输入的参数不正确，请您重试!!", "");
            return;
        }
        if (!Page.IsPostBack)
        {
            SetData();
        }
    }

    #region 数据初始化
    /// <summary>
    /// 数据初始化
    /// </summary>
    private void SetData()
    {
        BindDataList();
    }
    #endregion

    #region 邦定DataList
    /// <summary>
    /// 邦定DataList
    /// </summary>
    private void BindDataList()
    {
        string sql = @"SELECT 
                    s.contract_id,s.win,s.win_data,s.content,s.total_sale_money,s.other_sale_money,s.date_time_1,s.date_time_2,s.date_time_3,
                    c.name as customer,
                    con.customer_person_id,con.title,con.period,con.project,con.contract_person,con.contract_time,
                    users.name as userName
                    FROM ITSV_sale s
                    left join dbo.ITSV_CustomerContract con on s.contract_id = con.code
                    left join ITSV_CustomerManager c on con.customer_id = c.code
                    left join users on con.contract_person = users.user_id
                    WHERE (con.project = " + projectId + " )";
        sql += " order by s.date_time desc";

        DataTable dt = null;
        try { dt = dp.GetTableResult(sql); }
        catch { dt = null; }

        if (dt == null || dt.Rows.Count == 0)
        {
            return;
        }

        dtlDetail.DataSource = dt;
        dtlDetail.DataBind();

        this.lblPreject.Text = GetDictName(dt.Rows[0]["project"]);
        this.lblCustomId.Text = dt.Rows[0]["customer"].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>
    /// <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 dp.GetRowResultID(sql);
    }
    #endregion
}