saleshowctrl.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_SaleShowCtrl : PageBaseUserCtrl
{
    WYX.Dataport.Dataport dp = new WYX.Dataport.Dataport();
    long code = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.CacheControl = "no-cache";
        Response.AddHeader("Pragma", "no-cache");
        Response.Expires = 0;
        btnCancel.Attributes.Add("onclick", "window.close();");

        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 初始化页面
    private void SetData()
    {
        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 (s.code = " + code + ")";

        DataRow SaleItem = null;
        try { SaleItem = dp.GetRowResult(sql); }
        catch { SaleItem = null; }
        if (SaleItem != null && SaleItem[0].ToString() != string.Empty)
        {
            lblCode.Text = SaleItem["contract_id"].ToString();
            lblContent.InnerHtml = SaleItem["content"].ToString();
            lblDateTime1.Text = string.Format("{0:yyyy-MM-dd}",SaleItem["date_time_1"]);
            lblDateTime2.Text = string.Format("{0:yyyy-MM-dd}",SaleItem["date_time_2"]);
            lblDateTime3.Text = string.Format("{0:yyyy-MM-dd}",SaleItem["date_time_3"]);
            lblSaleMoney.Text = SaleItem["total_sale_money"].ToString();
            lblSaleMoneyPower.Text = SaleItem["other_sale_money"].ToString();
            lblWin.Text = GetDictName(SaleItem["win"]);

            lblPreject.Text = GetDictName(SaleItem["project"]);
            lblConTitle.Text = SaleItem["title"].ToString();
            lblCustomId.Text = SaleItem["customer"].ToString();
            lblCustomPerson.Text = GetCustomerPerson(SaleItem["customer_person_id"]);
            lblConTime.Text = string.Format("{0:yyyy-MM-dd}", SaleItem["contract_time"]);
            lblPeriod.Text = GetDictName(SaleItem["period"]);
            lblPerson.Text = SaleItem["userName"].ToString();
        }
        else
        {
            ShowAndClose("您输入的参数不正确，请您重试!!", "");
        }
    }
    #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

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        Response.Redirect("SaleAdd.aspx?reload=1&conId=" + lblCode.Text);
    }
}