private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); if (type == "all") { SqlDataReader dr_contact = cm.GetContactBySellmanID(sellmanid, begintime, endtime); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact); dt.TableName = "Contact"; ds.Tables.Add(dt); } else if (type == "callin") { SqlDataReader dr_callincontact = cm.GetCallinClientBySellmanID(sellmanid, begintime, endtime); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_callincontact); dt.TableName = "Contact"; ds.Tables.Add(dt); } UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetAllStaffs(); DataTable dt1 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt1.TableName = "Staffs"; ds.Tables.Add(dt1); SqlDataReader dr_linkman = cm.GetAllContactLinkman(); DataTable dt2 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt2.TableName = "Linkman"; ds.Tables.Add(dt2); SqlDataReader dr_cooperater = cm.GetAllCooperater(); DataTable dt3 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_cooperater); dt3.TableName = "Cooperater"; ds.Tables.Add(dt3); SqlDataReader dr_att = cm.GetAttachmentByContactID(0); DataTable dt4 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_att); dt4.TableName = "Attachment"; ds.Tables.Add(dt4); ds.Relations.Add("ContactMarketman_Staffs", ds.Tables["Staffs"].Columns["Staff_ID"], ds.Tables["Contact"].Columns["MarketmanID"]); ds.Relations.Add("Contact_Linkman", ds.Tables["Contact"].Columns["ID"], ds.Tables["Linkman"].Columns["ContactID"], false); ds.Relations.Add("Contact_Cooperater", ds.Tables["Contact"].Columns["ID"], ds.Tables["Cooperater"].Columns["ContactID"], false); ds.Relations.Add("Contact_Attachment", ds.Tables["Contact"].Columns["ID"], ds.Tables["Attachment"].Columns["pertainid"], false); rpt_data.DataSource = ds.Tables["Contact"].DefaultView; rpt_data.DataBind(); }
public void BindData() { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); SqlDataReader dr = cm.GetClientContactInfo_thisWeek(MyClientID); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dt.TableName = "ClientContact"; ds.Tables.Add(dt); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetTotalStaffs(); DataTable dt1 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt1.TableName = "Staffs"; ds.Tables.Add(dt1); SqlDataReader dr_linkman = cm.GetAllContactLinkman(); DataTable dt2 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt2.TableName = "Linkman"; ds.Tables.Add(dt2); SqlDataReader dr_cooperater = cm.GetAllCooperater(); DataTable dt3 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_cooperater); dt3.TableName = "Cooperater"; ds.Tables.Add(dt3); SqlDataReader dr_att = cm.GetAttachmentByContactID(0); DataTable dt4 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_att); dt4.TableName = "Attachment"; ds.Tables.Add(dt4); ds.Relations.Add("ContactMarketman_Staffs", ds.Tables["Staffs"].Columns["Staff_ID"], ds.Tables["ClientContact"].Columns["MarketmanID"], false); ds.Relations.Add("Contact_Linkman", ds.Tables["ClientContact"].Columns["ID"], ds.Tables["Linkman"].Columns["ContactID"], false); ds.Relations.Add("Contact_Cooperater", ds.Tables["ClientContact"].Columns["ID"], ds.Tables["Cooperater"].Columns["ContactID"], false); ds.Relations.Add("Contact_Attachment", ds.Tables["ClientContact"].Columns["ID"], ds.Tables["Attachment"].Columns["pertainid"], false); //ds.Relations.Add("ContactLinkman_Staffs",ds.Tables["Staffs"].Columns["Staff_ID"],ds.Tables["Linkman"].Columns["LinkmanID"],false); //ds.Relations.Add("ContactCooperater_Staffs",ds.Tables["Staffs"].Columns["Staff_ID"],ds.Tables["Cooperater"].Columns["CooperatingmanID"],false); rpt_data.DataSource = ds.Tables["ClientContact"].DefaultView; rpt_data.DataBind(); }
public void BindData() { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); SqlDataReader dr = cm.GetClientContactInfo_thisWeek(MyClientID); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr); dt.TableName = "ClientContact"; ds.Tables.Add(dt); UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetTotalStaffs(); DataTable dt1 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt1.TableName = "Staffs"; ds.Tables.Add(dt1); SqlDataReader dr_linkman = cm.GetAllContactLinkman(); DataTable dt2 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt2.TableName = "Linkman"; ds.Tables.Add(dt2); SqlDataReader dr_cooperater = cm.GetAllCooperater(); DataTable dt3 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_cooperater); dt3.TableName = "Cooperater"; ds.Tables.Add(dt3); SqlDataReader dr_att = cm.GetAttachmentByContactID(0); DataTable dt4 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_att); dt4.TableName = "Attachment"; ds.Tables.Add(dt4); ds.Relations.Add("ContactMarketman_Staffs",ds.Tables["Staffs"].Columns["Staff_ID"],ds.Tables["ClientContact"].Columns["MarketmanID"],false); ds.Relations.Add("Contact_Linkman",ds.Tables["ClientContact"].Columns["ID"],ds.Tables["Linkman"].Columns["ContactID"],false); ds.Relations.Add("Contact_Cooperater",ds.Tables["ClientContact"].Columns["ID"],ds.Tables["Cooperater"].Columns["ContactID"],false); ds.Relations.Add("Contact_Attachment",ds.Tables["ClientContact"].Columns["ID"],ds.Tables["Attachment"].Columns["pertainid"],false); //ds.Relations.Add("ContactLinkman_Staffs",ds.Tables["Staffs"].Columns["Staff_ID"],ds.Tables["Linkman"].Columns["LinkmanID"],false); //ds.Relations.Add("ContactCooperater_Staffs",ds.Tables["Staffs"].Columns["Staff_ID"],ds.Tables["Cooperater"].Columns["CooperatingmanID"],false); rpt_data.DataSource = ds.Tables["ClientContact"].DefaultView; rpt_data.DataBind(); }
private void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); if(type=="all") { SqlDataReader dr_contact = cm.GetContactBySellmanID(sellmanid,begintime,endtime); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact); dt.TableName = "Contact"; ds.Tables.Add(dt); } else if(type=="callin") { SqlDataReader dr_callincontact = cm.GetCallinClientBySellmanID(sellmanid,begintime,endtime); DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_callincontact); dt.TableName = "Contact"; ds.Tables.Add(dt); } UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetAllStaffs(); DataTable dt1 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt1.TableName = "Staffs"; ds.Tables.Add(dt1); SqlDataReader dr_linkman = cm.GetAllContactLinkman(); DataTable dt2 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt2.TableName = "Linkman"; ds.Tables.Add(dt2); SqlDataReader dr_cooperater = cm.GetAllCooperater(); DataTable dt3 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_cooperater); dt3.TableName = "Cooperater"; ds.Tables.Add(dt3); SqlDataReader dr_att = cm.GetAttachmentByContactID(0); DataTable dt4 = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_att); dt4.TableName = "Attachment"; ds.Tables.Add(dt4); ds.Relations.Add("ContactMarketman_Staffs",ds.Tables["Staffs"].Columns["Staff_ID"],ds.Tables["Contact"].Columns["MarketmanID"]); ds.Relations.Add("Contact_Linkman",ds.Tables["Contact"].Columns["ID"],ds.Tables["Linkman"].Columns["ContactID"],false); ds.Relations.Add("Contact_Cooperater",ds.Tables["Contact"].Columns["ID"],ds.Tables["Cooperater"].Columns["ContactID"],false); ds.Relations.Add("Contact_Attachment",ds.Tables["Contact"].Columns["ID"],ds.Tables["Attachment"].Columns["pertainid"],false); rpt_data.DataSource = ds.Tables["Contact"].DefaultView; rpt_data.DataBind(); }