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();
}
}
