//调职通知
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;
}
}
}
}
