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();
}
private void BindData(string type)
{
UDS.Components.CM cm = new UDS.Components.CM();
DataSet ds = new DataSet();
switch(type)
{
case "ac":
SqlDataReader dr_contactedclient = cm.GetContactedClientBySellmanID(0,begintime,endtime);
DataTable dt_contactedclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedclient);
dt_contactedclient.TableName = "Client";
ds.Tables.Add(dt_contactedclient);
break;
case "cc":
SqlDataReader dr_contactedcallinclient = cm.GetCallinClientBySellmanID(0,begintime,endtime);
DataTable dt_contactedcallinclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedcallinclient);
dt_contactedcallinclient.TableName = "Client";
ds.Tables.Add(dt_contactedcallinclient);
break;
case "nc":
SqlDataReader dr_newclient = cm.GetCallinClientBySellmanID(0,begintime,endtime);
DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient);
dt_newclient.TableName = "Client";
ds.Tables.Add(dt_newclient);
break;
case "neoc":
SqlDataReader dr_neoclient = cm.GetNegotiateClient();
DataTable dt_neoclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neoclient);
dt_neoclient.TableName = "Client";
ds.Tables.Add(dt_neoclient);
break;
case "neonc":
SqlDataReader dr_neonewclient = cm.GetNewNegotiateClient(begintime,endtime);
DataTable dt_neonewclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neonewclient);
dt_neonewclient.TableName = "Client";
ds.Tables.Add(dt_neonewclient);
break;
case "n3c":
SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime,endtime);
DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client);
dt_new3client.TableName = "Client";
ds.Tables.Add(dt_new3client);
break;
case "3c":
SqlDataReader dr_3client = cm.Get3StarClient();
DataTable dt_3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_3client);
dt_3client.TableName = "Client";
ds.Tables.Add(dt_3client);
break;
}
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("StaffID_Staff",ds.Tables["Client"].Columns["AddmanID"],ds.Tables["Staff"].Columns["Staff_ID"],false);
ltl_Client.Text = ds.Tables["Client"].Rows.Count.ToString();
dgrd_Client.DataSource = ds.Tables["Client"].DefaultView;
dgrd_Client.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();
}
private void BindData(string type)
{
UDS.Components.CM cm = new UDS.Components.CM();
DataSet ds = new DataSet();
switch (type)
{
case "ac":
SqlDataReader dr_contactedclient = cm.GetContactedClientBySellmanID(0, begintime, endtime);
DataTable dt_contactedclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedclient);
dt_contactedclient.TableName = "Client";
ds.Tables.Add(dt_contactedclient);
break;
case "cc":
SqlDataReader dr_contactedcallinclient = cm.GetCallinClientBySellmanID(0, begintime, endtime);
DataTable dt_contactedcallinclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedcallinclient);
dt_contactedcallinclient.TableName = "Client";
ds.Tables.Add(dt_contactedcallinclient);
break;
case "nc":
SqlDataReader dr_newclient = cm.GetCallinClientBySellmanID(0, begintime, endtime);
DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient);
dt_newclient.TableName = "Client";
ds.Tables.Add(dt_newclient);
break;
case "neoc":
SqlDataReader dr_neoclient = cm.GetNegotiateClient();
DataTable dt_neoclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neoclient);
dt_neoclient.TableName = "Client";
ds.Tables.Add(dt_neoclient);
break;
case "neonc":
SqlDataReader dr_neonewclient = cm.GetNewNegotiateClient(begintime, endtime);
DataTable dt_neonewclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neonewclient);
dt_neonewclient.TableName = "Client";
ds.Tables.Add(dt_neonewclient);
break;
case "n3c":
SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime, endtime);
DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client);
dt_new3client.TableName = "Client";
ds.Tables.Add(dt_new3client);
break;
case "3c":
SqlDataReader dr_3client = cm.Get3StarClient();
DataTable dt_3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_3client);
dt_3client.TableName = "Client";
ds.Tables.Add(dt_3client);
break;
}
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("StaffID_Staff", ds.Tables["Client"].Columns["AddmanID"], ds.Tables["Staff"].Columns["Staff_ID"], false);
ltl_Client.Text = ds.Tables["Client"].Rows.Count.ToString();
dgrd_Client.DataSource = ds.Tables["Client"].DefaultView;
dgrd_Client.DataBind();
}
