//调职通知 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; }
/// <summary> /// 对下拉列表进行初始化 /// </summary> private void PopulateListView() { #region 开始时间与结束时间初始化 Task task = new Task(); SqlDataReader dataReader = null; dataReader = task.GetPeriodInfo(); ArrayList a = new ArrayList(); while (dataReader.Read()) { string [] b = dataReader[1].ToString().Split('-'); listBeginTime.Items.Add(new ListItem(b[0], dataReader[0].ToString())); listEndTime.Items.Add(new ListItem(b[0], dataReader[0].ToString())); } dataReader.Close(); a = null; listBeginTime.SelectedIndex = Int32.Parse(CurrTime) - startTimeNo; listEndTime.SelectedIndex = listBeginTime.SelectedIndex + 1; // listBeginTime.DataTextField = "period"; // listBeginTime.DataValueField = "id"; // listBeginTime.DataSource = dataReader; // listBeginTime.DataBind(); // for(int j=startTimeNo;j<19;j++) // { // ListItem li = new ListItem(j.ToString()+":00",j.ToString()); // listBeginTime.Items.Insert(j-8,li); // listEndTime.Items.Insert(j-8,li); // } txtBeginDate.Text = DateTime.Parse(CurrDate).ToString("yyyy-MM-dd"); // listBeginTime.SelectedIndex = Int32.Parse(CurrTime)-startTimeNo; txtEndDate.Text = DateTime.Parse(CurrDate).ToString("yyyy-MM-dd"); #endregion #region 任务属性初始化 rbAttribute.Items.Add(new ListItem("独占任务", "1")); rbAttribute.Items.Add(new ListItem("限时任务", "0")); rbAttribute.Items[0].Selected = true; #endregion #region 任务类型初始化 rbType.Items.Add(new ListItem("会议", "1")); rbType.Items.Add(new ListItem("文案", "2")); rbType.Items.Add(new ListItem("来访", "3")); rbType.Items.Add(new ListItem("电话", "4")); rbType.Items.Add(new ListItem("走访", "5")); rbType.Items.Add(new ListItem("外出", "6")); rbType.Items.Add(new ListItem("假期", "7")); rbType.Items.Add(new ListItem("出差", "8")); rbType.Items[0].Selected = true; #endregion #region 协同人员列表初始化 UDS.Components.Staff staff = new UDS.Components.Staff(); try { listCooperator.DataTextField = "RealName"; listCooperator.DataValueField = "Staff_Name"; listCooperator.DataSource = staff.GetAllStaffs(); listCooperator.DataBind(); } catch (Exception e) { UDS.Components.Error.Log(e.ToString()); Server.Transfer("../Error.aspx"); } finally { staff = null; } #endregion lblArrangedBy.Text = UDS.Components.Staff.GetRealNameByUsername(Username); }
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; }
/// <summary> /// �������б���г�ʼ�� /// </summary> private void PopulateListView() { #region ��ʼʱ�������ʱ���ʼ�� Task task = new Task(); SqlDataReader dataReader = null; dataReader = task.GetPeriodInfo(); ArrayList a = new ArrayList(); while (dataReader.Read()) { string[] b = dataReader[1].ToString().Split('-'); listBeginTime.Items.Add(new ListItem(b[0], dataReader[0].ToString())); listEndTime.Items.Add(new ListItem(b[0], dataReader[0].ToString())); } dataReader.Close(); a = null; listBeginTime.SelectedIndex = Int32.Parse(CurrTime) - startTimeNo; listEndTime.SelectedIndex = listBeginTime.SelectedIndex + 1; // listBeginTime.DataTextField = "period"; // listBeginTime.DataValueField = "id"; // listBeginTime.DataSource = dataReader; // listBeginTime.DataBind(); // for(int j=startTimeNo;j<19;j++) // { // ListItem li = new ListItem(j.ToString()+":00",j.ToString()); // listBeginTime.Items.Insert(j-8,li); // listEndTime.Items.Insert(j-8,li); // } txtBeginDate.Text = DateTime.Parse(CurrDate).ToString("yyyy-MM-dd"); // listBeginTime.SelectedIndex = Int32.Parse(CurrTime)-startTimeNo; txtEndDate.Text = DateTime.Parse(CurrDate).ToString("yyyy-MM-dd"); #endregion #region �������Գ�ʼ�� rbAttribute.Items.Add(new ListItem("��ռ����", "1")); rbAttribute.Items.Add(new ListItem("��ʱ����", "0")); rbAttribute.Items[0].Selected = true; #endregion #region �������ͳ�ʼ�� rbType.Items.Add(new ListItem("����", "1")); rbType.Items.Add(new ListItem("�İ�", "2")); rbType.Items.Add(new ListItem("����", "3")); rbType.Items.Add(new ListItem("�绰", "4")); rbType.Items.Add(new ListItem("�߷�", "5")); rbType.Items.Add(new ListItem("���", "6")); rbType.Items.Add(new ListItem("����", "7")); rbType.Items.Add(new ListItem("����", "8")); rbType.Items.Add(new ListItem("ϵͳ", "9")); rbType.Items.Add(new ListItem("��ѵ", "10")); rbType.Items[0].Selected = true; #endregion #region Эͬ��Ա�б��ʼ�� UDS.Components.Staff staff = new UDS.Components.Staff(); try { listCooperator.DataTextField = "RealName"; listCooperator.DataValueField = "Staff_Name"; listCooperator.DataSource = staff.GetAllStaffs(); listCooperator.DataBind(); } catch (Exception e) { UDS.Components.Error.Log(e.ToString()); Server.Transfer("../Error.aspx"); } finally { staff = null; } #endregion lblArrangedBy.Text = UDS.Components.Staff.GetRealNameByUsername(Username); }
/// <summary> /// �����ݽ��г�ʼ�� /// </summary> private void PopulateData() { Staff staff = new Staff(); listAccount.Items.Clear(); if(DispType=="1") listAccount.DataSource = staff.GetStaffInTeam(Int32.Parse(ClassID)); else listAccount.DataSource = staff.GetAllStaffs(); listAccount.DataTextField = "RealName"; listAccount.DataValueField = "Staff_Name"; listAccount.DataBind (); listDept.DataSource = staff.GetPositionList(1); listDept.DataTextField = "Position_Name"; listDept.DataValueField = "Position_ID"; listDept.DataBind(); listDept.Items.Insert(0,new ListItem("��˾���в���","0")); listDept.SelectedIndex = 0; listDept.Attributes["onclick"]="SaveValue()"; staff=null; }
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 (myposition.Visible == true) { PositionID = cboPosition.Items[cboPosition.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("@PositionID", SqlDbType.Int, 4, Int32.Parse(PositionID)), 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.MakeInParam("@Caste", SqlDbType.Int, 4, Int32.Parse(txtCaste.Text)) }; db.RunProc("sp_AddStaff", prams, out dr); if (dr.Read()) { SqlDataReader dr_isok; //所有在职人员 UDS.Components.Staff sta = new UDS.Components.Staff(); dr_isok = sta.GetAllStaffs(); //处理短信提醒 if (this.cbRemind.Checked == true) { while (dr_isok.Read()) { SMS sm = new SMS(); sm.SendMsg(Username, dr_isok["Staff_name"].ToString(), cboPosition.SelectedItem.Text + "处新到员工 " + txtRealName.Text + ",特此通知.", 1, DateTime.Now, "", 0, 0); //sm.SendMsg(Username,mailbody.MailReceiverStr+mailbody.MailCcToAddr+mailbody.MailBccToAddr,"您从"+Username+"处收到了一封新的邮件",1,DateTime.Now,"",0,0); sm = null; } dr_isok = null; } if (ReturnPage == 0) { Response.Redirect("ListView.aspx?Position_ID=" + PositionID); } else { Response.Redirect("../Staff/ManageStaff.aspx"); } dr = null; } else { message.Text = "<font color=red>该用户已经存在!</font>"; } } else { UDS.Components.Staff person = new UDS.Components.Staff(); switch (person.UpdateInfo(StaffID, txtRealName.Text, sex, txtBirthday.Text == "-"?"1900-01-01":txtBirthday.Text, txtPassword.Text, txtEmail.Text, txtPhone.Text, txtMobile.Text, Int32.Parse(cboPosition.Items[cboPosition.SelectedIndex].Value), Int32.Parse(txtCaste.Text))) { case 0: PositionID = Int32.Parse(cboPosition.Items[cboPosition.SelectedIndex].Value).ToString(); if (ReturnPage == 0) { Response.Redirect("ListView.aspx?Position_ID=" + PositionID); } else { Response.Redirect("../Staff/ManageStaff.aspx"); } message.Text = "修改成功!"; break; case -1: message.Text = "验证密码不对!"; break; default: break; } } }
//protected System.Web.UI.WebControls.DropDownList listAccount; //protected System.Web.UI.WebControls.Label lblReceiver; //protected System.Web.UI.WebControls.Label lblMReceiver; //protected System.Web.UI.WebControls.DropDownList listDept; private void Page_Load(object sender, System.EventArgs e) { string resulttyep = Request.Params["result"]; string depid = Request.Params["dep"]; if (!Page.IsPostBack) { if (string.IsNullOrEmpty(resulttyep)) { } else { UDS.Components.Staff staff = new UDS.Components.Staff(); switch (resulttyep) { case "staff": ICollection retValue; if (string.IsNullOrEmpty(depid) || "0" == depid) { retValue = staff.GetAllStaffs().ToDataTable(true).DefaultView; } else { retValue = staff.GetStaffByPosition(Int32.Parse(depid)); } IList retList = new ArrayList(); var em = retValue as DataView; foreach (DataRow dr in em.Table.Rows) { ListAccount la = new ListAccount(); la.RealName = dr["RealName"].ToString(); la.StaffName = dr["Staff_Name"].ToString(); retList.Add(la); } var jsonSer = new Newtonsoft.Json.JsonSerializer(); StringWriter sw = new StringWriter(); using (JsonWriter jw = new JsonTextWriter(sw)) { jw.Formatting = Formatting.Indented; jsonSer.Serialize(jw, retList); } Response.ContentType = "text/json"; Response.Write(sw.ToString()); sw.Close(); Response.End(); break; case "position": DataTable ds = staff.GetPositionList(1).ToDataTable(true); List<MaiSystem.Position> retPoss = new List<MaiSystem.Position>(); foreach (DataRow dr in ds.Rows) { MaiSystem.Position p = new MaiSystem.Position(); p.PositionID = dr["Position_ID"].ToString(); p.PositionName = dr["Position_Name"].ToString(); retPoss.Add(p); } MaiSystem.Position fp = new MaiSystem.Position(); fp.PositionName = "��˾���в���"; fp.PositionID = "0"; retPoss.Insert(0, fp); var posSer = new Newtonsoft.Json.JsonSerializer(); StringWriter possw = new StringWriter(); using (JsonWriter jw = new JsonTextWriter(possw)) { jw.Formatting = Formatting.Indented; posSer.Serialize(jw, retPoss); } Response.ContentType = "text/json"; Response.Write(possw.ToString()); possw.Close(); Response.End(); break; } } } }
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=null; try { if (myposition.Visible == true) PositionID = cboPosition.Items[cboPosition.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("@PositionID",SqlDbType.Int,4,Int32.Parse(PositionID)), db.MakeInParam("@Phone",SqlDbType.VarChar,50,txtPhone.Text), db.MakeInParam("@Mobile",SqlDbType.VarChar,50,txtMobile.Text), db.MakeInParam("@Birthday",SqlDbType.DateTime,8,(Request.Form["txtBirthday"].ToString()=="")?"1900-1-1":Request.Form["txtBirthday"].ToString()), db.MakeInParam("@Caste",SqlDbType.Int,4,Int32.Parse(txtCaste.Text)), db.MakeInParam("@ContractDate",SqlDbType.DateTime,8,(Request.Form["txtContractDate"].ToString()=="")?"1900-1-1":Request.Form["txtContractDate"].ToString()), db.MakeInParam("@InsuranceStatus",SqlDbType.VarChar,300,txtInsuranceStatus.Text), db.MakeInParam("@AccumulationStatus",SqlDbType.VarChar,300,txtAccumulationStatus.Text), db.MakeInParam("@IDNumber",SqlDbType.VarChar,300,txtIDNumber.Text), db.MakeInParam("@Marriage",SqlDbType.VarChar,300,txtMarriage.Text), db.MakeInParam("@Address",SqlDbType.VarChar,300,txtAddress.Text), db.MakeInParam("@BirthPlace",SqlDbType.VarChar,300,txtBirthPlace.Text), db.MakeInParam("@Education ",SqlDbType.VarChar,300,txtEducation .Text), db.MakeInParam("@Features",SqlDbType.VarChar,300,txtFeatures.Text), db.MakeInParam("@Remark",SqlDbType.VarChar,300,txtRemark.Text), db.MakeInParam("@InsuranceBase",SqlDbType.Money,21, decimal.Parse( txtInsuranceBase.Text == "" ? "0" : txtInsuranceBase.Text)), db.MakeInParam("@EndowmentCompany",SqlDbType.Money,21, decimal.Parse(txtEndowmentCompany.Text==""?"0":txtEndowmentCompany.Text)), db.MakeInParam("@EndowmentPersonal ",SqlDbType.Money,21, decimal.Parse(txtEndowmentPersonal.Text==""?"0":txtEndowmentPersonal.Text)), db.MakeInParam("@UnemploymentCompany ",SqlDbType.Money,21, decimal.Parse(txtUnemploymentCompany.Text==""?"0":txtUnemploymentCompany.Text)), db.MakeInParam("@UnemploymentPersonal",SqlDbType.Money,21, decimal.Parse(txtUnemploymentPersonal.Text==""?"0":txtUnemploymentPersonal.Text)), db.MakeInParam("@Injury",SqlDbType.Money,21, decimal.Parse(txtInjury.Text==""?"0":txtInjury.Text)), db.MakeInParam("@Maternity ",SqlDbType.Money,21, decimal.Parse(txtMaternity.Text==""?"0":txtMaternity.Text)), db.MakeInParam("@MedicalCompany ",SqlDbType.Money,21, decimal.Parse(txtMedicalCompany.Text==""?"0":txtMedicalCompany.Text)), db.MakeInParam("@MedicalPersonal",SqlDbType.Money,21, decimal.Parse(txtMedicalPersonal.Text==""?"0":txtMedicalPersonal.Text)), db.MakeInParam("@InsuranceCompanyTotal ",SqlDbType.Money,21, decimal.Parse( txtInsuranceCompanyTotal.Text==""?"0":txtInsuranceCompanyTotal.Text)), db.MakeInParam("@InsurancePersonalTotal",SqlDbType.Money,21, decimal.Parse(txtInsurancePersonalTotal.Text==""?"0":txtInsurancePersonalTotal.Text)), db.MakeInParam("@AccumulationBase",SqlDbType.Money,21, decimal.Parse(txtAccumulationBase.Text==""?"0":txtAccumulationBase.Text)), db.MakeInParam("@AccumulationCompany ",SqlDbType.Money,21, decimal.Parse(txtAccumulationCompany.Text==""?"0":txtAccumulationCompany.Text)), db.MakeInParam("@AccumulationPersonal",SqlDbType.Money,21, decimal.Parse(txtAccumulationPersonal.Text == "" ? "0" : txtAccumulationPersonal.Text)), db.MakeInParam("@staff_dept",SqlDbType.VarChar,200,dplDept.Items[dplDept.SelectedIndex].Value.ToString()) }; db.RunProc("sp_AddStaff", prams, out dr); if (dr.Read()) { SqlDataReader dr_isok;//������ְ��Ա UDS.Components.Staff sta = new UDS.Components.Staff(); dr_isok = sta.GetAllStaffs(); //����������� if (this.cbRemind.Checked == true) { try { while (dr_isok.Read()) { SMS sm = new SMS(); sm.SendMsg(Username, dr_isok["Staff_name"].ToString(), cboPosition.SelectedItem.Text + "���µ�Ա�� " + txtRealName.Text + ",�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); //sm.SendMsg(Username,mailbody.MailReceiverStr+mailbody.MailCcToAddr+mailbody.MailBccToAddr,"����"+Username+"���յ���һ���µ��ʼ�",1,DateTime.Now,"",0,0); sm = null; } } finally { dr_isok.Close(); dr_isok = null; } } if (ReturnPage == 0) Response.Redirect("ListView.aspx?Position_ID=" + PositionID); else Response.Redirect("../Staff/ManageStaff.aspx"); dr = null; } else message.Text = "<font color=red>���û��Ѿ����ڣ�</font>"; } finally { if (db != null) { db.Close(); } if (dr != null) { dr.Close(); } } } else { UDS.Components.Staff person = new UDS.Components.Staff(); txtContractDate.Text=(Request.Form["txtContractDate"].ToString()=="-")?"1900-1-1":Request.Form["txtContractDate"].ToString(); txtBirthday.Text = (Request.Form["txtBirthday"].ToString() == "-") ? "1900-1-1" : Request.Form["txtBirthday"].ToString(); switch (person.UpdateInfo(StaffID, txtRealName.Text, sex, txtBirthday.Text, txtPassword.Text, txtEmail.Text, txtPhone.Text, txtMobile.Text, Int32.Parse(cboPosition.Items[cboPosition.SelectedIndex].Value), Int32.Parse(txtCaste.Text), txtContractDate.Text , txtInsuranceStatus.Text , txtAccumulationStatus.Text , txtIDNumber.Text , txtMarriage.Text , txtAddress.Text , txtBirthPlace.Text , txtEducation.Text , txtFeatures.Text , txtRemark.Text , txtInsuranceBase.Text == "" ? "0" : txtInsuranceBase.Text , txtEndowmentCompany.Text==""?"0":txtEndowmentCompany.Text , txtEndowmentPersonal.Text==""?"0":txtEndowmentPersonal.Text , txtUnemploymentCompany.Text==""?"0":txtUnemploymentCompany.Text , txtUnemploymentPersonal.Text==""?"0":txtUnemploymentPersonal.Text , txtInjury.Text==""?"0":txtInjury.Text , txtMaternity.Text==""?"0":txtMaternity.Text , txtMedicalCompany.Text==""?"0":txtMedicalCompany.Text , txtMedicalPersonal.Text==""?"0":txtMedicalPersonal.Text , txtInsuranceCompanyTotal.Text==""?"0":txtInsuranceCompanyTotal.Text , txtInsurancePersonalTotal.Text==""?"0":txtInsurancePersonalTotal.Text , txtAccumulationBase.Text==""?"0":txtAccumulationBase.Text , txtAccumulationCompany.Text==""?"0":txtAccumulationCompany.Text , txtAccumulationPersonal.Text == "" ? "0" : txtAccumulationPersonal.Text , dplDept.Items[dplDept.SelectedIndex].Value.ToString() )) { case 0: PositionID = Int32.Parse(cboPosition.Items[cboPosition.SelectedIndex].Value ).ToString(); if(ReturnPage==0) Response.Redirect("ListView.aspx?Position_ID="+PositionID); else Response.Redirect("../Staff/ManageStaff.aspx"); message.Text = "�ijɹ���"; break; case -1: message.Text = "��֤���벻�ԣ�"; break; default: break; } } }
private void BindDDL() { //8 droplist //location AssetCurrentLocation at = new AssetCurrentLocation(); AssetCurrentLocation[] atArrary = AssetCurrentLocation.FindAll(); DataTable dt = Converter.ConvertToDataTable(atArrary); dt.Columns[0].ColumnName = "ID"; dt.Columns[1].ColumnName = "Name"; this.ddlLocation.DataTextField = "Name"; this.ddlLocation.DataValueField = "ID"; this.ddlLocation.DataSource = dt; this.ddlLocation.DataBind(); //state AssetUseState[] auArrary = AssetUseState.FindAll(); DataTable dt1 = Converter.ConvertToDataTable(auArrary); dt1.Columns[0].ColumnName = "ID"; dt1.Columns[1].ColumnName = "Name"; ddlUseState.DataTextField = "Name"; this.ddlUseState.DataValueField = "ID"; this.ddlUseState.DataSource = dt1; this.ddlUseState.DataBind(); //type AssetType[] attArrary = AssetType.FindAll(); DataTable dt2 = Converter.ConvertToDataTable(attArrary); dt2.Columns[0].ColumnName = "ID"; dt2.Columns[1].ColumnName = "Name"; ddlType.DataTextField = "Name"; this.ddlType.DataValueField = "ID"; this.ddlType.DataSource = dt2; this.ddlType.DataBind(); #region 协同人员列表初始化 UDS.Components.Staff staff = new UDS.Components.Staff(); try { ddlBuyUser.DataTextField = "Staff_Name"; ddlBuyUser.DataValueField = "Staff_ID"; ddlBuyUser.DataSource = staff.GetAllStaffs(); ddlBuyUser.DataBind(); ddlCurrentUser.DataTextField = "Staff_Name"; ddlCurrentUser.DataValueField = "Staff_ID"; ddlCurrentUser.DataSource = staff.GetAllStaffs(); ddlCurrentUser.DataBind(); ddlOriginalUser.DataTextField = "Staff_Name"; ddlOriginalUser.DataValueField = "Staff_ID"; ddlOriginalUser.DataSource = staff.GetAllStaffs(); ddlOriginalUser.DataBind(); } catch (Exception e) { UDS.Components.Error.Log(e.ToString()); Server.Transfer("../Error.aspx"); } finally { staff = null; } #endregion }
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(myposition.Visible==true) PositionID = cboPosition.Items[cboPosition.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("@PositionID",SqlDbType.Int,4,Int32.Parse(PositionID)), 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.MakeInParam("@Caste",SqlDbType.Int,4,Int32.Parse(txtCaste.Text)) }; db.RunProc("sp_AddStaff",prams,out dr); if(dr.Read()) { SqlDataReader dr_isok;//������ְ��Ա UDS.Components.Staff sta=new UDS.Components.Staff(); dr_isok=sta.GetAllStaffs(); //����������� if(this.cbRemind.Checked ==true) { while(dr_isok.Read()) { SMS sm = new SMS(); sm.SendMsg(Username,dr_isok["Staff_name"].ToString(),cboPosition.SelectedItem.Text+"���µ�Ա�� "+txtRealName.Text+",�ش�֪ͨ.",1,DateTime.Now,"",0,0); //sm.SendMsg(Username,mailbody.MailReceiverStr+mailbody.MailCcToAddr+mailbody.MailBccToAddr,"����"+Username+"���յ���һ���µ��ʼ�",1,DateTime.Now,"",0,0); sm = null; } dr_isok=null; } if(ReturnPage==0) Response.Redirect("ListView.aspx?Position_ID="+PositionID); else Response.Redirect("../Staff/ManageStaff.aspx"); dr=null; } else message.Text = "<font color=red>���û��Ѿ����ڣ�</font>"; } else { UDS.Components.Staff person = new UDS.Components.Staff(); switch(person.UpdateInfo(StaffID,txtRealName.Text,sex,txtBirthday.Text=="-"?"1900-01-01":txtBirthday.Text,txtPassword.Text,txtEmail.Text,txtPhone.Text,txtMobile.Text,Int32.Parse(cboPosition.Items[cboPosition.SelectedIndex].Value ),Int32.Parse(txtCaste.Text))) { case 0: PositionID = Int32.Parse(cboPosition.Items[cboPosition.SelectedIndex].Value ).ToString(); if(ReturnPage==0) Response.Redirect("ListView.aspx?Position_ID="+PositionID); else Response.Redirect("../Staff/ManageStaff.aspx"); message.Text = "�ijɹ���"; break; case -1: message.Text = "��֤���벻�ԣ�"; break; default: break; } } }
//protected System.Web.UI.WebControls.DropDownList listAccount; //protected System.Web.UI.WebControls.Label lblReceiver; //protected System.Web.UI.WebControls.Label lblMReceiver; //protected System.Web.UI.WebControls.DropDownList listDept; private void Page_Load(object sender, System.EventArgs e) { string resulttyep = Request.Params["result"]; string depid = Request.Params["dep"]; if (!Page.IsPostBack) { if (string.IsNullOrEmpty(resulttyep)) { } else { UDS.Components.Staff staff = new UDS.Components.Staff(); switch (resulttyep) { case "staff": ICollection retValue; if (string.IsNullOrEmpty(depid) || "0" == depid) { retValue = staff.GetAllStaffs().ToDataTable(true).DefaultView; } else { retValue = staff.GetStaffByPosition(Int32.Parse(depid)); } IList retList = new ArrayList(); var em = retValue as DataView; foreach (DataRow dr in em.Table.Rows) { ListAccount la = new ListAccount(); la.RealName = dr["RealName"].ToString(); la.StaffName = dr["Staff_Name"].ToString(); retList.Add(la); } var jsonSer = new Newtonsoft.Json.JsonSerializer(); StringWriter sw = new StringWriter(); using (JsonWriter jw = new JsonTextWriter(sw)) { jw.Formatting = Formatting.Indented; jsonSer.Serialize(jw, retList); } Response.ContentType = "text/json"; Response.Write(sw.ToString()); sw.Close(); Response.End(); break; case "position": DataTable ds = staff.GetPositionList(1).ToDataTable(true); List <MaiSystem.Position> retPoss = new List <MaiSystem.Position>(); foreach (DataRow dr in ds.Rows) { MaiSystem.Position p = new MaiSystem.Position(); p.PositionID = dr["Position_ID"].ToString(); p.PositionName = dr["Position_Name"].ToString(); retPoss.Add(p); } MaiSystem.Position fp = new MaiSystem.Position(); fp.PositionName = "公司所有部门"; fp.PositionID = "0"; retPoss.Insert(0, fp); var posSer = new Newtonsoft.Json.JsonSerializer(); StringWriter possw = new StringWriter(); using (JsonWriter jw = new JsonTextWriter(possw)) { jw.Formatting = Formatting.Indented; posSer.Serialize(jw, retPoss); } Response.ContentType = "text/json"; Response.Write(possw.ToString()); possw.Close(); Response.End(); break; } } } }