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