persenmanage.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_PersenManage : PageBaseUserCtrl
{
    public WYX.Dataport.Dataport dataport = new WYX.Dataport.Dataport();
    public string tblName = "ITSV_customer_person";//表名
    public string fldName = "code";//主键字段名

    public int IsReCount = 0;//是否
    public int OrderType = 1;//排序  0升，非0降

    public string strWhere = "";//条件
    private int PageSize = 10;

    private int ComId;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ComId = Convert.ToInt32(Request.QueryString["code"]);
            SetTitle();
            SetData();
        }
    }
    /// <summary>
    /// 初始化标题
    /// </summary>
    protected void SetTitle()
    {
        lblComCode.Text = ComId.ToString();
        lblComName.Text = GetName(ComId);
    }
    /// <summary>
    /// 获取客户名称
    /// </summary>
    /// <param name="code"></param>
    /// <returns></returns>
    private string GetName(int ComCode)
    {
        string sql = " select name from ITSV_CustomerManager where code = " + ComCode + "";
        try
        {
            return dataport.GetRowResultID(sql);
        }
        catch
        {
            return null;
        }
    }
    /// <summary>
    /// 获取性别
    /// </summary>
    /// <param name="str"></param>
    /// <returns></returns>
    public string GetSex(object str)
    {
        return GetStatus(str);
    }
    /// <summary>
    /// 获取性别
    /// </summary>
    /// <param name="str"></param>
    /// <returns></returns>
    public string GetStatus(object str)
    {
        Itsv.BLL.SystemManage.dictionaryBLL bll = new Itsv.BLL.SystemManage.dictionaryBLL();

        DataSet ds = bll.GetList(" dict_code = '" + str.ToString() + "'", ref msg);
        if (ds == null)
            return "";
        if (ds.Tables[0].Rows.Count == 0)
            return "";
        return ds.Tables[0].Rows[0]["dict_name"].ToString();
    }
    /// <summary>
    /// 初始化数据
    /// </summary>
    protected void SetData()
    {
        string sql = " customer_id = ''" + ComId + "''";
        strWhere = sql.ToString();
        BindGridView();
    }
    /// <summary>
    /// 绑定GridView数据
    /// </summary>
    private void BindGridView()
    {
        GridView1.PageSize = this.PageSize;
        pager.PageSize = this.PageSize;

        DataSet ds = GetDataSetByPage(strWhere);

        int rowCount = GetRecordCount(strWhere);
        pager.RecordCount = rowCount;
        BindPager();

        if (rowCount > 0)
        {
            try
            {
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataKeyNames = new string[] { "code" };
                GridView1.DataBind();
            }
            catch (Exception)
            {
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataBind();
            }
        }
        else if (rowCount == 0)
        {
            DataTable dt = AddEmputyData(ds);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }
    /// <summary>
    /// 增加一个空行来显示表头
    /// </summary>
    /// <param name="ds"></param>
    /// <returns></returns>
    private DataTable AddEmputyData(DataSet ds)
    {
        DataTable dt = ds.Tables[0];
        DataRow newRow = dt.NewRow();
        dt.Rows.Add(newRow);
        return dt;
    }
    /// <summary>
    /// 返回dataSet
    /// </summary>
    /// <param name="sqlWhere"></param>
    /// <returns></returns>
    public DataSet GetDataSetByPage(string sqlWhere)
    {
        DataSet ds = Minutepage(tblName, fldName, pager.PageSize, pager.CurrentPageIndex, IsReCount, OrderType, sqlWhere);
        return ds;
    }
    /// <summary>
    /// 读取纪录数
    /// </summary>
    /// <returns></returns>
    private int GetRecordCount(string sqlWhere)
    {
        string sql = "SELECT count(*) FROM ITSV_customer_person where customer_id = " + ComId + "";
        try
        {
            string reCount = dataport.GetRowResultID(sql);
            if (reCount == null || !IsInt(reCount))
            {
                return 0;
            }

            return int.Parse(reCount);
        }
        catch
        {
            return 0;
        }
    }
    #region 分页取数据 GetDataSet
    /// <summary>
    /// 功    能：分页
    /// 作    者：鼠标王

    /// 完成时间：2007-06-21
    /// 版    权：[e-mail]
    /// </summary>
    /// <param name="tblName">表名</param>
    /// <param name="fldName">主键字段名</param>
    /// <param name="PageSize">页尺寸</param>
    /// <param name="PageIndex">页码</param>
    /// <param name="IsReCount">返回记录总数, 非 0 值则返回</param>
    /// <param name="OrderType">设置排序类型, 非 0 值则降序</param>
    /// <param name="strWhere">查询条件 (注意: 不要加 where)</param>
    /// <returns>ds</returns>
    public DataSet Minutepage(string tblName, string fldName, int PageSize, int PageIndex, int IsReCount, int OrderType, string strWhere)
    {
        string sql = "exec UP_GetRecordByPage '" + tblName + "','" + fldName + "'," + PageSize + "," + PageIndex + "," + IsReCount + "," + OrderType + ",'" + strWhere + "' ";
        DataSet ds = dataport.GetDataSet(sql);
        return ds;
    }

    /// <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.PageSize = PageSize;

        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
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        BindGridView();
    }
    protected void pager_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        pager.CurrentPageIndex = e.NewPageIndex;
        GridView1.PageIndex = e.NewPageIndex - 1;
        BindGridView();
    }
    protected void GridView1_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 rowIndex = e.Row.RowIndex;
            LinkButton lbtnEdit = (LinkButton)(e.Row.FindControl("lbtnEdit"));
            LinkButton lbtnDelete = (LinkButton)(e.Row.FindControl("lbtnDelete"));
            LinkButton lbtnName = (LinkButton)(e.Row.FindControl("lbtnName"));
            Label Label1 = (Label)(e.Row.FindControl("Label1"));
            Label lblSex = (Label)(e.Row.FindControl("lblSex"));
            lbtnDelete.Attributes.Add("onclick", "return confirm('确实要删除本条信息吗?')");

            try
            {
                //主键
                int code = Convert.ToInt32(GridView1.DataKeys[e.Row.RowIndex].Value.ToString());
            }
            catch (Exception)
            {
                lbtnEdit.Visible = false;
                lbtnDelete.Visible = false;
                lbtnName.Visible = false;
                Label1.Visible = false;
                lblSex.Visible = false;
            }
            if (lbtnName != null && lbtnName.Visible)
            {
                lbtnName.CommandArgument = rowIndex.ToString();
            }
            if (lbtnEdit != null && lbtnEdit.Visible)
            {
                lbtnEdit.CommandArgument = rowIndex.ToString();
            }

            if (lbtnDelete != null && lbtnDelete.Visible)
            {
                lbtnDelete.CommandArgument = rowIndex.ToString();
            }
        }
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        ComId = Convert.ToInt32(Request.QueryString["code"]);
        if (e.CommandName == "lbtnName")
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument.ToString());
            int code = Convert.ToInt32(GridView1.DataKeys[rowIndex].Value.ToString());
            Response.Redirect("PersenLook.aspx?code="+ code +"&Com_ID=" + ComId);
        }
        if (e.CommandName == "lbtnEdit")
        {
            int rowIndex = Convert.ToInt32(e.CommandArgument.ToString());
            int code = Convert.ToInt32(GridView1.DataKeys[rowIndex].Value.ToString());
            Response.Redirect("PersenEdit.aspx?code="+code+"&Com_ID=" + ComId);
        }
        if (e.CommandName == "lbtnDelete")
        {
            string name = null;
            int rowIndex = Convert.ToInt32(e.CommandArgument.ToString());
            int code = Convert.ToInt32(GridView1.DataKeys[rowIndex].Value.ToString());
            name = ((LinkButton)GridView1.Rows[rowIndex].FindControl("lbtnName")).Text;
            string sql = "Delete ITSV_customer_person where code= " + code + "";
            
            bool falg = dataport.ExeSql(sql);
            if (!falg)
            {
                ShowMessage("数据删除失败！");
            }
            else
            {
                if (name != "")
                {
                    this.WriteUserAction("删除联系人\"" + name + "\"的信息");
                }
            }
            ComId = Convert.ToInt32(Request.QueryString["code"]);
            Response.Redirect("PersenManage.aspx?code=" + ComId);
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        ComId = Convert.ToInt32(Request.QueryString["code"]);
        Response.Redirect("PersenAdd.aspx?code=" + ComId );
    }
    protected void btnCsv_Click(object sender, EventArgs e)
    {
        Response.Redirect("CustomerManage.aspx");
    }
}