conshowctrl.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_ConShowCtrl : PageBaseUserCtrl
{
    WYX.Dataport.Dataport dp = new WYX.Dataport.Dataport();
    long code = 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["code"] != null && IsNuberic(Request.QueryString["code"]))
        {
            code = Convert.ToInt64(Request.QueryString["code"]);
        }
        else
        {
            ShowAndClose("您输入的参数不正确，请您重试!!", "");
            return;
        }

        if (Request.QueryString["isedit"] == null || Request.QueryString["isedit"] != "true")
        {
            btnSubmit.Visible = false;
        }

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

    #region 初始化页面
    /// <summary>
    /// 初始化页面
    /// </summary>
    private void SetData()
    {
        string sql = @"SELECT ( select name from ITSV_CustomerManager where code = customer_id) as customerName, customer_person_id, title, 
                    type,period, project, money, (select name from users where user_id =contract_person) as userName, 
                    contract_time, content, note, document
                    FROM ITSV_CustomerContract";
        sql += "    WHERE (code = " + code + ")";

        DataRow ConItem = null;
        try { ConItem = dp.GetRowResult(sql); }
        catch { ConItem = null; }

        if (ConItem == null)
        {
            ShowAndClose("您输入的参数不正确，请您重试!!", "");
            return;
        }
        else
        {
            txtAndItem.Text = GetDictName(ConItem["project"].ToString());
            txtConMoney.Text = ConItem["money"].ToString();
            txtConProid.Text = GetDictName(ConItem["period"].ToString());

            txtContent.Text = ConItem["content"].ToString();

            txtConType.Text = GetDictName(ConItem["type"].ToString());
            txtCustomNO.Text = ConItem["customerName"].ToString();
            txtCustomPerson.Text = GetCustomerPerson(ConItem["customer_person_id"]);
            txtDateTime.Text = string.Format("{0:yyyy-MM-dd}",ConItem["contract_time"]);
            txtNote.Text = ConItem["note"].ToString();
            txtPerson.Text = ConItem["userName"].ToString();
            txtTitle.Text = ConItem["title"].ToString();
            lblAcc.Text = ItemSplit(ConItem["document"].ToString());
        }
    }

    /// <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;
    }
    #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 dp.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 dp.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 dp.GetRowResultID(sql);
    }
    #endregion

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        Response.Redirect("ConEdit.aspx?code=" + code, true);
    }
}