admineditxiangmu.aspx.cs

明日Asp.net销售管理系统明日Asp.net销售管理系统

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;
using System.Data.SqlClient;
using BLL;

public partial class AdminEditXiangMu : System.Web.UI.Page
{
    SQLHelper sqlHelper = new SQLHelper();
    //SqlDataReader dr;

    DataSet ds = new DataSet();
    string sqlCounts = "select RowCounts=Count(*) from GeRenXMV where MingCheng!=''";
    string sql = "select XMId,FuZeRenId,MingCheng,ShiJian,XMZhuanYe,HangYe,XingMing from GeRenXMV where MingCheng!=''";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (!(Session["UserName"] != null && Session["UserRole"] == "Admin"))
            {
                Response.Redirect("../Default.aspx");
            }
            BindZhuanYeData();
            BindHangYeData(drlZhuanYe.SelectedValue);
            pager.RecordCount = GetRowCounts(sqlCounts);
            BindGeRenXM(sql);
        }
    }

    protected void BindZhuanYeData()
    {
        drlZhuanYe.DataSource = ZhuanYe.GetAllZhuanYe();
        drlZhuanYe.DataTextField = "MingCheng";
        drlZhuanYe.DataValueField = "ZhuanYeId";
        drlZhuanYe.DataBind();
        ListItem NewItem = new ListItem();
        NewItem.Text = "不限";
        NewItem.Value = "-1";
        drlZhuanYe.Items.Add(NewItem);
        drlZhuanYe.Items.FindByText("不限").Selected = true ;
    }

    protected void BindHangYeData(string ZhuanYeId)
    {
        if (rblHangYe.Items.Count > 0)
        {
            rblHangYe.Items.Clear();

        }
        rblHangYe.DataSource = HangYe.GetHangYeByZhuanYe(ZhuanYeId);
        rblHangYe.DataTextField = "MingCheng";
        rblHangYe.DataBind();
        rblHangYe.Items.Add("不限");
    }

    protected void drlZhuanYe_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindHangYeData(drlZhuanYe.SelectedValue);
    }
    protected void dgGeRenXM_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            LinkButton btDelete = (LinkButton)e.Item.Cells[6].Controls[0];
            btDelete.Attributes.Add("onclick", "javascript:return confirm('你确定要删除吗？');");
            e.Item.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='E8F4FF'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");


        }

    }


    protected void GetSearchString()
    {
        if (tbMingCheng.Text.Trim() != "")
        {
            sql = sql + " and MingCheng like '%" + tbMingCheng.Text.Trim() + "%'";
            sqlCounts = sqlCounts + " and MingCheng like '%" + tbMingCheng.Text.Trim() + "%'";
        }
        if (drlZhuanYe.SelectedItem != null && drlZhuanYe.SelectedItem.Text != "不限")
        {
            sql = sql + " and XMZhuanYe like '%" + drlZhuanYe.SelectedItem.Text + "%'";
            sqlCounts = sqlCounts + " and XMZhuanYe like '%" + drlZhuanYe.SelectedItem.Text + "%'";
        }
        if (rblHangYe.SelectedItem != null && rblHangYe.SelectedItem.Text != "不限" && drlZhuanYe.SelectedItem.Value != "不限")
        {
            sql = sql + " and HangYe like '%" + rblHangYe.SelectedItem.Text + "%'";
            sqlCounts = sqlCounts + " and HangYe like '%" + rblHangYe.SelectedItem.Text + "%'";
        }

        if (tbXingMing.Text.Trim() != "")
        {
            sql = sql + " and XingMing like '%" + tbXingMing.Text.Trim() + "%'";
            sqlCounts = sqlCounts + " and XingMing like '%" + tbXingMing.Text.Trim() + "%'";
        }


    }


    protected int GetRowCounts(string sqlCounts)
    {
        int RowCounts = 0;
        if (ds.Tables["RowCounts"] != null)
        {
            ds.Tables.Remove("RowCounts");
        }
        sqlHelper.RunSQL(sqlCounts, ref ds, "RowCounts");
        RowCounts = Convert.ToInt32(ds.Tables["RowCounts"].Rows[0]["RowCounts"].ToString());
        return RowCounts;
    }



    protected void BindGeRenXM(string sql)
    {
        SqlCommand cmd = new SqlCommand();
        sqlHelper.Open();
        cmd.Connection = sqlHelper.myConnection;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = sql;
        SqlDataAdapter sa = new SqlDataAdapter(cmd);
        if (ds.Tables["GeRenXM"] != null)
        {
            ds.Tables.Clear();
        }
        sa.Fill(ds, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "GeRenXM");
        dgGeRenXM.DataSource = ds.Tables["GeRenXM"];
        dgGeRenXM.DataBind();
        AddCustomText();


    }

    public void AddCustomText()
    {
        pager.CustomInfoText = "项目总数：<font color=\"Green\"><b>" + pager.RecordCount.ToString() + "</b></font>";
        pager.CustomInfoText += " 总页数：<font color=\"Green\"><b>" + pager.PageCount.ToString() + "</b></font>";
        pager.CustomInfoText += " 当前页：<font color=\"red\"><b>" + pager.CurrentPageIndex.ToString() + "</b></font>";

    }

    protected void ibtSearch_Click(object sender, ImageClickEventArgs e)
    {
        GetSearchString();
        pager.RecordCount = GetRowCounts(sqlCounts);
        BindGeRenXM(sql);
    }

    protected void pager_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
    {
        pager.CurrentPageIndex = e.NewPageIndex;
        GetSearchString();
        pager.RecordCount = GetRowCounts(sqlCounts);
        BindGeRenXM(sql);
    }

    protected void dgGeRenXM_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        XiangMu XM = new XiangMu();
        XM.XMId = Convert.ToInt32(dgGeRenXM.DataKeys[e.Item.ItemIndex]);
        XM.DeleteRelf();
        GetSearchString();
        pager.RecordCount = GetRowCounts(sqlCounts);
        BindGeRenXM(sql);
    }
    
}