protected void PopulateData()
{
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dataReader = null;
try
{
dataReader = staff.GetStaffInfo(Int32.Parse(StaffID));
}
catch
{
Server.Transfer("../Error.aspx");
}
try
{
if (dataReader.Read())
{
this.lblRealName.Text = dataReader["RealName"].ToString();
this.lblStaff_Name.Text = dataReader["Staff_Name"].ToString();
this.lblEmail.Text = dataReader["Email"].ToString();
this.lblRegistedDate.Text = dataReader["RegistedDate"].ToString();
this.lblSex.Text = dataReader["Sex"].ToString() == "True" ? "��" : "Ů";
}
}
finally
{
dataReader.Close();
}
}
private void BindData()
{
UDS.Components.CM cm = new UDS.Components.CM();
SqlDataReader dr_client = null;
if (type == "all")
{
dr_client = cm.GetNewClientBySellman(sellmanid, begintime, endtime);
}
else if (type == "3stars")
{
dr_client = cm.GetNew3StarClientBySellmanID(sellmanid, begintime, endtime);
}
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);
DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client);
dt_client.TableName = "Client";
ds.Tables.Add(dt_client);
ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false);
dgrd_sellmanclient.DataSource = dt_client.DefaultView;
dgrd_sellmanclient.DataBind();
}
//绑定选择框
private void BindGrid(int type)
{
UDS.Components.Staff staff = new UDS.Components.Staff();
UDS.Components.CM cm = new UDS.Components.CM();
if (type == 1)
{
SqlDataReader dr_staff = staff.GetAllStaffs();
DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff);
dt_staff.TableName = "Staff";
dgrd_List.Visible = true;
dgrd_Linkman.Visible = false;
dgrd_List.DataKeyField = "Staff_ID";
dgrd_List.DataSource = dt_staff.DefaultView;
dgrd_List.DataBind();
}
else if (type == 2)
{
SqlDataReader dr_linkman = cm.GetLinkmenByClientAddmanID(userid);
DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman);
dt_linkman.TableName = "Linkman";
dgrd_Linkman.Visible = true;
dgrd_List.Visible = false;
dgrd_Linkman.DataKeyField = "ID";
dgrd_Linkman.DataSource = dt_linkman.DefaultView;
dgrd_Linkman.DataBind();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
UDS.Components.CM cm = new UDS.Components.CM();
int clientid = Int32.Parse((Request.QueryString["ClientID"]==null)||(Request.QueryString["ClientID"]=="")?"0":Request.QueryString["ClientID"].ToString());
UDS.Components.ClientInfo client = cm.GetClientAllInfo(clientid);
ltl_ClientName.Text = client.ClientName;
ltl_ClientShortName.Text = client.ClientShortName;
ltl_UpdateTime.Text = client.UpdateTime.ToShortDateString();
ltl_Birthday.Text = client.Birthday.ToShortDateString();
ltl_ContactTimes.Text = client.ContactTimes.ToString();
ltl_SellPhase.Text = client.SellPhase;
ltl_BargainPrognosis.Text = client.BargainPrognosis;
ltl_Fee.Text = client.Fee.ToString();
//��ʾ������Ա
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_staff = staff.GetStaffInfo(client.AddManID);
while(dr_staff.Read())
{
ltl_AddMan.Text = dr_staff["realname"].ToString();
}
dr_staff.Close();
dr_staff=null;
ControlClientContactHistory1.MyClientID = clientid;
ControlClientContactHistory1.BindData();
}
}
private void BindData()
{
UDS.Components.CM cm = new UDS.Components.CM();
SqlDataReader dr_client = null;
if(type=="all")
{
dr_client = cm.GetNewClientBySellman(sellmanid,begintime,endtime);
}
else if(type=="3stars")
{
dr_client = cm.GetNew3StarClientBySellmanID(sellmanid,begintime,endtime);
}
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);
DataTable dt_client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_client);
dt_client.TableName = "Client";
ds.Tables.Add(dt_client);
ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false);
dgrd_sellmanclient.DataSource = dt_client.DefaultView;
dgrd_sellmanclient.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
UDS.Components.CM cm = new UDS.Components.CM();
int clientid = Int32.Parse((Request.QueryString["ClientID"] == null) || (Request.QueryString["ClientID"] == "")?"0":Request.QueryString["ClientID"].ToString());
UDS.Components.ClientInfo client = cm.GetClientAllInfo(clientid);
ltl_ClientName.Text = client.ClientName;
ltl_ClientShortName.Text = client.ClientShortName;
ltl_UpdateTime.Text = client.UpdateTime.ToShortDateString();
ltl_Birthday.Text = client.Birthday.ToShortDateString();
ltl_ContactTimes.Text = client.ContactTimes.ToString();
ltl_SellPhase.Text = client.SellPhase;
ltl_BargainPrognosis.Text = client.BargainPrognosis;
ltl_Fee.Text = client.Fee.ToString();
//显示销售人员
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_staff = staff.GetStaffInfo(client.AddManID);
while (dr_staff.Read())
{
ltl_AddMan.Text = dr_staff["realname"].ToString();
}
dr_staff.Close();
dr_staff = null;
ControlClientContactHistory1.MyClientID = clientid;
ControlClientContactHistory1.BindData();
}
}
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 BindGrid(int type)
{
UDS.Components.Staff staff = new UDS.Components.Staff();
UDS.Components.CM cm = new UDS.Components.CM();
if(type==1)
{
SqlDataReader dr_staff = staff.GetAllStaffs();
DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff);
dt_staff.TableName = "Staff";
dgrd_List.Visible = true;
dgrd_Linkman.Visible = false;
dgrd_List.DataKeyField = "Staff_ID";
dgrd_List.DataSource = dt_staff.DefaultView;
dgrd_List.DataBind();
}
else if(type==2)
{
SqlDataReader dr_linkman = cm.GetLinkmenByClientAddmanID(userid);
DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman);
dt_linkman.TableName = "Linkman";
dgrd_Linkman.Visible = true;
dgrd_List.Visible = false;
dgrd_Linkman.DataKeyField = "ID";
dgrd_Linkman.DataSource = dt_linkman.DefaultView;
dgrd_Linkman.DataBind();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// �ڴ˴������û������Գ�ʼ��ҳ��
int staffid = 0;
UDS.Components.Staff staff = new UDS.Components.Staff();
staffid = ((Request.QueryString["Staff_ID"]==null)||(Request.QueryString["Staff_ID"]==""))?0:Int32.Parse(Request.QueryString["Staff_ID"]);
SqlDataReader dr_staff = staff.GetStaffInfo(staffid);
try
{
while (dr_staff.Read())
{
ltl_Name.Text = dr_staff["RealName"].ToString();
ltl_Gender.Text = dr_staff["SexName"].ToString();
ltl_Mobile.Text = dr_staff["Mobile"].ToString();
ltl_Email.Text = dr_staff["Email"].ToString();
ltl_UnitTelephone.Text = dr_staff["Phone"].ToString();
ltl_Birthday.Text = dr_staff["Birthday"].ToString();
ltl_Position.Text = dr_staff["Position_Name"].ToString();
ltl_RD.Text = dr_staff["RQ"].ToString();
}
}
finally
{
dr_staff.Close();
}
}
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 BindStaffPosition()
{
UDS.Components.Staff staff = new UDS.Components.Staff();
ddl_StaffPosition.DataSource = staff.GetAllPosition();
ddl_StaffPosition.DataTextField = "Position_Name";
ddl_StaffPosition.DataValueField = "Position_ID";
ddl_StaffPosition.DataBind();
ddl_StaffPosition.Items.Insert(0, new ListItem("无限制", "0"));
}
private void BindStaffPosition()
{
UDS.Components.Staff staff = new UDS.Components.Staff();
ddl_StaffPosition.DataSource = staff.GetAllPosition();
ddl_StaffPosition.DataTextField = "Position_Name";
ddl_StaffPosition.DataValueField = "Position_ID";
ddl_StaffPosition.DataBind();
ddl_StaffPosition.Items.Insert(0,new ListItem("������","0"));
}
private void BindData()
{
begintime = DateTime.Parse(tbx_begintime.Text);
endtime = DateTime.Parse(tbx_endtime.Text);
UDS.Components.CM cm = new UDS.Components.CM();
UDS.Components.Staff staff = new UDS.Components.Staff();
DataSet ds = new DataSet();
SqlDataReader dr_realname = staff.GetAllStaffs();
DataTable dt_realname = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_realname);
dt_realname.TableName = "Realname";
ds.Tables.Add(dt_realname);
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);
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_callincontact = cm.GetCallinContactInfo(begintime, endtime);
DataTable dt_callincontact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_callincontact);
dt_callincontact.TableName = "CallinContact";
ds.Tables.Add(dt_callincontact);
SqlDataReader dr_newclient = cm.GetNewClient(begintime, endtime);
DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient);
dt_newclient.TableName = "NewClient";
ds.Tables.Add(dt_newclient);
SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime, endtime);
DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client);
dt_new3client.TableName = "New3Client";
ds.Tables.Add(dt_new3client);
ds.Relations.Add("staffid_realname", ds.Tables["Sellman"].Columns["SellmanID"], ds.Tables["Realname"].Columns["staff_id"], false);
ds.Relations.Add("sellman_contact", ds.Tables["Sellman"].Columns["SellmanID"], ds.Tables["Contact"].Columns["MarketmanID"], false);
ds.Relations.Add("sellman_callincontact", ds.Tables["Sellman"].Columns["SellmanID"], ds.Tables["CallinContact"].Columns["MarketmanID"], false);
ds.Relations.Add("sellman_newclient", ds.Tables["Sellman"].Columns["SellmanID"], ds.Tables["NewClient"].Columns["AddmanID"], false);
ds.Relations.Add("sellman_new3client", ds.Tables["Sellman"].Columns["SellmanID"], ds.Tables["New3Client"].Columns["AddmanID"], false);
dgrd_sellman.DataSource = dt_sellman.DefaultView;
dgrd_sellman.DataBind();
}
private void BindSubordinate()
{
//绑定下级人员
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_mysubordinate = staff.GetStaffFromPosition(Request.Cookies["Username"].Value, 2, 2);
ddl_MySubordinate.DataSource = dr_mysubordinate;
ddl_MySubordinate.DataTextField = "realname";
ddl_MySubordinate.DataValueField = "staff_id";
ddl_MySubordinate.DataBind();
dr_mysubordinate.Close();
// 加入自己
SqlDataReader dr_me = staff.GetStaffInfo(long.Parse(Request.Cookies["UserID"].Value));
string myrealname = "";
while (dr_me.Read())
{
myrealname = dr_me["realname"].ToString();
}
dr_me.Close();
ListItem listitem = new ListItem();
listitem.Text = myrealname;
listitem.Value = Request.Cookies["UserID"].Value;
ddl_MySubordinate.Items.Add(listitem);
if (ddl_MySubordinate.Items.Count != 0)
{
foreach (ListItem li in ddl_MySubordinate.Items)
{
if (li.Value == userid)
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
}
else
{
ddl_MySubordinate.Visible = false;
}
}
private void BindData()
{
begintime = DateTime.Parse(tbx_begintime.Text);
endtime = DateTime.Parse(tbx_endtime.Text);
UDS.Components.CM cm = new UDS.Components.CM();
UDS.Components.Staff staff= new UDS.Components.Staff();
DataSet ds = new DataSet();
SqlDataReader dr_realname = staff.GetAllStaffs();
DataTable dt_realname = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_realname);
dt_realname.TableName = "Realname";
ds.Tables.Add(dt_realname);
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);
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_callincontact = cm.GetCallinContactInfo(begintime,endtime);
DataTable dt_callincontact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_callincontact);
dt_callincontact.TableName = "CallinContact";
ds.Tables.Add(dt_callincontact);
SqlDataReader dr_newclient = cm.GetNewClient(begintime,endtime);
DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient);
dt_newclient.TableName = "NewClient";
ds.Tables.Add(dt_newclient);
SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime,endtime);
DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client);
dt_new3client.TableName = "New3Client";
ds.Tables.Add(dt_new3client);
ds.Relations.Add("staffid_realname",ds.Tables["Sellman"].Columns["SellmanID"],ds.Tables["Realname"].Columns["staff_id"],false);
ds.Relations.Add("sellman_contact",ds.Tables["Sellman"].Columns["SellmanID"],ds.Tables["Contact"].Columns["MarketmanID"],false);
ds.Relations.Add("sellman_callincontact",ds.Tables["Sellman"].Columns["SellmanID"],ds.Tables["CallinContact"].Columns["MarketmanID"],false);
ds.Relations.Add("sellman_newclient",ds.Tables["Sellman"].Columns["SellmanID"],ds.Tables["NewClient"].Columns["AddmanID"],false);
ds.Relations.Add("sellman_new3client",ds.Tables["Sellman"].Columns["SellmanID"],ds.Tables["New3Client"].Columns["AddmanID"],false);
dgrd_sellman.DataSource = dt_sellman.DefaultView;
dgrd_sellman.DataBind();
}
private void BindData(string planPeriodType)
{
SqlDataReader dr;
string username = Server.UrlDecode(Request.Cookies["UserName"].Value);
UDS.Components.Staff staff = new UDS.Components.Staff();
dr = staff.FindPlan(this.ddlPlanObjectType.SelectedValue, planPeriodType, "", username);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
//this.dgPlanList.DataSource = dt.DefaultView;
//dgPlanList.DataBind();
this.dbStaffList.DataSource = dt.DefaultView;
dbStaffList.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 GetStaffInfo(long StaffID)
{
SqlDataReader dr;
UDS.Components.Staff person = new UDS.Components.Staff();
dr = person.GetStaffInfo(StaffID);
txtPassword.TextMode = System.Web.UI.WebControls.TextBoxMode.SingleLine;
txtRePassword.TextMode = System.Web.UI.WebControls.TextBoxMode.SingleLine;
if (dr.Read())
{
txtStaffName.Text = dr["Staff_Name"].ToString();
txtStaffName.ReadOnly = true;
txtRealName.Text = dr["RealName"].ToString();
if (dr["Sex"].ToString() == "True")
{
rb_male.Checked = true;
sex = 1;
}
else
{
rb_female.Checked = true;
sex = 0;
}
txtBirthday.Text = dr["Birthday"].ToString().IndexOf(" ") > 0?dr["Birthday"].ToString().Substring(0, dr["Birthday"].ToString().IndexOf(" ")):dr["Birthday"].ToString();
if (txtBirthday.Text == "")
{
txtBirthday.Text = DateTime.Now.ToShortDateString();
}
txtPassword.Text = dr["Password"].ToString();
txtRePassword.Text = dr["Password"].ToString();
txtEmail.Text = dr["Email"].ToString();
txtPhone.Text = dr["Phone"].ToString();
txtMobile.Text = dr["Mobile"].ToString();
SelectDepartment(Int32.Parse(dr["Department_ID"].ToString()));
}
person = null;
dr.Close();
dr = null;
}
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 BindGrid(string staffname,int positionid,string mobile,string email,string gender,int[] displayfiledsid)
{
SqlDataReader dr;
UDS.Components.Staff staff = new UDS.Components.Staff();
dr = staff.Find(staffname,positionid,mobile,email,gender,bound);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
if(ViewState["sortfield"]!=null)
dt.DefaultView.Sort = ViewState["sortfield"] + " " + ViewState["sortdirect"];
dgrd_StaffList.DataSource = dt.DefaultView;
//������ٻ����б��ڴ�ӡ
Cache["StaffList"] = dt;
for(int i=0;i<displayfieldsid.Length;i++)
{
dgrd_StaffList.Columns[displayfiledsid[i]].Visible = true;
}
dgrd_StaffList.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 Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
int staffid = 0;
UDS.Components.Staff staff = new UDS.Components.Staff();
staffid = ((Request.QueryString["Staff_ID"] == null) || (Request.QueryString["Staff_ID"] == ""))?0:Int32.Parse(Request.QueryString["Staff_ID"]);
SqlDataReader dr_staff = staff.GetStaffInfo(staffid);
while (dr_staff.Read())
{
ltl_Name.Text = dr_staff["RealName"].ToString();
ltl_Gender.Text = dr_staff["SexName"].ToString();
ltl_Mobile.Text = dr_staff["Mobile"].ToString();
ltl_Email.Text = dr_staff["Email"].ToString();
ltl_UnitTelephone.Text = dr_staff["Phone"].ToString();
ltl_Birthday.Text = dr_staff["Birthday"].ToString();
ltl_Position.Text = dr_staff["Position_Name"].ToString();
ltl_RD.Text = dr_staff["RQ"].ToString();
}
dr_staff.Close();
}
private void Bind()
{
DataSet ds = new DataSet();
UDS.Components.Staff staff1 = new UDS.Components.Staff();
SqlDataReader dr_Staff = staff1.GetAllStaffs();
DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff);
dt_Staff.TableName = "Staff";
ds.Tables.Add(dt_Staff);
try
{
UDS.Components.Database db = new UDS.Components.Database();
SqlParameter[] prams =
{
db.MakeInParam("@SQL", SqlDbType.NText, 5000, searchstring)
};
SqlDataReader dr = null;
db.RunProc("sp_RunSql", prams, out dr);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
dt.TableName = "Client";
ds.Tables.Add(dt);
ltl_Client.Text = dt.Rows.Count.ToString();
ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false);
dt.DefaultView.Sort = ViewState["SortField"].ToString() + " " + ViewState["SortDirect"].ToString();
dgrd_clientlist.DataSource = dt.DefaultView;
dgrd_clientlist.DataBind();
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
private void ddl_MySubordinate_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (((DropDownList)sender).SelectedItem.Value == Request.Cookies["UserID"].Value)
{
Session["cm_permission"] = "administrator";
pnl.Visible = true;
pnl_ClientInfo.Visible = true;
}
else
{
Session["cm_permission"] = "leader";
pnl.Visible = false;
pnl_ClientInfo.Visible = false;
}
//改变观察视角
UDS.Components.Staff staff = new UDS.Components.Staff();
userid = ddl_MySubordinate.SelectedItem.Value;
SqlDataReader dr = staff.GetStaffInfo(long.Parse(userid));
while (dr.Read())
{
username = dr["staff_name"].ToString();
}
dr.Close();
ViewState["userid"] = userid;
ViewState["username"] = username;
//重新绑定
if (ViewState["NowTab"].ToString() == "client")
{
BindGrid();
}
else
{
BindMycooperatorClient();
}
}
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 BindDDL()
{
#region 协同人员列表初始化
UDS.Components.Staff staff = new UDS.Components.Staff();
try
{
ddlMoveTo.DataTextField = "Staff_Name";
ddlMoveTo.DataValueField = "Staff_ID";
ddlMoveTo.DataSource = staff.GetAllStaffs();
ddlMoveTo.DataBind();
}
catch (Exception e)
{
UDS.Components.Error.Log(e.ToString());
Server.Transfer("../Error.aspx");
}
finally
{
staff = null;
}
#endregion
}
protected void PopulateData()
{
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dataReader = null;
try
{
dataReader = staff.GetStaffInfo(Int32.Parse(StaffID));
}
catch
{
Server.Transfer("../Error.aspx");
}
if (dataReader.Read())
{
this.lblRealName.Text = dataReader["RealName"].ToString();
this.lblStaff_Name.Text = dataReader["Staff_Name"].ToString();
this.lblEmail.Text = dataReader["Email"].ToString();
this.lblRegistedDate.Text = dataReader["RegistedDate"].ToString();
this.lblSex.Text = dataReader["Sex"].ToString() == "True"?"男":"女";
}
dataReader.Close();
}
private void Bind()
{
DataSet ds = new DataSet();
UDS.Components.Staff staff1 = new UDS.Components.Staff();
SqlDataReader dr_Staff = staff1.GetAllStaffs();
DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff);
dt_Staff.TableName = "Staff";
ds.Tables.Add(dt_Staff);
try
{
UDS.Components.Database db = new UDS.Components.Database();
SqlParameter[] prams = {
db.MakeInParam("@SQL",SqlDbType.NText,5000,searchstring)
};
SqlDataReader dr = null;
db.RunProc("sp_RunSql",prams,out dr);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
dt.TableName = "Client";
ds.Tables.Add(dt);
ltl_Client.Text = dt.Rows.Count.ToString();
ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false);
dt.DefaultView.Sort = ViewState["SortField"].ToString() + " " + ViewState["SortDirect"].ToString();
dgrd_clientlist.DataSource = dt.DefaultView;
dgrd_clientlist.DataBind();
}
catch(Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
private void BindGrid(string staffname, int positionid, string mobile, string email, string gender, int[] displayfiledsid)
{
SqlDataReader dr;
UDS.Components.Staff staff = new UDS.Components.Staff();
dr = staff.Find(staffname, positionid, mobile, email, gender, bound);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
if (ViewState["sortfield"] != null)
{
dt.DefaultView.Sort = ViewState["sortfield"] + " " + ViewState["sortdirect"];
}
dgrd_StaffList.DataSource = dt.DefaultView;
//放入高速缓存中便于打印
Cache["StaffList"] = dt;
for (int i = 0; i < displayfieldsid.Length; i++)
{
dgrd_StaffList.Columns[displayfiledsid[i]].Visible = true;
}
dgrd_StaffList.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
ds = new StaffDataSet();
DataTable dt =(DataTable)Cache["StaffList"];
if(!Page.IsPostBack)
{
staffname = Session["staffname"].ToString();
positionid = Int32.Parse(Session["positionid"].ToString());
mobile = Session["mobile"].ToString();
email = Session["email"].ToString();
gender = Session["gender"].ToString();
dept = Session["dept"].ToString();
bound = Session["bound"].ToString();
displayfields = (string[])Session["displayfieldsname"];
ViewState["staffname"] = staffname;
ViewState["positionid"] = positionid.ToString();
ViewState["mobile"] = mobile.ToString();
ViewState["email"] = email.ToString();
ViewState["gender"] = gender.ToString();
ViewState["dept"] = dept.ToString();
ViewState["bound"] = bound.ToString();
ViewState["displayfields"] = displayfields;
Session["staffname"] = null;
Session["positionid"] = null;
Session["mobile"] = null;
Session["gender"] = null;
Session["dept"] = null;
Session["displayfieldsname"] = null;
Session["bound"] = null;
}
else
{
staffname = ViewState["staffname"].ToString();
positionid = Int32.Parse(ViewState["positionid"].ToString());
mobile = ViewState["mobile"].ToString();
email = ViewState["email"].ToString();
gender = ViewState["gender"].ToString();
dept = ViewState["dept"].ToString();
bound = ViewState["bound"].ToString();
displayfields = (string[])ViewState["displayfields"];
}
if(dt==null)
{
//�ò�����������ݣ����»�ȡ
SqlDataReader dr;
UDS.Components.Staff staff = new UDS.Components.Staff();
dr = staff.Find(staffname, positionid, mobile, email, gender, dept,bound);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
Cache["StaffList"] = dt;
}
//���datatable�����
foreach(DataRow row in dt.Rows)
{
DataRow staffviewrow = ds.StaffView.NewRow();
staffviewrow["Staff_Name"] = row["Staff_Name"].ToString();
staffviewrow["RealName"] = row["RealName"].ToString();
staffviewrow["Mobile"] = row["Mobile"].ToString();
staffviewrow["SexName"] = row["SexName"].ToString();
staffviewrow["Email"] = row["Email"].ToString();
staffviewrow["Position_Name"] = row["Position_Name"].ToString();
ds.StaffView.AddStaffViewRow((StaffDataSet.StaffViewRow)staffviewrow);
}
stafflistreport = new StaffList();
stafflistreport.SetDataSource(ds);
crv_StaffList.ReportSource = stafflistreport;
//�����û�ѡ�������ֶ�
foreach(string fieldname in displayfields)
{
stafflistreport.ReportDefinition.ReportObjects["ttl"+fieldname].ObjectFormat.EnableSuppress = false;
stafflistreport.ReportDefinition.ReportObjects[fieldname].ObjectFormat.EnableSuppress = false;
}
crv_StaffList.DataBind();
}
public void ddl_MySubordinate_SelectedIndexChanged(object sender, System.EventArgs e)
{
if(((DropDownList)sender).SelectedItem.Value==Request.Cookies["UserID"].Value)
{
Session["cm_permission"] = "administrator";
pnl.Visible = true;
pnl_ClientInfo.Visible = true;
}
else
{
Session["cm_permission"] = "leader";
pnl.Visible = false;
pnl_ClientInfo.Visible = false;
}
//�ı�۲��ӽ�
UDS.Components.Staff staff = new UDS.Components.Staff();
userid = ddl_MySubordinate.SelectedItem.Value;
SqlDataReader dr = staff.GetStaffInfo(long.Parse(userid));
try
{
while (dr.Read())
{
username = dr["staff_name"].ToString();
}
}
finally
{
if (dr != null)
{
dr.Close();
}
}
ViewState["userid"] = userid;
ViewState["username"] = username;
//���°�
if(ViewState["NowTab"].ToString()=="client")
BindGrid();
else
BindMycooperatorClient();
}
private void BindSubordinate()
{
//���¼���Ա
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_mysubordinate = staff.GetStaffFromPosition(Server.UrlDecode(Request.Cookies["UserName"].Value), 2, 2);
try
{
ddl_MySubordinate.DataSource = dr_mysubordinate;
ddl_MySubordinate.DataTextField = "realname";
ddl_MySubordinate.DataValueField = "staff_id";
ddl_MySubordinate.DataBind();
}
finally
{
dr_mysubordinate.Close();
}
// �����Լ�
SqlDataReader dr_me = staff.GetStaffInfo(long.Parse(Request.Cookies["UserID"].Value));
string myrealname = "";
try
{
while (dr_me.Read())
{
myrealname = dr_me["realname"].ToString();
}
}
finally
{
dr_me.Close();
}
ListItem listitem = new ListItem();
listitem.Text = myrealname;
listitem.Value = Request.Cookies["UserID"].Value;
ddl_MySubordinate.Items.Add(listitem);
if(ddl_MySubordinate.Items.Count!=0)
{
foreach(ListItem li in ddl_MySubordinate.Items)
{
if(li.Value==userid)
li.Selected = true;
else
li.Selected = false;
}
}
else
{
ddl_MySubordinate.Visible = false;
}
}
//���ҵ�Эͬ�ͻ�
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 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 btn_OK_Click(object sender, System.EventArgs e)
{
string searchbound = "";
searchstring = "";
UDS.Components.Staff mysubordinate = new UDS.Components.Staff();
SqlDataReader dr_mysubordinate = mysubordinate.GetStaffFromPosition(Request.Cookies["Username"].Value, 2, 2);
switch (ddl_SearchBound.SelectedValue)
{
//查询下属和本人
case "1":
//绑定下级人员
while (dr_mysubordinate.Read())
{
searchbound += "'" + dr_mysubordinate["Staff_ID"].ToString() + "',";
}
dr_mysubordinate.Close();
searchbound += "'" + Request.Cookies["UserID"].Value + "'";
break;
//查询本人
case "2":
searchbound += "'" + Request.Cookies["UserID"].Value + "'";
break;
//查询下属
case "3":
while (dr_mysubordinate.Read())
{
searchbound += "'" + dr_mysubordinate["Staff_ID"].ToString() + "',";
}
dr_mysubordinate.Close();
searchbound = (searchbound == "")?"":searchbound.Substring(0, searchbound.Length - 1);
break;
}
#region 根据查询条件产生查询语句
if (lbx_search.Items.Count > 0)
{
DateTime begintime = new DateTime();
DateTime endtime = DateTime.Now;
foreach (ListItem lt in lbx_search.Items)
{
string [] searcharr = new string[2];
searcharr = lt.Value.Split(':');
switch (searcharr[0].Trim())
{
case "客户名称":
searchstring += "UDS_CM_ClientInfo.name like '%" + searcharr[1] + "%' and ";
break;
case "客户分类":
switch (searcharr[1])
{
case "终端用户":
searchstring += "patindex('%terminal%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
case "渠道商":
searchstring += "patindex('%channal%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
case "社会关系":
searchstring += "patindex('%social%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
case "媒体公关":
searchstring += "patindex('%media%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
}
break;
case "所处行业":
switch (searcharr[1])
{
case "房地产":
searchstring += "patindex('%realty%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "IT":
searchstring += "patindex('%IT%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "商业贸易":
searchstring += "patindex('%business%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "电信":
searchstring += "patindex('%telecom%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "邮政通讯":
searchstring += "patindex('%post%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "咨询服务":
searchstring += "patindex('%refer%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "旅游业":
searchstring += "patindex('%travel%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "交通运输":
searchstring += "patindex('%bus%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "金融证券":
searchstring += "patindex('%stock%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "保险":
searchstring += "patindex('%insurance%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "税务":
searchstring += "patindex('%tax%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "制造业":
searchstring += "patindex('%make%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "家电":
searchstring += "patindex('%he%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "服装":
searchstring += "patindex('%clothe%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "食品":
searchstring += "patindex('%food%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "医药":
searchstring += "patindex('%medicine%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "机械":
searchstring += "patindex('%mechanism%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "汽车制造":
searchstring += "patindex('%auto%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
}
break;
case "企业性质":
switch (searcharr[1])
{
case "政府":
searchstring += "patindex('%government%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "国营":
searchstring += "patindex('%contry%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "民营":
searchstring += "patindex('%privateowned%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "外资":
searchstring += "patindex('%oversea%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "上市公司":
searchstring += "patindex('%stock%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
}
break;
case "客户来源":
switch (searcharr[1])
{
case "销售主动联系":
searchstring += "patindex('%sellman%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
case "以前认识":
searchstring += "patindex('%familiar%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
case "熟人介绍":
searchstring += "patindex('%introduce%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
case "客户主动联系":
searchstring += "patindex('%client%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
}
break;
case "客户编号":
searchstring += "UDS_CM_ClientInfo.id='" + searcharr[1] + "' and ";
break;
case "联系人":
//searchstring_linkman = "select * from UDS_CM_ClientInfo,UDS_CM_Linkman where UDS_CM_ClientInfo.id=UDS_CM_Linkman.clientid and UDS_CM_Linkman.name='" + searcharr[1] + "'" + " and ";
searchstring += "UDS_CM_Linkman.name='" + searcharr[1] + "' and ";
break;
case "电话":
searchstring += "UDS_CM_ClientInfo.telephone='" + searcharr[1] + "' and ";
break;
case "销售人员":
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]);
string tmp = "UDS_CM_ClientInfo.addmanid='";
while (dr_staffid.Read())
{
tmp += dr_staffid["staff_id"] + "' or UDS_CM_ClientInfo.addmanid='";
}
dr_staffid.Close();
if (tmp == "UDS_CM_ClientInfo.addmanid='")
{
searchstring = "1=2";
}
else
{
tmp = tmp.Substring(0, tmp.Length - 32);
searchstring += "(" + tmp + ") and ";
}
break;
case "添加日期":
searchstring += "datediff(d,UDS_CM_ClientInfo.birthday,'" + searcharr[1] + "')=0 and ";
break;
case "本周新增客户":
//得到本周起始日(周一 -- 周日)
begintime = DateTime.Now;
switch ((int)DateTime.Now.DayOfWeek)
{
case 0:
begintime = begintime.AddDays(-6);
break;
default:
begintime = begintime.AddDays(1 - (int)DateTime.Now.DayOfWeek);
break;
}
searchstring += "(UDS_CM_ClientInfo.birthday between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
case "本月新增客户":
//得到本月起始日
begintime = DateTime.Now;
begintime = begintime.AddDays(1 - DateTime.Now.Day);
searchstring += "(UDS_CM_ClientInfo.birthday between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
}
}
searchstring = "select UDS_CM_ClientInfo.*,UDS_CM_Linkman.Name AS Linkman from UDS_CM_ClientInfo left join UDS_CM_Linkman on UDS_CM_Linkman.clientid=UDS_CM_ClientInfo.id and UDS_CM_Linkman.ID=UDS_CM_ClientInfo.ChiefLinkmanID where " + searchstring;
// if(searchstring.EndsWith("and "))
// {
// searchstring = searchstring.Substring(0,searchstring.Length-4);
// }
#endregion
searchstring += "UDS_CM_ClientInfo.AddmanID IN (" + searchbound + ")";
ViewState["searchstring"] = searchstring;
// Response.Write(searchstring);
// Response.End();
Bind();
//Response.Write(searchstring);
}
}
private void btn_OK_Click(object sender, System.EventArgs e)
{
if(lbx_search.Items.Count>0)
{
string searchstring = "";
string tmp = "";
DateTime begintime = new DateTime();
DateTime endtime = DateTime.Now;
foreach(ListItem lt in lbx_search.Items)
{
string [] searcharr = new string[2];
searcharr = lt.Value.Split(':');
switch(searcharr[0].Trim())
{
case "������Ա����":
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]);
tmp = "UDS_CM_ClientContact.MarketmanID='";
while(dr_staffid.Read())
{
tmp += dr_staffid["staff_id"] + "' or UDS_CM_ClientContact.MarketmanID='";
}
dr_staffid.Close();
if(tmp=="UDS_CM_ContactInfo.MarketmanID='")
searchstring = "1=2";
else
{
tmp = tmp.Substring(0,tmp.Length-37);
searchstring += "(" + tmp + ") and ";
}
break;
case "�ͻ�����":
UDS.Components.CM cm = new UDS.Components.CM();
SqlDataReader dr_clientid = cm.GetClientIDByName(searcharr[1]);
tmp = "UDS_CM_ClientContact.ClientID='";
while(dr_clientid.Read())
{
tmp += dr_clientid["ID"] + "' or UDS_CM_ClientContact.ClientID='";
}
dr_clientid.Close();
if(tmp=="UDS_CM_ClientContact.ClientID='")
searchstring = "1=2";
else
{
tmp = tmp.Substring(0,tmp.Length-34);
searchstring += "(" + tmp + ") and ";
}
break;
case "�ͻ����":
searchstring += "UDS_CM_ClientContact.ClientID=" + searcharr[1] + " and ";
break;
case "���۽�":
switch(searcharr[1])
{
case "����":
searchstring += "patindex('%trace%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "���":
searchstring += "patindex('%boot%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "��Ʒ�Ƽ�":
searchstring += "patindex('%commend%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "������":
searchstring += "patindex('%requirement%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "�����ύ":
searchstring += "patindex('%submit%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "����̸��":
searchstring += "patindex('%negotiate%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "��Ŀʵʩ":
searchstring += "patindex('%actualize%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "���ٷ���":
searchstring += "patindex('%traceservice%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "���":
searchstring += "patindex('%last%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
}
break;
case "�ɽ�Ԥ��":
searchstring += "UDS_CM_ClientContact.BargainPrognosis='" + searcharr[1] + "' and ";
break;
case "�ѽ�Ǣ����":
searchstring += "UDS_CM_ClientContact.ContactTimes=" + searcharr[1] + " and ";
break;
case "��Ǣ����ְ��":
searchstring += "UDS_CM_Linkman.[Position]='" + searcharr[1] + "' and ";
break;
case "�״ν�Ǣʱ��":
searchstring += "UDS_CM_ClientInfo.FirstContactTime='" + searcharr[1] + "' and ";
break;
case "���һ�ν�Ǣʱ��":
searchstring += "UDS_CM_ClientInfo.ContactTime='" + searcharr[1] + "' and ";
break;
case "�´�Լ��ʱ��":
searchstring += "UDS_CM_ClientInfo.NextContactTime='" + searcharr[1] + "' and ";
break;
case "����������¼":
//�õ�������ʼ��(��һ -- ����)
begintime = DateTime.Now;
switch((int)DateTime.Now.DayOfWeek)
{
case 0:
begintime = begintime.AddDays(-6);
break;
default:
begintime = begintime.AddDays(1-(int)DateTime.Now.DayOfWeek);
break;
}
searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
case "����������¼":
//�õ�������ʼ��
begintime = DateTime.Now;
begintime = begintime.AddDays(1-DateTime.Now.Day);
searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
}
}
searchstring = "select * from UDS_CM_ClientInfo where ID IN (select UDS_CM_ClientInfo.ID from UDS_CM_ClientContact left join UDS_CM_ClientContact_Linkman ON UDS_CM_ClientContact.ID=UDS_CM_ClientContact_Linkman.ContactID left join UDS_CM_Linkman ON UDS_CM_ClientContact_Linkman.LinkmanID=UDS_CM_ClientContact_Linkman.id,UDS_CM_ClientInfo where UDS_CM_ClientContact.clientid=UDS_CM_ClientInfo.id and " + searchstring;
if(searchstring.EndsWith("and "))
{
searchstring = searchstring.Substring(0,searchstring.Length-4);
}
searchstring += " group by UDS_CM_ClientInfo.ID)";
DataSet ds = new DataSet();
UDS.Components.Staff staff1 = new UDS.Components.Staff();
SqlDataReader dr_Staff = staff1.GetAllStaffs();
DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff);
dt_Staff.TableName = "Staff";
ds.Tables.Add(dt_Staff);
UDS.Components.Database db = new UDS.Components.Database();
SqlParameter[] prams = {
db.MakeInParam("@SQL",SqlDbType.NText,5000,searchstring)
};
SqlDataReader dr = null;
db.RunProc("sp_RunSql",prams,out dr);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
dt.TableName = "Client";
ds.Tables.Add(dt);
ltl_Client.Text = dt.Rows.Count.ToString();
ds.Relations.Add("ClientAddMan_Staff",ds.Tables["Client"].Columns["AddManID"],ds.Tables["Staff"].Columns["Staff_ID"],false);
dgrd_ContactList.DataSource = dt.DefaultView;
dgrd_ContactList.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 btn_OK_Click(object sender, System.EventArgs e)
{
string searchbound = "";
searchstring = "";
UDS.Components.Staff mysubordinate = new UDS.Components.Staff();
SqlDataReader dr_mysubordinate = mysubordinate.GetStaffFromPosition(Server.UrlDecode(Request.Cookies["UserName"].Value), 2, 2);
try
{
switch (ddl_SearchBound.SelectedValue)
{
//��ѯ����ͱ���
case "1":
//���¼���Ա
while (dr_mysubordinate.Read())
{
searchbound += "'" + dr_mysubordinate["Staff_ID"].ToString() + "',";
}
dr_mysubordinate.Close();
searchbound += "'" + Request.Cookies["UserID"].Value + "'";
break;
//��ѯ����
case "2":
searchbound += "'" + Request.Cookies["UserID"].Value + "'";
break;
//��ѯ����
case "3":
while (dr_mysubordinate.Read())
{
searchbound += "'" + dr_mysubordinate["Staff_ID"].ToString() + "',";
}
dr_mysubordinate.Close();
searchbound = (searchbound == "") ? "" : searchbound.Substring(0, searchbound.Length - 1);
break;
}
}
finally
{ dr_mysubordinate.Close();
dr_mysubordinate.Dispose();}
#region ���ݲ�ѯ����������ѯ���
if(lbx_search.Items.Count>0)
{
DateTime begintime = new DateTime();
DateTime endtime = DateTime.Now;
foreach(ListItem lt in lbx_search.Items)
{
string [] searcharr = new string[2];
searcharr = lt.Value.Split(':');
switch(searcharr[0].Trim())
{
case "�ͻ�����":
searchstring += "UDS_CM_ClientInfo.name like '%" + searcharr[1] + "%' and ";
break;
case "�ͻ�����":
switch(searcharr[1])
{
case "�ն��û�":
searchstring += "patindex('%terminal%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
case "������":
searchstring += "patindex('%channal%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
case "����ϵ":
searchstring += "patindex('%social%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
case "ý�幫��":
searchstring += "patindex('%media%',UDS_CM_ClientInfo.type)>0" + " and ";
break;
}
break;
case "������ҵ":
switch(searcharr[1])
{
case "���ز�":
searchstring += "patindex('%realty%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "IT":
searchstring += "patindex('%IT%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "��ҵó��":
searchstring += "patindex('%business%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "����":
searchstring += "patindex('%telecom%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "����ͨѶ":
searchstring += "patindex('%post%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "��ѯ����":
searchstring += "patindex('%refer%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "����ҵ":
searchstring += "patindex('%travel%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "��ͨ����":
searchstring += "patindex('%bus%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "����֤ȯ":
searchstring += "patindex('%stock%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "����":
searchstring += "patindex('%insurance%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "˰��":
searchstring += "patindex('%tax%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "����ҵ":
searchstring += "patindex('%make%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "�ҵ�":
searchstring += "patindex('%he%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "��װ":
searchstring += "patindex('%clothe%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "ʳƷ":
searchstring += "patindex('%food%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "ҽҩ":
searchstring += "patindex('%medicine%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "��е":
searchstring += "patindex('%mechanism%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
case "��������":
searchstring += "patindex('%auto%',UDS_CM_ClientInfo.Calling)>0" + " and ";
break;
}
break;
case "��ҵ����":
switch(searcharr[1])
{
case "����":
searchstring += "patindex('%government%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "��Ӫ":
searchstring += "patindex('%contry%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "��Ӫ":
searchstring += "patindex('%privateowned%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "����":
searchstring += "patindex('%oversea%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
case "���й�˾":
searchstring += "patindex('%stock%',UDS_CM_ClientInfo.CompanyProperty)>0" + " and ";
break;
}
break;
case "�ͻ���Դ":
switch(searcharr[1])
{
case "����������ϵ":
searchstring += "patindex('%sellman%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
case "��ǰ��ʶ":
searchstring += "patindex('%familiar%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
case "���˽���":
searchstring += "patindex('%introduce%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
case "�ͻ�������ϵ":
searchstring += "patindex('%client%',UDS_CM_ClientInfo.Customer)>0" + " and ";
break;
}
break;
case "�ͻ����":
searchstring += "UDS_CM_ClientInfo.id='" + searcharr[1] + "' and ";
break;
case "��ϵ��":
//searchstring_linkman = "select * from UDS_CM_ClientInfo,UDS_CM_Linkman where UDS_CM_ClientInfo.id=UDS_CM_Linkman.clientid and UDS_CM_Linkman.name='" + searcharr[1] + "'" + " and ";
searchstring += "UDS_CM_Linkman.name='" + searcharr[1] + "' and ";
break;
case "�绰":
searchstring += "UDS_CM_ClientInfo.telephone='" + searcharr[1] + "' and ";
break;
case "������Ա":
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]);
string tmp = "UDS_CM_ClientInfo.addmanid='";
while(dr_staffid.Read())
{
tmp += dr_staffid["staff_id"] + "' or UDS_CM_ClientInfo.addmanid='";
}
dr_staffid.Close();
if(tmp=="UDS_CM_ClientInfo.addmanid='")
searchstring = "1=2";
else
{
tmp = tmp.Substring(0,tmp.Length-32);
searchstring += "(" + tmp + ") and ";
}
break;
case "�������":
searchstring += "datediff(d,UDS_CM_ClientInfo.birthday,'" + searcharr[1] + "')=0 and ";
break;
case "���������ͻ�":
//�õ�������ʼ��(��һ -- ����)
begintime = DateTime.Now;
switch((int)DateTime.Now.DayOfWeek)
{
case 0:
begintime = begintime.AddDays(-6);
break;
default:
begintime = begintime.AddDays(1-(int)DateTime.Now.DayOfWeek);
break;
}
searchstring += "(UDS_CM_ClientInfo.birthday between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
case "���������ͻ�":
//�õ�������ʼ��
begintime = DateTime.Now;
begintime = begintime.AddDays(1-DateTime.Now.Day);
searchstring += "(UDS_CM_ClientInfo.birthday between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
}
}
searchstring = "select UDS_CM_ClientInfo.*,UDS_CM_Linkman.Name AS Linkman from UDS_CM_ClientInfo left join UDS_CM_Linkman on UDS_CM_Linkman.clientid=UDS_CM_ClientInfo.id and UDS_CM_Linkman.ID=UDS_CM_ClientInfo.ChiefLinkmanID where " + searchstring;
// if(searchstring.EndsWith("and "))
// {
// searchstring = searchstring.Substring(0,searchstring.Length-4);
// }
#endregion
searchstring += "UDS_CM_ClientInfo.AddmanID IN (" + searchbound + ")";
ViewState["searchstring"] = searchstring;
// Response.Write(searchstring);
// Response.End();
Bind();
//Response.Write(searchstring);
}
}
private void cmdSubmit_Click(object sender, System.EventArgs e)
{
if(rb_male.Checked==true)
sex =1;
else
sex =0;
if(EditStatus ==0)
{
UDS.Components.Database db = new UDS.Components.Database();
SqlDataReader dr;
if(mydepartment.Visible==true)
DeptID = cboDepartment.Items[cboDepartment.SelectedIndex].Value.ToString();
SqlParameter[] prams = {
db.MakeInParam("@StaffName",SqlDbType.VarChar,300,txtStaffName.Text),
db.MakeInParam("@Password",SqlDbType.VarChar,300,txtPassword.Text ),
db.MakeInParam("@RealName",SqlDbType.VarChar,300,txtRealName.Text),
db.MakeInParam("@Sex",SqlDbType.Int,4,sex),
db.MakeInParam("@Status",SqlDbType.Int,4,0),
db.MakeInParam("@Email",SqlDbType.VarChar,300,txtEmail.Text),
db.MakeInParam("@RegistedDate",SqlDbType.DateTime,8,DateTime.Now.ToString()),
db.MakeInParam("@DeptID",SqlDbType.Int,4,Int32.Parse(DeptID)),
db.MakeInParam("@Phone",SqlDbType.VarChar,50,txtPhone.Text),
db.MakeInParam("@Mobile",SqlDbType.VarChar,50,txtMobile.Text),
db.MakeInParam("@Birthday",SqlDbType.DateTime,8,(txtBirthday.Text.Trim()=="")?"1900-1-1":txtBirthday.Text)
};
db.RunProc("sp_AddStaff",prams,out dr);
if(dr.Read())
if(ReturnPage==0)
Response.Redirect("ListView.aspx?Dep_ID="+DeptID);
else
Response.Redirect("../Staff/ManageStaff.aspx");
else
message.Text = "���û��Ѿ����ڣ�";
}
else
{
UDS.Components.Staff person = new UDS.Components.Staff();
switch(person.UpdateInfo(StaffID,txtRealName.Text,sex,txtBirthday.Text,txtPassword.Text,txtEmail.Text,txtPhone.Text,txtMobile.Text,Int32.Parse(cboDepartment.Items[cboDepartment.SelectedIndex].Value )))
{
case 0:
message.Text = "�ijɹ���";
break;
case -1:
message.Text = "��֤���벻�ԣ�";
break;
default:
break;
}
}
}
private void btn_OK_Click(object sender, System.EventArgs e)
{
if (lbx_search.Items.Count > 0)
{
string searchstring = "";
string tmp = "";
DateTime begintime = new DateTime();
DateTime endtime = DateTime.Now;
foreach (ListItem lt in lbx_search.Items)
{
string [] searcharr = new string[2];
searcharr = lt.Value.Split(':');
switch (searcharr[0].Trim())
{
case "销售人员姓名":
UDS.Components.Staff staff = new UDS.Components.Staff();
SqlDataReader dr_staffid = staff.GetStaffIDByRealName(searcharr[1]);
tmp = "UDS_CM_ClientContact.MarketmanID='";
while (dr_staffid.Read())
{
tmp += dr_staffid["staff_id"] + "' or UDS_CM_ClientContact.MarketmanID='";
}
dr_staffid.Close();
if (tmp == "UDS_CM_ContactInfo.MarketmanID='")
{
searchstring = "1=2";
}
else
{
tmp = tmp.Substring(0, tmp.Length - 37);
searchstring += "(" + tmp + ") and ";
}
break;
case "客户名称":
UDS.Components.CM cm = new UDS.Components.CM();
SqlDataReader dr_clientid = cm.GetClientIDByName(searcharr[1]);
tmp = "UDS_CM_ClientContact.ClientID='";
while (dr_clientid.Read())
{
tmp += dr_clientid["ID"] + "' or UDS_CM_ClientContact.ClientID='";
}
dr_clientid.Close();
if (tmp == "UDS_CM_ClientContact.ClientID='")
{
searchstring = "1=2";
}
else
{
tmp = tmp.Substring(0, tmp.Length - 34);
searchstring += "(" + tmp + ") and ";
}
break;
case "客户编号":
searchstring += "UDS_CM_ClientContact.ClientID=" + searcharr[1] + " and ";
break;
case "销售阶段":
switch (searcharr[1])
{
case "跟踪":
searchstring += "patindex('%trace%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "启动":
searchstring += "patindex('%boot%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "产品推荐":
searchstring += "patindex('%commend%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "需求定义":
searchstring += "patindex('%requirement%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "方案提交":
searchstring += "patindex('%submit%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "商务谈判":
searchstring += "patindex('%negotiate%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "项目实施":
searchstring += "patindex('%actualize%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "跟踪服务":
searchstring += "patindex('%traceservice%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
case "收尾款":
searchstring += "patindex('%last%',UDS_CM_ClientContact.curstatus)>=0" + " and ";
break;
}
break;
case "成交预估":
searchstring += "UDS_CM_ClientContact.BargainPrognosis='" + searcharr[1] + "' and ";
break;
case "已接洽次数":
searchstring += "UDS_CM_ClientContact.ContactTimes=" + searcharr[1] + " and ";
break;
case "接洽对象职务":
searchstring += "UDS_CM_Linkman.[Position]='" + searcharr[1] + "' and ";
break;
case "首次接洽时间":
searchstring += "UDS_CM_ClientInfo.FirstContactTime='" + searcharr[1] + "' and ";
break;
case "最后一次接洽时间":
searchstring += "UDS_CM_ClientInfo.ContactTime='" + searcharr[1] + "' and ";
break;
case "下次约见时间":
searchstring += "UDS_CM_ClientInfo.NextContactTime='" + searcharr[1] + "' and ";
break;
case "本周新增记录":
//得到本周起始日(周一 -- 周日)
begintime = DateTime.Now;
switch ((int)DateTime.Now.DayOfWeek)
{
case 0:
begintime = begintime.AddDays(-6);
break;
default:
begintime = begintime.AddDays(1 - (int)DateTime.Now.DayOfWeek);
break;
}
searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
case "本月新增记录":
//得到本月起始日
begintime = DateTime.Now;
begintime = begintime.AddDays(1 - DateTime.Now.Day);
searchstring += "(UDS_CM_ClientContact.updatetime between '" + begintime.ToShortDateString() + "' and '" + endtime.ToShortDateString() + "') and ";
break;
}
}
searchstring = "select * from UDS_CM_ClientInfo where ID IN (select UDS_CM_ClientInfo.ID from UDS_CM_ClientContact left join UDS_CM_ClientContact_Linkman ON UDS_CM_ClientContact.ID=UDS_CM_ClientContact_Linkman.ContactID left join UDS_CM_Linkman ON UDS_CM_ClientContact_Linkman.LinkmanID=UDS_CM_ClientContact_Linkman.id,UDS_CM_ClientInfo where UDS_CM_ClientContact.clientid=UDS_CM_ClientInfo.id and " + searchstring;
if (searchstring.EndsWith("and "))
{
searchstring = searchstring.Substring(0, searchstring.Length - 4);
}
searchstring += " group by UDS_CM_ClientInfo.ID)";
DataSet ds = new DataSet();
UDS.Components.Staff staff1 = new UDS.Components.Staff();
SqlDataReader dr_Staff = staff1.GetAllStaffs();
DataTable dt_Staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_Staff);
dt_Staff.TableName = "Staff";
ds.Tables.Add(dt_Staff);
UDS.Components.Database db = new UDS.Components.Database();
SqlParameter[] prams =
{
db.MakeInParam("@SQL", SqlDbType.NText, 5000, searchstring)
};
SqlDataReader dr = null;
db.RunProc("sp_RunSql", prams, out dr);
DataTable dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
dt.TableName = "Client";
ds.Tables.Add(dt);
ltl_Client.Text = dt.Rows.Count.ToString();
ds.Relations.Add("ClientAddMan_Staff", ds.Tables["Client"].Columns["AddManID"], ds.Tables["Staff"].Columns["Staff_ID"], false);
dgrd_ContactList.DataSource = dt.DefaultView;
dgrd_ContactList.DataBind();
}
}
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 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 GetStaffInfo(long StaffID)
{
SqlDataReader dr;
UDS.Components.Staff person = new UDS.Components.Staff();
dr = person.GetStaffInfo(StaffID);
txtPassword.TextMode = System.Web.UI.WebControls.TextBoxMode.SingleLine;
txtRePassword.TextMode = System.Web.UI.WebControls.TextBoxMode.SingleLine;
if(dr.Read ())
{
txtStaffName.Text = dr["Staff_Name"].ToString();
txtStaffName.ReadOnly =true;
txtRealName.Text = dr["RealName"].ToString();
if(dr["Sex"].ToString() =="True")
{
rb_male.Checked =true;
sex =1;
}
else
{
rb_female.Checked =true;
sex = 0;
}
txtBirthday.Text = dr["Birthday"].ToString().IndexOf(" ")>0?dr["Birthday"].ToString().Substring(0,dr["Birthday"].ToString().IndexOf(" ")):dr["Birthday"].ToString() ;
if( txtBirthday.Text =="")
txtBirthday.Text = DateTime.Now.ToShortDateString();
txtPassword.Text = dr["Password"].ToString();
txtRePassword.Text = dr["Password"].ToString();
txtEmail.Text = dr["Email"].ToString();
txtPhone.Text =dr["Phone"].ToString();
txtMobile.Text = dr["Mobile"].ToString();
SelectDepartment(Int32.Parse(dr["Department_ID"].ToString()));
}
person = null;
dr.Close();
dr =null;
}
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 cmdSubmit_Click(object sender, System.EventArgs e)
{
if (rb_male.Checked == true)
{
sex = 1;
}
else
{
sex = 0;
}
if (EditStatus == 0)
{
UDS.Components.Database db = new UDS.Components.Database();
SqlDataReader dr;
if (mydepartment.Visible == true)
{
DeptID = cboDepartment.Items[cboDepartment.SelectedIndex].Value.ToString();
}
SqlParameter[] prams =
{
db.MakeInParam("@StaffName", SqlDbType.VarChar, 300, txtStaffName.Text),
db.MakeInParam("@Password", SqlDbType.VarChar, 300, txtPassword.Text),
db.MakeInParam("@RealName", SqlDbType.VarChar, 300, txtRealName.Text),
db.MakeInParam("@Sex", SqlDbType.Int, 4, sex),
db.MakeInParam("@Status", SqlDbType.Int, 4, 0),
db.MakeInParam("@Email", SqlDbType.VarChar, 300, txtEmail.Text),
db.MakeInParam("@RegistedDate", SqlDbType.DateTime, 8, DateTime.Now.ToString()),
db.MakeInParam("@DeptID", SqlDbType.Int, 4, Int32.Parse(DeptID)),
db.MakeInParam("@Phone", SqlDbType.VarChar, 50, txtPhone.Text),
db.MakeInParam("@Mobile", SqlDbType.VarChar, 50, txtMobile.Text),
db.MakeInParam("@Birthday", SqlDbType.DateTime, 8, (txtBirthday.Text.Trim() == "")?"1900-1-1":txtBirthday.Text)
};
db.RunProc("sp_AddStaff", prams, out dr);
if (dr.Read())
{
if (ReturnPage == 0)
{
Response.Redirect("ListView.aspx?Dep_ID=" + DeptID);
}
else
{
Response.Redirect("../Staff/ManageStaff.aspx");
}
}
else
{
message.Text = "该用户已经存在！";
}
}
else
{
UDS.Components.Staff person = new UDS.Components.Staff();
switch (person.UpdateInfo(StaffID, txtRealName.Text, sex, txtBirthday.Text, txtPassword.Text, txtEmail.Text, txtPhone.Text, txtMobile.Text, Int32.Parse(cboDepartment.Items[cboDepartment.SelectedIndex].Value)))
{
case 0:
message.Text = "修改成功！";
break;
case -1:
message.Text = "验证密码不对！";
break;
default:
break;
}
}
}
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 Page_Load(object sender, System.EventArgs e)
{
ds = new StaffDataSet();
DataTable dt = (DataTable)Cache["StaffList"];
if (!Page.IsPostBack)
{
staffname = Session["staffname"].ToString();
positionid = Int32.Parse(Session["positionid"].ToString());
mobile = Session["mobile"].ToString();
email = Session["email"].ToString();
gender = Session["gender"].ToString();
bound = Session["bound"].ToString();
displayfields = (string[])Session["displayfieldsname"];
ViewState["staffname"] = staffname;
ViewState["positionid"] = positionid.ToString();
ViewState["mobile"] = mobile.ToString();
ViewState["email"] = email.ToString();
ViewState["gender"] = gender.ToString();
ViewState["bound"] = bound.ToString();
ViewState["displayfields"] = displayfields;
Session["staffname"] = null;
Session["positionid"] = null;
Session["mobile"] = null;
Session["gender"] = null;
Session["displayfieldsname"] = null;
Session["bound"] = null;
}
else
{
staffname = ViewState["staffname"].ToString();
positionid = Int32.Parse(ViewState["positionid"].ToString());
mobile = ViewState["mobile"].ToString();
email = ViewState["email"].ToString();
gender = ViewState["gender"].ToString();
bound = ViewState["bound"].ToString();
displayfields = (string[])ViewState["displayfields"];
}
if (dt == null)
{
//得不到缓存的内容，重新获取
SqlDataReader dr;
UDS.Components.Staff staff = new UDS.Components.Staff();
dr = staff.Find(staffname, positionid, mobile, email, gender, bound);
dt = UDS.Components.Tools.ConvertDataReaderToDataTable(dr);
Cache["StaffList"] = dt;
}
//添加datatable中的数据
foreach (DataRow row in dt.Rows)
{
DataRow staffviewrow = ds.StaffView.NewRow();
staffviewrow["Staff_Name"] = row["Staff_Name"].ToString();
staffviewrow["RealName"] = row["RealName"].ToString();
staffviewrow["Mobile"] = row["Mobile"].ToString();
staffviewrow["SexName"] = row["SexName"].ToString();
staffviewrow["Email"] = row["Email"].ToString();
staffviewrow["Position_Name"] = row["Position_Name"].ToString();
ds.StaffView.AddStaffViewRow((StaffDataSet.StaffViewRow)staffviewrow);
}
stafflistreport = new StaffList();
stafflistreport.SetDataSource(ds);
crv_StaffList.ReportSource = stafflistreport;
//根据用户选择隐藏字段
foreach (string fieldname in displayfields)
{
stafflistreport.ReportDefinition.ReportObjects["ttl" + fieldname].ObjectFormat.EnableSuppress = false;
stafflistreport.ReportDefinition.ReportObjects[fieldname].ObjectFormat.EnableSuppress = false;
}
crv_StaffList.DataBind();
}
