private void BindData() { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); SqlDataReader dr_Linkman = cm.GetAllLinkman(); DataTable dt_Linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Linkman); dt_Linkman.TableName = "Linkman"; ds.Tables.Add(dt_Linkman); SqlDataReader dr_client = null; dr_client = cm.GetContactedClientBySellmanID(sellmanid,begintime,endtime); DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client); dt_client.TableName = "Client"; ds.Tables.Add(dt_client); SqlDataReader dr_Fee = cm.GetFeeBySellmanID(sellmanid,begintime,endtime); DataTable dt_Fee = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Fee); dt_Fee.TableName = "Fee"; ds.Tables.Add(dt_Fee); ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false); ds.Relations.Add("ClientLinkman_Staff",ds.Tables["Client"].Columns["ChiefLinkmanID"],ds.Tables["Linkman"].Columns["ID"],false); ds.Relations.Add("Client_Fee",ds.Tables["Client"].Columns["ID"],ds.Tables["Fee"].Columns["ClientID"],false); dgrd_fee.DataSource = dt_client.DefaultView; dgrd_fee.DataBind(); }
private void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� if(!Page.IsPostBack) { UDS.Components.CM cm = new UDS.Components.CM(); SqlDataReader dr = cm.GetAllLinkman(); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dgrd_Linkman.DataSource = dt.DefaultView; dgrd_Linkman.DataBind(); ltl_Count.Text = dt.Rows.Count.ToString(); } }
private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (!Page.IsPostBack) { UDS.Components.CM cm = new UDS.Components.CM(); SqlDataReader dr = cm.GetAllLinkman(); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dgrd_Linkman.DataSource = dt.DefaultView; dgrd_Linkman.DataBind(); ltl_Count.Text = dt.Rows.Count.ToString(); } }
//绑定我的协同客户 private void BindMycooperatorClient() { TD2.Attributes["background"] = "../../images/maillistbutton2.gif"; TD1.Attributes["background"] = "../../images/maillistbutton1.gif"; pnl_ClientInfo.Visible = false; pnl.Visible = false; UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); SqlDataReader dr_Client = cm.GetClientInfoBycooperatorID(Int32.Parse(userid)); DataTable dt_Client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Client); dt_Client.TableName = "Client"; ds.Tables.Add(dt_Client); SqlDataReader dr_Contact = cm.GetClientContactInfo(0); DataTable dt_Contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Contact); dt_Contact.TableName = "Contact"; ds.Tables.Add(dt_Contact); SqlDataReader dr_Linkman = cm.GetAllLinkman(); DataTable dt_Linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Linkman); dt_Linkman.TableName = "Linkman"; ds.Tables.Add(dt_Linkman); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false); ds.Relations.Add("ClientLinkmanID_Linkman", ds.Tables["Client"].Columns["ChiefLinkmanID"], ds.Tables["Linkman"].Columns["ID"], false); ds.Tables["Client"].DefaultView.Sort = (string)ViewState["SortField"] + " " + ViewState["SortDirect"]; dgd_Client.DataSource = ds.Tables["Client"].DefaultView; dgd_Client.DataBind(); }
private void BindData() { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); SqlDataReader dr_Linkman = cm.GetAllLinkman(); DataTable dt_Linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Linkman); dt_Linkman.TableName = "Linkman"; ds.Tables.Add(dt_Linkman); SqlDataReader dr_client = null; dr_client = cm.GetContactedClientBySellmanID(sellmanid, begintime, endtime); DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client); dt_client.TableName = "Client"; ds.Tables.Add(dt_client); SqlDataReader dr_Fee = cm.GetFeeBySellmanID(sellmanid, begintime, endtime); DataTable dt_Fee = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Fee); dt_Fee.TableName = "Fee"; ds.Tables.Add(dt_Fee); ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false); ds.Relations.Add("ClientLinkman_Staff", ds.Tables["Client"].Columns["ChiefLinkmanID"], ds.Tables["Linkman"].Columns["ID"], false); ds.Relations.Add("Client_Fee", ds.Tables["Client"].Columns["ID"], ds.Tables["Fee"].Columns["ClientID"], false); dgrd_fee.DataSource = dt_client.DefaultView; dgrd_fee.DataBind(); }
//���ҵ�Эͬ�ͻ� private void BindMycooperatorClient() { TD2.Attributes["background"] = "../../images/maillistbutton2.gif"; TD1.Attributes["background"] = "../../images/maillistbutton1.gif"; pnl_ClientInfo.Visible = false; pnl.Visible = false; UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); SqlDataReader dr_Client = cm.GetClientInfoBycooperatorID(Int32.Parse(userid)); DataTable dt_Client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Client); dt_Client.TableName = "Client"; ds.Tables.Add(dt_Client); SqlDataReader dr_Contact = cm.GetClientContactInfo(0); DataTable dt_Contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Contact); dt_Contact.TableName = "Contact"; ds.Tables.Add(dt_Contact); SqlDataReader dr_Linkman = cm.GetAllLinkman(); DataTable dt_Linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Linkman); dt_Linkman.TableName = "Linkman"; ds.Tables.Add(dt_Linkman); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false); ds.Relations.Add("ClientLinkmanID_Linkman",ds.Tables["Client"].Columns["ChiefLinkmanID"],ds.Tables["Linkman"].Columns["ID"],false); ds.Tables["Client"].DefaultView.Sort = (string)ViewState["SortField"] + " " + ViewState["SortDirect"]; dgd_Client.DataSource = ds.Tables["Client"].DefaultView; dgd_Client.DataBind(); }
//���ҵĿͻ� private void BindGrid() { TD1.Attributes["background"] = "../../images/maillistbutton2.gif"; TD2.Attributes["background"] = "../../images/maillistbutton1.gif"; UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); SqlDataReader dr_Client = cm.GetMyClients(Int32.Parse(userid)); DataTable dt_Client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Client); dt_Client.TableName = "Client"; ds.Tables.Add(dt_Client); SqlDataReader dr_Contact = cm.GetClientContactInfo(0); DataTable dt_Contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Contact); dt_Contact.TableName = "Contact"; ds.Tables.Add(dt_Contact); SqlDataReader dr_Linkman = cm.GetAllLinkman(); DataTable dt_Linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Linkman); dt_Linkman.TableName = "Linkman"; ds.Tables.Add(dt_Linkman); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false); ds.Relations.Add("ClientLinkmanID_Linkman",ds.Tables["Client"].Columns["ChiefLinkmanID"],ds.Tables["Linkman"].Columns["ID"],false); ds.Tables["Client"].DefaultView.Sort = (string)ViewState["SortField"] + " " + ViewState["SortDirect"]; dgd_Client.DataSource = ds.Tables["Client"].DefaultView; dgd_Client.DataBind(); DateTime monthbegin = DateTime.Now.AddMonths(-1); DateTime monthend = new DateTime(DateTime.Now.Year,DateTime.Now.Month,DateTime.DaysInMonth(DateTime.Now.Year,DateTime.Now.Month)); SqlDataReader dr_ContactTimes = cm.GetContactByStaffIDandTime(Int32.Parse(userid),monthbegin,monthend); int contacttimes = 0; try { while (dr_ContactTimes.Read()) { contacttimes++; } } finally { dr_ContactTimes.Close(); } if(Session["cm_permission"].ToString() == "administrator") { pnl.Visible = true; pnl_ClientInfo.Visible = true; } else { pnl.Visible = false; pnl_ClientInfo.Visible = false; } //���û�пͻ����� ��������� ��ϵ�� �� �Ӵ������ ��ť if (dgd_Client.Items.Count==0) { btn_AddLinkman.Visible = false; btn_AddContact.Visible = false; } else { btn_AddLinkman.Visible = true; btn_AddContact.Visible = true; } ltl_ClientCount.Text = dt_Client.Rows.Count.ToString(); ltl_ContactTimes.Text = contacttimes.ToString(); }
//绑定我的客户 private void BindGrid() { TD1.Attributes["background"] = "../../images/maillistbutton2.gif"; TD2.Attributes["background"] = "../../images/maillistbutton1.gif"; UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); SqlDataReader dr_Client = cm.GetMyClients(Int32.Parse(userid)); DataTable dt_Client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Client); dt_Client.TableName = "Client"; ds.Tables.Add(dt_Client); SqlDataReader dr_Contact = cm.GetClientContactInfo(0); DataTable dt_Contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Contact); dt_Contact.TableName = "Contact"; ds.Tables.Add(dt_Contact); SqlDataReader dr_Linkman = cm.GetAllLinkman(); DataTable dt_Linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Linkman); dt_Linkman.TableName = "Linkman"; ds.Tables.Add(dt_Linkman); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_Staff = staff.GetAllStaffs(); DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff); dt_Staff.TableName = "Staff"; ds.Tables.Add(dt_Staff); ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false); ds.Relations.Add("ClientLinkmanID_Linkman", ds.Tables["Client"].Columns["ChiefLinkmanID"], ds.Tables["Linkman"].Columns["ID"], false); ds.Tables["Client"].DefaultView.Sort = (string)ViewState["SortField"] + " " + ViewState["SortDirect"]; dgd_Client.DataSource = ds.Tables["Client"].DefaultView; dgd_Client.DataBind(); DateTime monthbegin = DateTime.Now.AddMonths(-1); DateTime monthend = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month)); SqlDataReader dr_ContactTimes = cm.GetContactByStaffIDandTime(Int32.Parse(userid), monthbegin, monthend); int contacttimes = 0; while (dr_ContactTimes.Read()) { contacttimes++; } dr_ContactTimes.Close(); if (Session["cm_permission"].ToString() == "administrator") { pnl.Visible = true; pnl_ClientInfo.Visible = true; } else { pnl.Visible = false; pnl_ClientInfo.Visible = false; } //如果没有客户,则 不出现添加 联系人 和 接触情况的 按钮 if (dgd_Client.Items.Count == 0) { btn_AddLinkman.Visible = false; btn_AddContact.Visible = false; } else { btn_AddLinkman.Visible = true; btn_AddContact.Visible = true; } ltl_ClientCount.Text = dt_Client.Rows.Count.ToString(); ltl_ContactTimes.Text = contacttimes.ToString(); }
private void BindData(string type) { begintime = DateTime.Parse(tbx_begintime.Text); endtime = DateTime.Parse(tbx_endtime.Text); UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetAllStaffs(); DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt_staff.TableName = "Staff"; ds.Tables.Add(dt_staff); SqlDataReader dr_client = cm.GetContactedClientBySellmanID(0, begintime, endtime); DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client); dt_client.TableName = "Client"; ds.Tables.Add(dt_client); ltl_Client.Text = dt_client.Rows.Count.ToString(); if (type == "client") //按客户排列 { dgrd_clientfee.Visible = true; dgrd_sellmanfee.Visible = false; SqlDataReader dr_contact = cm.GetContactInfo(begintime, endtime); DataTable dt_contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact); dt_contact.TableName = "Contact"; ds.Tables.Add(dt_contact); SqlDataReader dr_linkman = cm.GetAllLinkman(); DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt_linkman.TableName = "Linkman"; ds.Tables.Add(dt_linkman); ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false); ds.Relations.Add("ClientLinkman_Staff", ds.Tables["Client"].Columns["ChiefLinkmanID"], ds.Tables["Linkman"].Columns["ID"], false); ds.Relations.Add("Client_Contact", ds.Tables["Client"].Columns["ID"], ds.Tables["Contact"].Columns["ClientID"], false); dgrd_clientfee.DataSource = dt_client.DefaultView; dgrd_clientfee.DataBind(); ltl_Fee.Text = totalfee.ToString(); } else if (type == "sellman") { dgrd_clientfee.Visible = false; dgrd_sellmanfee.Visible = true; SqlDataReader dr_sellman = cm.GetSellman(begintime, endtime); DataTable dt_sellman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_sellman); dt_sellman.TableName = "Sellman"; ds.Tables.Add(dt_sellman); foreach (DataRow row in dt_sellman.Rows) { totalfee += Int32.Parse(row["fee"].ToString()); } ds.Relations.Add("StaffID_RealName", ds.Tables["Sellman"].Columns["Staff_Name"], ds.Tables["Staff"].Columns["Staff_Name"], false); dgrd_sellmanfee.DataSource = dt_sellman.DefaultView; dgrd_sellmanfee.DataBind(); ltl_Fee.Text = totalfee.ToString(); } }
private void BindData(string type) { begintime = DateTime.Parse(tbx_begintime.Text); endtime = DateTime.Parse(tbx_endtime.Text); UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetAllStaffs(); DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt_staff.TableName = "Staff"; ds.Tables.Add(dt_staff); SqlDataReader dr_client = cm.GetContactedClientBySellmanID(0,begintime,endtime); DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client); dt_client.TableName = "Client"; ds.Tables.Add(dt_client); ltl_Client.Text = dt_client.Rows.Count.ToString(); if(type=="client")//���ͻ����� { dgrd_clientfee.Visible = true; dgrd_sellmanfee.Visible = false; SqlDataReader dr_contact = cm.GetContactInfo(begintime,endtime); DataTable dt_contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact); dt_contact.TableName = "Contact"; ds.Tables.Add(dt_contact); SqlDataReader dr_linkman = cm.GetAllLinkman(); DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt_linkman.TableName = "Linkman"; ds.Tables.Add(dt_linkman); ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false); ds.Relations.Add("ClientLinkman_Staff",ds.Tables["Client"].Columns["ChiefLinkmanID"],ds.Tables["Linkman"].Columns["ID"],false); ds.Relations.Add("Client_Contact",ds.Tables["Client"].Columns["ID"],ds.Tables["Contact"].Columns["ClientID"],false); dgrd_clientfee.DataSource = dt_client.DefaultView; dgrd_clientfee.DataBind(); ltl_Fee.Text = totalfee.ToString(); } else if(type=="sellman") { dgrd_clientfee.Visible = false; dgrd_sellmanfee.Visible = true; SqlDataReader dr_sellman = cm.GetSellman(begintime,endtime); DataTable dt_sellman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_sellman); dt_sellman.TableName = "Sellman"; ds.Tables.Add(dt_sellman); foreach(DataRow row in dt_sellman.Rows) { totalfee += Int32.Parse(row["fee"].ToString()); } ds.Relations.Add("StaffID_RealName",ds.Tables["Sellman"].Columns["Staff_Name"],ds.Tables["Staff"].Columns["Staff_Name"],false); dgrd_sellmanfee.DataSource = dt_sellman.DefaultView; dgrd_sellmanfee.DataBind(); ltl_Fee.Text = totalfee.ToString(); } }