customerlook.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_CustomerLook : PageBaseUserCtrl
{
    public WYX.Dataport.Dataport dataport = new WYX.Dataport.Dataport();
    private int ComId;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ComId = Convert.ToInt32(Request.QueryString["code"]);
            SetData();
            BindDtlPerson();
        }
    }
    /// <summary>
    /// 根据编号获取名称
    /// </summary>
    /// <returns></returns>
    protected string GetName(string Code)
    {
        if (Code.Trim().Replace("'","\"").Length > 0)
        {
            string sql = " select dict_name from dictionary where dict_code = " + Convert.ToInt32(Code) + "";
            try
            {
                return dataport.GetRowResultID(sql);
            }
            catch
            {
                return null;
            }
        }
        else
        {
            return null;
        }
    }
    /// <summary>
    /// 读取有效性
    /// </summary>
    /// <param name="obj"></param>
    /// <returns></returns>
    private string GetIsUse()
    {
        String IsUse;
        string sql = " select is_use from ITSV_CustomerManager where code = " + ComId + "";
        try
        {
            IsUse = dataport.GetRowResultID(sql);
        }
        catch
        {
            IsUse = "";
        }

        if (IsInt(IsUse.ToString()))
        {
            switch (int.Parse(IsUse.ToString()))
            {
                case 0:
                    return "有效";
                case 1:
                    return "无效";
                case 2:
                    return "请选择...";
            }
        }
        return IsUse.ToString();
    }
    /// <summary>
    /// 获取用户ID
    /// </summary>
    /// <param name="Code"></param>
    /// <returns></returns>
    protected string GetUserName(string UserCode)
    {
        if (UserCode.Trim().Replace("'", "\"").Length > 0)
        {
            string sql = " select name from users where user_id = " + Convert.ToInt32(UserCode) + "";
            try
            {
                return dataport.GetRowResultID(sql);
            }
            catch
            {
                return "";
            }
        }
        else
        {
            return "";
        }
    }
    /// <summary>
    /// 初始化数据
    /// </summary>
    protected void SetData()
    {
        string sql = " select * from ITSV_CustomerManager where code = " + ComId + "";
        DataRow dr = null;
        try
        {
            dr = dataport.GetRowResult(sql);
        }
        catch
        {
            dr = null;
        }
        if (dr == null)
        {
            ShowAndClose("客户编号错误，请您重试!!", "");
            return;
        }
        this.txtComId.Text = dr["code"].ToString();
        this.txtComName.Text = dr["name"].ToString();
        this.txtRelation.Text = GetName(dr["relation"].ToString());
        this.txtComType.Text = GetName(dr["type"].ToString());
        this.txtWay.Text = GetName(dr["industry"].ToString());
        this.txtResource.Text = GetName(dr["source"].ToString());
        this.txtNation.Text = GetName(dr["district"].ToString());
        this.txtCity.Text = GetName(dr["province"].ToString());
        this.txProperty.Text = GetName(dr["property"].ToString());
        this.txtCompanySize.Text = GetName(dr["customer_size"].ToString());
        this.txtCompanyTel.Text = dr["tel"].ToString();
        this.txtFax.Text = dr["fax"].ToString();
        this.txtZip.Text = dr["zip"].ToString();
        this.txtAdress.Text = dr["address"].ToString();
        this.txtEmail.Text = dr["email"].ToString();
        this.txtHomePage.Text = dr["homepage"].ToString();

        this.txtRemark.Text = dr["note"].ToString();
        this.txtTrack.Text = GetUserName(dr["tracking_persen"].ToString());
        this.txtIsUse.Text = GetName(dr["is_use"].ToString());
        this.txtAddTime.Text = dr["date_time"].ToString();
        this.txtIsUse.Text = GetIsUse();
        this.lblAcc.Text = ItemSplit(dr["organization"].ToString());
    }

    /// <summary>
    /// 邦定联系人表
    /// </summary>
    private void BindDtlPerson()
    {
        string sql = @" SELECT first_name, first_tel, first_sex, first_depart, first_duty, first_mobile, first_email, 
                      first_interest, note FROM ITSV_customer_person WHERE (customer_id = " + ComId + ")";
        DataTable dt = null;
        try
        {
            dt = dataport.GetTableResult(sql);
        }
        catch
        {
            dt = null;
        }
        if (dt != null && dt.Rows.Count > 0)
        {
            this.dtlPerson.DataSource = dt;
            this.dtlPerson.DataBind();
        }
        else
        {
            this.dtlPerson.DataSource = dt;
            this.dtlPerson.DataBind();
        }
    }


    /// <summary>
    /// 返回
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnBack_Click(object sender, EventArgs e)
    {
        if (Request.QueryString["url"] == null || Request.QueryString["url"] == string.Empty)
            Response.Redirect("CustomerManage.aspx");
        else
            Response.Redirect(Request.QueryString["url"]);
    }
    /// <summary>
    /// 分解附件
    /// </summary>
    /// <param name="document"></param>
    /// <returns></returns>
    private string ItemSplit(string document)
    {
        if (document == null)
        {
            return null;
        }

        string[] documentItems = document.Split('|');
        if (documentItems.Length == 0)
        {
            return null;
        }

        string documentStr = "";
        int i = 1;
        foreach (string str in documentItems)
        {
            if (str != null && str.Trim().Length > 0)
            {
                int charIndex = str.IndexOf(']');
                if (charIndex < 0)
                {
                    continue;
                }

                string documentName = str.Substring(0, charIndex + 1);
                string documentPath = str.Substring(charIndex + 1);
                documentStr += "<a href=\"../upload/" + documentPath + "\">" + documentName + "</a>";
                if (i % 4 == 0)
                {
                    documentStr += "<br/>";
                }
                else
                    documentStr += "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
                i++;
            }
        }

        return documentStr;
    }
}