//调职通知 private void sms_all() { SqlDataReader dr_this; //被选择人员 UDS.Components.Staff sta = new UDS.Components.Staff(); dr_this = sta.GetStaffInfo(selectedID); SMS sm = new SMS(); //处理短信提醒 while (dr_this.Read()) { string Position_name = dr_this["Position_name"].ToString(); SqlDataReader dr_isok; //所有在职人员 dr_isok = sta.GetAllStaffs(); while (dr_isok.Read()) { string Staff_name = dr_isok["Staff_name"].ToString(); sm.SendMsg(Username, Staff_name, Position_name + "处员工:" + dr_this["RealName"].ToString() + ",已经调职到" + cboPosition.Items[cboPosition.SelectedIndex].Text + "处,特此通知.", 1, DateTime.Now, "", 0, 0); } dr_isok.Close(); dr_isok = null; } sm = null; dr_this.Close(); dr_this = null; }
private void sms_all(int i) { SqlDataReader dr_this; //被选择人员 UDS.Components.Staff sta = new UDS.Components.Staff(); dr_this = sta.GetStaffInfo(selectedID); SMS sm = new SMS(); //处理短信提醒 while (dr_this.Read()) { string Position_name = dr_this["Position_name"].ToString(); SqlDataReader dr_isok; //所有在职人员 dr_isok = sta.GetAllStaffs(); while (dr_isok.Read()) { string Staff_name = dr_isok["Staff_name"].ToString(); if (i == 0) { sm.SendMsg(Username, Staff_name, Position_name + " 处员工:" + dr_this["RealName"].ToString() + ",已经离职,特此通知.", 1, DateTime.Now, "", 0, 0); } else { sm.SendMsg(Username, dr_isok["Staff_name"].ToString(), dr_this["Position_name"].ToString() + " 处员工:" + dr_this["RealName"].ToString() + ",已经恢复原职,特此通知.", 1, DateTime.Now, "", 0, 0); } } dr_isok.Close(); dr_isok = null; } sm = null; dr_this.Close(); dr_this = null; }
private void btn_LookTel_Click(object sender, System.EventArgs e) { ltl_addmantel.Visible = true; UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetStaffInfo(Int32.Parse(ddl_AddMan.SelectedItem.Value)); while (dr_staff.Read()) { ltl_addmantel.Text = dr_staff["Mobile"].ToString(); } dr_staff.Close(); }
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; } //修改于2003-10-8日 目的:改正生日103岁问题 // if( txtBirthday.Text =="") // txtBirthday.Text = DateTime.Now.ToShortDateString(); // txtBirthday.Text = dr["Birthday"].ToString().IndexOf(" ")>0?dr["Birthday"].ToString().Substring(0,dr["Birthday"].ToString().IndexOf(" ")):dr["Birthday"].ToString() ; txtBirthday.Text = ((dr["Birthday"] == DBNull.Value) || (DateTime.Parse(dr["Birthday"].ToString()).Date == DateTime.Parse("1900-1-1").Date))?"-":DateTime.Parse(dr["Birthday"].ToString()).ToLongDateString(); 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(); txtCaste.Text = dr["Caste"].ToString(); PositionID = dr["Position_ID"].ToString(); SelectPosition(Int32.Parse(dr["Position_ID"].ToString())); } person = null; dr.Close(); dr = null; }
//绑定添加人下拉菜单 private void BindAddManList() { UDS.Components.Staff staff = new UDS.Components.Staff(); ddl_AddMan.DataSource = staff.GetStaffFromPosition(Request.Cookies["Username"].Value, 2, 3); ddl_AddMan.DataTextField = "realname"; ddl_AddMan.DataValueField = "staff_id"; ddl_AddMan.DataBind(); SqlDataReader dr_staff = staff.GetStaffInfo(long.Parse(Request.Cookies["UserID"].Value)); string myrealname = ""; while (dr_staff.Read()) { myrealname = dr_staff["realname"].ToString(); } dr_staff.Close(); ddl_AddMan.Items.Add(new ListItem(myrealname, Request.Cookies["UserID"].Value)); }
private void Page_Load(object sender, System.EventArgs e) { // �ڴ˴������û������Գ�ʼ��ҳ�� UDS.Components.CM cm = new UDS.Components.CM(); SqlDataReader dr = null; if(!Page.IsPostBack) { tbx_contacttime.Text = DateTime.Now.ToShortDateString(); tbx_nextcontacttime.Text = DateTime.Now.AddDays(1).ToShortDateString(); clientid = Int32.Parse((Request.QueryString["ClientID"]==null)||(Request.QueryString["ClientID"]=="")?"-1":Request.QueryString["ClientID"].ToString()); pnl_clientselect.Visible = true; //�ͻ��б� dr = cm.GetMyClients(Int32.Parse(Request.Cookies["UserID"].Value)); ddl_ClientName.DataSource = dr; ddl_ClientName.DataValueField = "id"; ddl_ClientName.DataTextField = "name"; ddl_ClientName.DataBind(); dr.Close(); if(clientid!=-1) { if(ddl_ClientName.Items.Count!=0) { foreach(ListItem li in ddl_ClientName.Items) { if(li.Value==clientid.ToString()) { li.Selected = true; } else { li.Selected = false; } } ViewState["ClientID"] = clientid; } //��ʾ������Ա UDS.Components.ClientInfo client = cm.GetClientAllInfo(clientid); 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(); } else { if(ddl_ClientName.Items.Count!=0) { clientid = Int32.Parse(ddl_ClientName.Items[0].Value); ViewState["ClientID"] = clientid; } else { ViewState["ClientID"] = clientid; } } DisplayClientInfo(); BindData(); ViewState["ContactID"] = contactid.ToString(); } else { clientid = Int32.Parse(ViewState["ClientID"].ToString()); contactid = Int32.Parse(ViewState["ContactID"].ToString()); } //tbx_contacttime.Attributes["onfocus"] = "setday(this)"; //tbx_nextcontacttime.Attributes["onfocus"] = "setday(this)"; }
private void Page_Load(object sender, System.EventArgs e) { UDS.Components.CM cm = new UDS.Components.CM(); if (!Page.IsPostBack) { tbx_UpdateTime.Text = DateTime.Now.ToShortDateString(); //得到添加人的信息 UDS.Components.Staff staff = new UDS.Components.Staff(); #region 显示客户原有信息 UDS.Components.ClientInfo client = cm.GetClientAllInfo((Request.QueryString["ClientID"] == null)?0:Int32.Parse(Request.QueryString["ClientID"].ToString())); ViewState["ClientID"] = client.ID; clientid = client.ID; /* 权限判断 * 如果是上级则出现下拉菜单,并可重新指定客户经理 * 其它则无下拉菜单 */ if (Session["cm_permission"].ToString() == "leader") { //绑定下拉列表 pnl_Leader.Visible = true; ltl_AddManName.Visible = ltl_addmantel.Visible = false; //不出现修改按钮 pnl_MyCustom.Visible = false; pnl_Leader1.Visible = true; BindAddManList(); //添加人默认选中 ddl_AddMan.Items.FindByValue(client.AddManID.ToString()).Selected = true; } else { pnl_Leader.Visible = false; ltl_AddManName.Visible = ltl_addmantel.Visible = true; SqlDataReader dr_staff = null; if (client.ID != 0) { dr_staff = staff.GetStaffInfo(client.AddManID); while (dr_staff.Read()) { ltl_AddManName.Text = dr_staff["realname"].ToString(); ltl_addmantel.Text = dr_staff["Mobile"].ToString(); } } else { dr_staff = staff.GetStaffInfo(Int32.Parse(Request.Cookies["UserID"].Value)); while (dr_staff.Read()) { ltl_AddManName.Text = dr_staff["realname"].ToString(); ltl_addmantel.Text = dr_staff["Mobile"].ToString(); } } dr_staff.Close(); } ltl_ID.Text = (client.ID.ToString() == "0")?"":client.ID.ToString(); tbx_ShortName.Text = client.ClientShortName; tbx_Name.Text = client.ClientName; if (clientid != 0) { tbx_Birthday.Text = client.Birthday.ToShortDateString(); } else { tbx_Birthday.Text = DateTime.Now.ToShortDateString(); } if (client.ClientType.IndexOf(ClientType.terminal.ToString()) >= 0) { cbx_zhongduan.Checked = true; } if (client.ClientType.IndexOf(ClientType.channal.ToString()) >= 0) { cbx_qudao.Checked = true; } if (client.ClientType.IndexOf(ClientType.social.ToString()) >= 0) { cbx_shehui.Checked = true; } if (client.ClientType.IndexOf(ClientType.media.ToString()) >= 0) { cbx_meiti.Checked = true; } //得到主要联系人的信息 SqlDataReader dr_chief = cm.GetLinkmanByID(client.ChiefLinkmanID.ToString()); while (dr_chief.Read()) { if (Session["cm_permission"].ToString() == "administrator") { hlk_Chiefman.Text = dr_chief["name"].ToString(); hlk_Chiefman.NavigateUrl = "Linkman.aspx?LinkmanID=" + dr_chief["id"].ToString(); hlk_Chiefman.Target = "_blank"; } else { hlk_Chiefman.Text = dr_chief["name"].ToString(); } lbl_position.Text = dr_chief["position"].ToString(); lbl_chieftel.Text = dr_chief["telephone"].ToString(); } dr_chief.Close(); tbx_affiliatedarea.Text = client.Affiliatedarea; tbx_URL.Text = client.URL; tbx_zip.Text = client.ZIP; tbx_address.Text = client.Address; if (client.CompanyProperty.IndexOf(EnterpriseType.government.ToString()) >= 0) { cbx_government.Checked = true; } if (client.CompanyProperty.IndexOf(EnterpriseType.contry.ToString()) >= 0) { cbx_stateowned.Checked = true; } if (client.CompanyProperty.IndexOf(EnterpriseType.privateowned.ToString()) >= 0) { cbx_private.Checked = true; } if (client.CompanyProperty.IndexOf(EnterpriseType.oversea.ToString()) >= 0) { cbx_foreign.Checked = true; } if (client.CompanyProperty.IndexOf(EnterpriseType.stock.ToString()) >= 0) { cbx_market.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.realty.ToString()) >= 0) { cbx_realestate.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.IT.ToString()) >= 0) { cbx_IT.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.business.ToString()) >= 0) { cbx_business.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.telecom.ToString()) >= 0) { cbx_telecom.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.post.ToString()) >= 0) { cbx_post.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.refer.ToString()) >= 0) { cbx_consultation.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.travel.ToString()) >= 0) { cbx_travel.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.bus.ToString()) >= 0) { cbx_bus.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.stock.ToString()) >= 0) { cbx_stock.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.insurance.ToString()) >= 0) { cbx_insurance.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.tax.ToString()) >= 0) { cbx_tax.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.make.ToString()) >= 0) { cbx_make.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.he.ToString()) >= 0) { cbx_electric.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.clothe.ToString()) >= 0) { cbx_clothe.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.food.ToString()) >= 0) { cbx_food.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.medicine.ToString()) >= 0) { cbx_medicine.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.mechanism.ToString()) >= 0) { cbx_mechanism.Checked = true; } if (client.ClientTrade.IndexOf(ClientTrade.auto.ToString()) >= 0) { cbx_auto.Checked = true; } tbx_staffnumber.Text = client.CompanySize; tbx_money.Text = client.Money; tbx_operation.Text = client.Operation; tbx_introduce.Text = client.Introduce; tbx_IT.Text = client.ITGrade; tbx_pcnumber.Text = client.PCNumber.ToString(); if (client.Net.IndexOf(ClientNet.LAN.ToString()) >= 0) { cbx_LAN.Checked = true; } if (client.Net.IndexOf(ClientNet.WAN.ToString()) >= 0) { cbx_WAN.Checked = true; } if (client.Net.IndexOf(ClientNet.INTERNET.ToString()) >= 0) { cbx_internet.Checked = true; } tbx_ITStaffs.Text = client.ITStaffs.ToString(); tbx_ITdepartment.Text = client.ITDepartment; tbx_principal.Text = client.Principal; tbx_system.Text = client.System; if (client.ClientSource.IndexOf(ClientSource.sellman.ToString()) >= 0) { cbx_sellman.Checked = true; } if (client.ClientSource.IndexOf(ClientSource.familiar.ToString()) >= 0) { cbx_just.Checked = true; } if (client.ClientSource.IndexOf(ClientSource.introduce.ToString()) >= 0) { cbx_introduce.Checked = true; } if (client.ClientSource.IndexOf(ClientSource.client.ToString()) >= 0) { cbx_customer.Checked = true; } if (client.ClientInitiative.IndexOf(ClientInitiative.media.ToString()) >= 0) { cbx_media.Checked = true; } if (client.ClientInitiative.IndexOf(ClientInitiative.searchweb.ToString()) >= 0) { cbx_Web.Checked = true; } if (client.ClientInitiative.IndexOf(ClientInitiative.proseminar.ToString()) >= 0) { cbx_proseminar.Checked = true; } if (client.ClientInitiative.IndexOf(ClientInitiative.exhibition.ToString()) >= 0) { cbx_exhibition.Checked = true; } if (client.ClientInitiative.IndexOf(ClientInitiative.post.ToString()) >= 0) { cbx_EMS.Checked = true; } if (client.ClientInitiative.IndexOf(ClientInitiative.email.ToString()) >= 0) { cbx_Email.Checked = true; } #endregion if (clientid == 0) { btn_OK.Text = "添加"; CustomValidator1.Enabled = true; } else { btn_OK.Text = "修改"; CustomValidator1.Enabled = false; } penal.Visible = cbx_customer.Checked; } else { clientid = Int32.Parse(ViewState["ClientID"].ToString()); //显示联系人 string tmplinkmanid1 = (Session["tmplinkmanid"] == null)?"":Session["tmplinkmanid"].ToString(); foreach (string linkmanid in tmplinkmanid1.Split(',')) { if (linkmanid.Trim() != "") { UDS.Components.Linkman linkman = new UDS.Components.Linkman(); UDS.Components.CM cm1 = new UDS.Components.CM(); linkman = cm1.GetLinkmanStructByID(linkmanid); if (Session["cm_permission"].ToString() == "administrator") { hlk_Chiefman.Text = linkman.Name; hlk_Chiefman.NavigateUrl = "Linkman.aspx?LinkmanID=" + linkman.ID; hlk_Chiefman.Target = "_blank"; } else { hlk_Chiefman.Text = linkman.Name;; } lbl_position.Text = linkman.Position; lbl_chieftel.Text = linkman.Telephone; } } } if (clientid != 0) { rpt_Attachment.DataSource = cm.GetAttachmentByClientID(clientid); rpt_Attachment.DataBind(); } if (clientid == 0) { btn_AddContact.Visible = false; } else { btn_AddContact.Visible = true; } }
private void sms_all(int i) { SqlDataReader dr_this;//��ѡ����Ա UDS.Components.Staff sta=new UDS.Components.Staff(); dr_this=sta.GetStaffInfo(selectedID); SMS sm = new SMS(); //����������� while(dr_this.Read()) { string Position_name=dr_this["Position_name"].ToString(); SqlDataReader dr_isok;//������ְ��Ա dr_isok=sta.GetAllStaffs(); while(dr_isok.Read()) { string Staff_name=dr_isok["Staff_name"].ToString(); if(i==0) sm.SendMsg(Username,Staff_name,Position_name+" ��Ա��:"+dr_this["RealName"].ToString()+",�Ѿ���ְ,�ش�֪ͨ.",1,DateTime.Now,"",0,0); else sm.SendMsg(Username,dr_isok["Staff_name"].ToString(),dr_this["Position_name"].ToString()+" ��Ա��:"+dr_this["RealName"].ToString()+",�Ѿ��ָ�ԭְ,�ش�֪ͨ.",1,DateTime.Now,"",0,0); } dr_isok.Close(); dr_isok=null; } sm = null; dr_this.Close(); dr_this=null; }
private void sms_all(int ii) { string sql = ""; //所被选择的成员ID集合 bool sqlFlag = true; foreach (DataGridItem dgi in this.dgMemberList.Items) { CheckBox cb = (CheckBox)(dgi.Cells[0].Controls[1]); if (cb.Checked == true) { int i = dgi.ItemIndex; string id = dgMemberList.DataKeys[i].ToString(); if (sqlFlag) { sql += "" + id; sqlFlag = false; } else { sql += " ,"; sql += id; } } } SqlDataReader dr_this; //被选择人员 UDS.Components.Staff sta = new UDS.Components.Staff(); dr_this = sta.GetStaffInfo(sql); SqlDataReader dr_allTeam; //所有组员 Team steam = new Team(); dr_allTeam = steam.GetStaffInTeam(Convert.ToInt32(ClassID)); SqlDataReader dr_allTeamMaster; //所有组长 ProjectClass prj = new ProjectClass(); dr_allTeamMaster = prj.GetLeader(Convert.ToInt32(ClassID)); SqlDataReader dataReader; //项目信息 dataReader = prj.GetClassInfo(Convert.ToInt32(ClassID)); string Team_name = ""; //项目名字 if (dataReader.Read()) { Team_name = dataReader[0].ToString() + ","; } dataReader.Close(); dataReader = null; string Staff_name = ""; //被选择人员名字 while (dr_this.Read()) { Staff_name += dr_this["RealName"].ToString() + ","; } dr_this.Close(); dr_this = null; string name_teamMaster = ""; //所有组长的名字 while (dr_allTeamMaster.Read()) { name_teamMaster += dr_allTeamMaster["RealName"].ToString() + ","; } dr_allTeamMaster.Close(); dr_allTeamMaster = null; SMS sm = new SMS(); //处理短信提醒 while (dr_allTeam.Read()) //i为0表示脱离组,i为1表示加入组,i为2表示成为组长 { if (ii == 0) { sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), Team_name + " 项目处员工:" + Staff_name + "已经脱离本项目,特此通知.", 1, DateTime.Now, "", 0, 0); } else if (ii == 1) { sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), "员工:" + Staff_name + "已经加入项目:" + Team_name + ",特此通知.", 1, DateTime.Now, "", 0, 0); } else if (ii == 2) { sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), Team_name + " 项目处员工:" + Staff_name + "已经替代" + name_teamMaster + ",成为项目组长,特此通知.", 1, DateTime.Now, "", 0, 0); } } sm = null; dr_allTeam.Close(); dr_allTeam = null; }
private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 UDS.Components.CM cm = new UDS.Components.CM(); SqlDataReader dr = null; if (!Page.IsPostBack) { tbx_contacttime.Text = DateTime.Now.ToShortDateString(); tbx_nextcontacttime.Text = DateTime.Now.AddDays(1).ToShortDateString(); clientid = Int32.Parse((Request.QueryString["ClientID"] == null) || (Request.QueryString["ClientID"] == "")?"-1":Request.QueryString["ClientID"].ToString()); pnl_clientselect.Visible = true; //绑定客户列表 dr = cm.GetMyClients(Int32.Parse(Request.Cookies["UserID"].Value)); ddl_ClientName.DataSource = dr; ddl_ClientName.DataValueField = "id"; ddl_ClientName.DataTextField = "name"; ddl_ClientName.DataBind(); dr.Close(); if (clientid != -1) { if (ddl_ClientName.Items.Count != 0) { foreach (ListItem li in ddl_ClientName.Items) { if (li.Value == clientid.ToString()) { li.Selected = true; } else { li.Selected = false; } } ViewState["ClientID"] = clientid; } //显示销售人员 UDS.Components.ClientInfo client = cm.GetClientAllInfo(clientid); 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(); } else { if (ddl_ClientName.Items.Count != 0) { clientid = Int32.Parse(ddl_ClientName.Items[0].Value); ViewState["ClientID"] = clientid; } else { ViewState["ClientID"] = clientid; } } DisplayClientInfo(); BindData(); ViewState["ContactID"] = contactid.ToString(); } else { clientid = Int32.Parse(ViewState["ClientID"].ToString()); contactid = Int32.Parse(ViewState["ContactID"].ToString()); } //tbx_contacttime.Attributes["onfocus"] = "setday(this)"; //tbx_nextcontacttime.Attributes["onfocus"] = "setday(this)"; }
private void Page_Load(object sender, System.EventArgs e) { UDS.Components.CM cm = new UDS.Components.CM(); if(!Page.IsPostBack) { tbx_UpdateTime.Text = DateTime.Now.ToShortDateString(); //�õ�����˵���Ϣ UDS.Components.Staff staff = new UDS.Components.Staff(); #region ��ʾ�ͻ�ԭ����Ϣ UDS.Components.ClientInfo client = cm.GetClientAllInfo((Request.QueryString["ClientID"]==null)?0:Int32.Parse(Request.QueryString["ClientID"].ToString())); ViewState["ClientID"] = client.ID; clientid = client.ID; /* Ȩ���ж� * ������ϼ�����������˵�����������ָ���ͻ����� * �������������˵� */ if(Session["cm_permission"].ToString()=="leader") { //�������б� pnl_Leader.Visible = true; ltl_AddManName.Visible = ltl_addmantel.Visible = false; //�������İ�ť pnl_MyCustom.Visible = false; pnl_Leader1.Visible = true; BindAddManList(); //�����Ĭ��ѡ�� ddl_AddMan.Items.FindByValue(client.AddManID.ToString()).Selected = true; } else { pnl_Leader.Visible = false; ltl_AddManName.Visible = ltl_addmantel.Visible = true; SqlDataReader dr_staff = null; try { if (client.ID != 0) { dr_staff = staff.GetStaffInfo(client.AddManID); while (dr_staff.Read()) { ltl_AddManName.Text = dr_staff["realname"].ToString(); ltl_addmantel.Text = dr_staff["Mobile"].ToString(); } } else { dr_staff = staff.GetStaffInfo(Int32.Parse(Request.Cookies["UserID"].Value)); while (dr_staff.Read()) { ltl_AddManName.Text = dr_staff["realname"].ToString(); ltl_addmantel.Text = dr_staff["Mobile"].ToString(); } } } finally { dr_staff.Close(); dr_staff.Dispose(); } } ltl_ID.Text = (client.ID.ToString()=="0")?"":client.ID.ToString(); tbx_ShortName.Text = client.ClientShortName; tbx_Name.Text = client.ClientName; if(clientid!=0) tbx_Birthday.Text = client.Birthday.ToShortDateString(); else tbx_Birthday.Text = DateTime.Now.ToShortDateString(); if(client.ClientType.IndexOf(ClientType.terminal.ToString())>=0) cbx_zhongduan.Checked = true; if(client.ClientType.IndexOf(ClientType.channal.ToString())>=0) cbx_qudao.Checked = true; if(client.ClientType.IndexOf(ClientType.social.ToString())>=0) cbx_shehui.Checked = true; if(client.ClientType.IndexOf(ClientType.media.ToString())>=0) cbx_meiti.Checked = true; //�õ���Ҫ��ϵ�˵���Ϣ SqlDataReader dr_chief = cm.GetLinkmanByID(client.ChiefLinkmanID.ToString()); try { while (dr_chief.Read()) { if (Session["cm_permission"].ToString() == "administrator") { hlk_Chiefman.Text = dr_chief["name"].ToString(); hlk_Chiefman.NavigateUrl = "Linkman.aspx?LinkmanID=" + dr_chief["id"].ToString(); hlk_Chiefman.Target = "_blank"; } else { hlk_Chiefman.Text = dr_chief["name"].ToString(); } lbl_position.Text = dr_chief["position"].ToString(); lbl_chieftel.Text = dr_chief["telephone"].ToString(); } } finally { dr_chief.Close(); dr_chief.Dispose(); } tbx_affiliatedarea.Text = client.Affiliatedarea; tbx_URL.Text = client.URL; tbx_zip.Text = client.ZIP; tbx_address.Text = client.Address; if(client.CompanyProperty.IndexOf(EnterpriseType.government.ToString())>=0) cbx_government.Checked = true; if(client.CompanyProperty.IndexOf(EnterpriseType.contry.ToString())>=0) cbx_stateowned.Checked = true; if(client.CompanyProperty.IndexOf(EnterpriseType.privateowned.ToString())>=0) cbx_private.Checked = true; if(client.CompanyProperty.IndexOf(EnterpriseType.oversea.ToString())>=0) cbx_foreign.Checked = true; if(client.CompanyProperty.IndexOf(EnterpriseType.stock.ToString())>=0) cbx_market.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.realty.ToString())>=0) cbx_realestate.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.IT.ToString())>=0) cbx_IT.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.business.ToString())>=0) cbx_business.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.telecom.ToString())>=0) cbx_telecom.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.post.ToString())>=0) cbx_post.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.refer.ToString())>=0) cbx_consultation.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.travel.ToString())>=0) cbx_travel.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.bus.ToString())>=0) cbx_bus.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.stock.ToString())>=0) cbx_stock.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.insurance.ToString())>=0) cbx_insurance.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.tax.ToString())>=0) cbx_tax.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.make.ToString())>=0) cbx_make.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.he.ToString())>=0) cbx_electric.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.clothe.ToString())>=0) cbx_clothe.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.food.ToString())>=0) cbx_food.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.medicine.ToString())>=0) cbx_medicine.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.mechanism.ToString())>=0) cbx_mechanism.Checked = true; if(client.ClientTrade.IndexOf(ClientTrade.auto.ToString())>=0) cbx_auto.Checked = true; tbx_staffnumber.Text = client.CompanySize; tbx_money.Text = client.Money; tbx_operation.Text = client.Operation; tbx_introduce.Text = client.Introduce; tbx_IT.Text = client.ITGrade; tbx_pcnumber.Text = client.PCNumber.ToString(); if(client.Net.IndexOf(ClientNet.LAN.ToString())>=0) cbx_LAN.Checked = true; if(client.Net.IndexOf(ClientNet.WAN.ToString())>=0) cbx_WAN.Checked = true; if(client.Net.IndexOf(ClientNet.INTERNET.ToString())>=0) cbx_internet.Checked = true; tbx_ITStaffs.Text = client.ITStaffs.ToString(); tbx_ITdepartment.Text = client.ITDepartment; tbx_principal.Text = client.Principal; tbx_system.Text = client.System; if(client.ClientSource.IndexOf(ClientSource.sellman.ToString())>=0) cbx_sellman.Checked = true; if(client.ClientSource.IndexOf(ClientSource.familiar.ToString())>=0) cbx_just.Checked = true; if(client.ClientSource.IndexOf(ClientSource.introduce.ToString())>=0) cbx_introduce.Checked = true; if(client.ClientSource.IndexOf(ClientSource.client.ToString())>=0) cbx_customer.Checked = true; if(client.ClientInitiative.IndexOf(ClientInitiative.media.ToString())>=0) cbx_media.Checked = true; if(client.ClientInitiative.IndexOf(ClientInitiative.searchweb.ToString())>=0) cbx_Web.Checked = true; if(client.ClientInitiative.IndexOf(ClientInitiative.proseminar.ToString())>=0) cbx_proseminar.Checked = true; if(client.ClientInitiative.IndexOf(ClientInitiative.exhibition.ToString())>=0) cbx_exhibition.Checked = true; if(client.ClientInitiative.IndexOf(ClientInitiative.post.ToString())>=0) cbx_EMS.Checked = true; if(client.ClientInitiative.IndexOf(ClientInitiative.email.ToString())>=0) cbx_Email.Checked = true; #endregion if(clientid==0) { btn_OK.Text = "���"; CustomValidator1.Enabled = true; } else { btn_OK.Text = "��"; CustomValidator1.Enabled = false; } penal.Visible = cbx_customer.Checked; } else { clientid = Int32.Parse(ViewState["ClientID"].ToString()); //��ʾ��ϵ�� string tmplinkmanid1 = (Session["tmplinkmanid"]==null)?"":Session["tmplinkmanid"].ToString(); foreach(string linkmanid in tmplinkmanid1.Split(',')) { if(linkmanid.Trim()!="") { UDS.Components.Linkman linkman = new UDS.Components.Linkman(); UDS.Components.CM cm1 = new UDS.Components.CM(); linkman = cm1.GetLinkmanStructByID(linkmanid); if(Session["cm_permission"].ToString()=="administrator") { hlk_Chiefman.Text = linkman.Name; hlk_Chiefman.NavigateUrl = "Linkman.aspx?LinkmanID=" + linkman.ID; hlk_Chiefman.Target = "_blank"; } else { hlk_Chiefman.Text = linkman.Name;; } lbl_position.Text = linkman.Position; lbl_chieftel.Text = linkman.Telephone; } } } if(clientid!=0) { rpt_Attachment.DataSource = cm.GetAttachmentByClientID(clientid); rpt_Attachment.DataBind(); } if(clientid==0) btn_AddContact.Visible = false; else btn_AddContact.Visible = true; }
private void btn_LookTel_Click(object sender, System.EventArgs e) { ltl_addmantel.Visible = true; UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetStaffInfo(Int32.Parse(ddl_AddMan.SelectedItem.Value)); while(dr_staff.Read()) { ltl_addmantel.Text = dr_staff["Mobile"].ToString(); } dr_staff.Close(); }
//������������˵� private void BindAddManList() { UDS.Components.Staff staff = new UDS.Components.Staff(); ddl_AddMan.DataSource = staff.GetStaffFromPosition(Server.UrlDecode(Request.Cookies["UserName"].Value), 2, 3); ddl_AddMan.DataTextField = "realname"; ddl_AddMan.DataValueField = "staff_id"; ddl_AddMan.DataBind(); SqlDataReader dr_staff = staff.GetStaffInfo(long.Parse(Request.Cookies["UserID"].Value)); string myrealname = ""; try { while (dr_staff.Read()) { myrealname = dr_staff["realname"].ToString(); } } finally { dr_staff.Close(); dr_staff.Dispose(); } ddl_AddMan.Items.Add(new ListItem(myrealname,Request.Cookies["UserID"].Value)); }
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; try { 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; } //����2003-10-8�� Ŀ�ģ���������103������ // if( txtBirthday.Text =="") // txtBirthday.Text = DateTime.Now.ToShortDateString(); // txtBirthday.Text = dr["Birthday"].ToString().IndexOf(" ")>0?dr["Birthday"].ToString().Substring(0,dr["Birthday"].ToString().IndexOf(" ")):dr["Birthday"].ToString() ; txtBirthday.Text = ((dr["Birthday"] == DBNull.Value) || (DateTime.Parse(dr["Birthday"].ToString()).Date == DateTime.Parse("1900-1-1").Date)) ? "-" : DateTime.Parse(dr["Birthday"].ToString()).ToLongDateString(); 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(); txtCaste.Text = dr["Caste"].ToString(); PositionID = dr["Position_ID"].ToString(); SelectPosition(Int32.Parse(dr["Position_ID"].ToString())); txtContractDate.Text = ((dr["ContractDate"] == DBNull.Value) || (DateTime.Parse(dr["ContractDate"].ToString()).Date == DateTime.Parse("1900-1-1").Date)) ? "-" : DateTime.Parse(dr["ContractDate"].ToString()).ToLongDateString(); //dr["ContractDate"].ToString(); txtInsuranceStatus.Text = dr["InsuranceStatus"].ToString(); txtAccumulationStatus.Text = dr["AccumulationStatus"].ToString(); txtIDNumber.Text = dr["IDNumber"].ToString(); txtMarriage.Text = dr["Marriage"].ToString(); txtAddress.Text = dr["Address"].ToString(); txtBirthPlace.Text = dr["BirthPlace"].ToString(); txtEducation.Text = dr["Education"].ToString(); txtFeatures.Text = dr["Features"].ToString(); txtRemark.Text = dr["Remark"].ToString(); txtInsuranceBase.Text = dr["InsuranceBase"].ToString(); txtEndowmentCompany.Text = dr["EndowmentCompany"].ToString(); txtEndowmentPersonal.Text = dr["EndowmentPersonal"].ToString(); txtUnemploymentCompany.Text = dr["UnemploymentCompany"].ToString(); txtUnemploymentPersonal.Text = dr["UnemploymentPersonal"].ToString(); txtInjury.Text = dr["Injury"].ToString(); txtMaternity.Text = dr["Maternity"].ToString(); txtMedicalCompany.Text = dr["MedicalCompany"].ToString(); txtMedicalPersonal.Text = dr["MedicalPersonal"].ToString(); txtInsuranceCompanyTotal.Text = dr["InsuranceCompanyTotal"].ToString(); txtInsurancePersonalTotal.Text = dr["InsurancePersonalTotal"].ToString(); txtAccumulationBase.Text = dr["AccumulationBase"].ToString(); txtAccumulationCompany.Text = dr["AccumulationCompany"].ToString(); txtAccumulationPersonal.Text = dr["AccumulationPersonal"].ToString(); dplDept.SelectedValue = dr["staff_dept"].ToString(); } person = null; } finally { if (dr != null) { dr.Close(); } dr = null; } }
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; } //����2003-10-8�� Ŀ�ģ���������103������ // if( txtBirthday.Text =="") // txtBirthday.Text = DateTime.Now.ToShortDateString(); // txtBirthday.Text = dr["Birthday"].ToString().IndexOf(" ")>0?dr["Birthday"].ToString().Substring(0,dr["Birthday"].ToString().IndexOf(" ")):dr["Birthday"].ToString() ; txtBirthday .Text = ((dr["Birthday"]==DBNull.Value) || (DateTime.Parse(dr["Birthday"].ToString()).Date==DateTime.Parse("1900-1-1").Date))?"-":DateTime.Parse(dr["Birthday"].ToString()).ToLongDateString(); 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(); txtCaste .Text = dr["Caste"].ToString(); PositionID = dr["Position_ID"].ToString(); SelectPosition(Int32.Parse(dr["Position_ID"].ToString())); } person = null; dr.Close(); dr =null; }
private void sms_all(int ii) { string sql = "";//����ѡ��ij�ԱID���� bool sqlFlag = true; foreach(DataGridItem dgi in this.dgMemberList.Items) { CheckBox cb=(CheckBox)(dgi.Cells[0].Controls[1]); if (cb.Checked==true) { int i = dgi.ItemIndex; string id = dgMemberList.DataKeys[i].ToString(); if (sqlFlag) { sql+=""+id; sqlFlag=false; } else { sql+=" ,"; sql+=id; } } } SqlDataReader dr_this;//��ѡ����Ա UDS.Components.Staff sta=new UDS.Components.Staff(); dr_this=sta.GetStaffInfo(sql); SqlDataReader dr_allTeam;//������Ա Team steam=new Team(); dr_allTeam=steam.GetStaffInTeam(Convert.ToInt32(ClassID)); SqlDataReader dr_allTeamMaster;//�����鳤 ProjectClass prj=new ProjectClass(); dr_allTeamMaster=prj.GetLeader(Convert.ToInt32(ClassID)); SqlDataReader dataReader;//��Ŀ��Ϣ dataReader = prj.GetClassInfo(Convert.ToInt32(ClassID)); string Team_name="";//��Ŀ���� try { if (dataReader.Read()) { Team_name = dataReader[0].ToString() + ","; } dataReader.Close(); dataReader = null; string Staff_name = "";//��ѡ����Ա���� while (dr_this.Read()) { Staff_name += dr_this["RealName"].ToString() + ","; } dr_this.Close(); dr_this = null; string name_teamMaster = "";//�����鳤������ while (dr_allTeamMaster.Read()) { name_teamMaster += dr_allTeamMaster["RealName"].ToString() + ","; } dr_allTeamMaster.Close(); dr_allTeamMaster = null; SMS sm = new SMS(); //����������� while (dr_allTeam.Read())//iΪ0��ʾ������,iΪ1��ʾ������,iΪ2��ʾ��Ϊ�鳤 { if (ii == 0) sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), Team_name + " ��Ŀ��Ա��:" + Staff_name + "�Ѿ����뱾��Ŀ,�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); else if (ii == 1) sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), "Ա��:" + Staff_name + "�Ѿ�������Ŀ:" + Team_name + ",�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); else if (ii == 2) sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), Team_name + " ��Ŀ��Ա��:" + Staff_name + "�Ѿ����" + name_teamMaster + ",��Ϊ��Ŀ�鳤,�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); } sm = null; dr_allTeam.Close(); dr_allTeam = null; } finally { dr_allTeam.Close(); dr_allTeamMaster.Close(); dr_this.Close(); dataReader.Close(); } }