protected void Button1_Click(object sender, EventArgs e)
{
SYS_USER ucond = new SYS_USER();
ucond.USER_NAME = "test";
ucond.PASS = StringHelperExd.StringToMD5("123456");
SYS_USER val = BLLTable <SYS_USER> .Factory(conn).GetRowData(new SYS_USER(), ucond);
if (val != null)
{
PowerHelper.SetCurLoginUser(val);
if (Request["ckPass"] == null)
{
if (Request["preUrl"] != null)
{
Response.Redirect(Request["preUrl"]);
}
else
{
Response.Redirect("Index.aspx");
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 'yes';}else{window.returnValue = 'yes';};window.close();", true);
}
}
else
{
AgileFrame.Core.ScriptHelper.Alert(Page, "用户名或密码错误！请重新输入。");
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (txtPass.Value == "" || txtPassRe.Value == "" || txtPassOld.Value == "")
{
AgileFrame.Core.ScriptHelper.Alert(Page, "旧密码，新密码，重复输入密码都不能为空。");
return;
}
if (txtPass.Value != txtPassRe.Value)
{
AgileFrame.Core.ScriptHelper.Alert(Page, "两次密码输入不一样！请重新输入。");
return;
}
SYS_USER ucond = new SYS_USER();
ucond.USER_NAME = txtName.Text;
ucond.PASS = StringHelperExd.StringToMD5(txtPassOld.Value);
SYS_USER val = BLLTable <SYS_USER> .Factory(conn).GetRowData(new SYS_USER(), ucond);
if (val != null)
{
//PowerHelper.SetCurLoginUser(val);
SYS_USER uuuPass = new SYS_USER();
uuuPass.PASS = StringHelperExd.StringToMD5(txtPass.Value);
BLLTable <SYS_USER> .Factory(conn).Update(SYS_USER.Attribute.USER_ID, val.USER_ID, SYS_USER.Attribute.PASS, StringHelperExd.StringToMD5(txtPass.Value));
if (Request["ckPass"] == null)
{
if (Request["preUrl"] != null)
{
Response.Redirect(Request["preUrl"]);
}
else
{
AgileFrame.Core.ScriptHelper.Alert(Page, "修改成功！");
Response.Write("<script language='javascript'>window.close();</script>");
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 'yes';}else{window.returnValue = 'yes';};window.close();", true);
}
}
else
{
AgileFrame.Core.ScriptHelper.Alert(Page, "旧密码错误！请重新输入。");
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (password.Value == "" || username.Value == "")
{
AgileFrame.Core.ScriptHelper.Alert(Page, "用户名和密码不能为空。");
return;
}
SYS_USER ucond = new SYS_USER();
ucond.USER_NAME = username.Value;
ucond.PASS = StringHelperExd.StringToMD5(password.Value);
SYS_USER val = BLLTable <SYS_USER> .Factory(conn).GetRowData(new SYS_USER(), ucond);
if (val != null)
{
bool tostaff = PowerHelper.SetCurLoginUser(val);
if (tostaff == true)
{
if (Request["ckPass"] == null)
{
if (Request["preUrl"] != null)
{
Response.Redirect(Request["preUrl"]);
}
else
{
Response.Redirect("Index.aspx");
}
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 'yes';}else{window.returnValue = 'yes';};window.close();", true);
}
}
else
{
AgileFrame.Core.ScriptHelper.Alert(Page, "您的用户未与员工信息关联，请联系管理员处理。");
}
}
else
{
AgileFrame.Core.ScriptHelper.Alert(Page, "用户名或密码错误！请重新输入。");
}
}
protected void btnSysInit_Click(object sender, EventArgs e)
{
if (password.Value == "" || username.Value == "")
{
AgileFrame.Core.ScriptHelper.Alert(Page, "授权号和密码不能为空。");
return;
}
if (password.Value != "chintchint")
{
AgileFrame.Core.ScriptHelper.Alert(Page, "授权号和密码错误。");
return;
}
SYS_USER ucond = new SYS_USER();
ucond.USER_NAME = "sys";
SYS_USER val = BLLTable <SYS_USER> .Factory(conn).GetRowData(new SYS_USER(), ucond);
if (val == null || val.IsNull())
{
ucond.PASS = StringHelperExd.StringToMD5("123456");
ucond.USER_TYPE = "1";
ucond.USE_FLAG = "1";
ucond._ADDTIME = DateTime.Now;
ucond._EDITTIME = DateTime.Now;
ucond._EMAIL = "*****@*****.**";
int ret1 = BLLTable <SYS_USER> .Factory(conn).Insert(ucond, SYS_USER.Attribute.USER_ID);
AgileFrame.Core.ScriptHelper.Alert(this, "插入超级管理员sys账户成功");
}
else
{
ucond.PASS = StringHelperExd.StringToMD5("123456");
ucond.USER_TYPE = "1";
ucond.USE_FLAG = "1";
ucond._ADDTIME = DateTime.Now;
ucond._EDITTIME = DateTime.Now;
ucond._EMAIL = "*****@*****.**";
int ret1 = BLLTable <SYS_USER> .Factory(conn).Update(ucond, SYS_USER.Attribute.USER_ID);
AgileFrame.Core.ScriptHelper.Alert(this, "超级管理员sys账户已存在，并重新进行了密码初始化");
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (ViewState["txtSNAME"] == null || ViewState["txtSNAME"].ToString() != txtSNAME.Value)
{
HR_STAFF hadCond = new HR_STAFF();
hadCond.SNAME = txtSNAME.Value;
if (BLLTable <HR_STAFF> .Exists(hadCond))
{
litWarn.Text = "此员工已经存在，请重新输入！或换个简称。";
return;
}
}
try
{
HR_STAFF valObj = new HR_STAFF();
if (txtSTAFF_ID.Value != "")
{
valObj.STAFF_ID = Convert.ToDecimal(txtSTAFF_ID.Value);
}
valObj.STAFF_NO = txtSTAFF_NO.Value;
valObj.STAFF_NAME = Convert.ToString(txtNAME.Value);
valObj.DEPT_ID = wucSelDept1.DEPT_ID;
HR_DEPT dept = BLLTable <HR_DEPT> .Factory(conn).GetRowData(HR_DEPT.Attribute.DEPT_ID, valObj.DEPT_ID);
valObj.ORG_ID = dept.ORG_ID;
valObj.GENDER = Convert.ToString(txtGENDER.Value);
valObj.PHOTO = Convert.ToString(txtPHOTO.Value);
valObj.POS_NAME = Convert.ToString(txtPOS_NAME.Value);
valObj.STATION_CODE = wucSelStation1.STATION_ID;// Convert.ToString(txtSTATION_CODE.Value);
valObj.WORK_TYPE_CODE = Convert.ToString(txtWORK_TYPE_CODE.Value);
valObj.TECH_LEVEL_CODE = Convert.ToString(txtTECH_LEVEL_CODE.Value);
valObj.YMD = txtYMD.Value;
valObj.MOBILE = Convert.ToString(txtMOBILE.Value);
valObj.OFFICE_TEL = Convert.ToString(txtOFFICE_TEL.Value);
valObj.CERT_FLAG = Convert.ToString(txtCERT_FLAG.Value);
valObj.FIXED_FLAG = Convert.ToString(txtFIXED_FLAG.Value);
valObj.ON_POS_FLAG = Convert.ToString(txtON_POS_FLAG.Value);
valObj.PROFESSION_CODE = Convert.ToString(txtPROFESSION_CODE.Value);
valObj.PROFESSION_BGN_DATE = Convert.ToDateTime(txtPROFESSION_BGN_DATE.Value);
valObj.JOIN_DATE = Convert.ToDateTime(txtJOIN_DATE.Value);
valObj.POLITICAL_STATUS_CODE = Convert.ToString(txtPOLITICAL_STATUS_CODE.Value);
valObj.TITLE_CODE = Convert.ToString(txtTITLE_CODE.Value);
valObj.STATUS_CODE = Convert.ToString(txtSTATUS_CODE.Value);
valObj.ADDR = Convert.ToString(txtADDR.Value);
valObj.EMAIL = Convert.ToString(txtEMAIL.Value);
valObj.NATION = Convert.ToString(txtNATION.Value);
valObj.NATIVE_PLACE = Convert.ToString(txtNATIVE_PLACE.Value);
valObj.POST_NO = Convert.ToString(txtPOST_NO.Value);
valObj.DEGREE_CODE = Convert.ToString(txtDEGREE_CODE.Value);
valObj.GRAD_SCHOOL = Convert.ToString(txtGRAD_SCHOOL.Value);
valObj.GRAD_DATE = Convert.ToDateTime(txtGRAD_DATE.Value);
valObj.MAJOR = Convert.ToString(txtMAJOR.Value);
valObj.REMARK = Convert.ToString(txtREMARK.Value);
if (txtUSER_ID.Value != "")
{
valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value);
}
valObj.SNAME = Convert.ToString(txtSNAME.Value);
valObj.RNAME = Convert.ToString(txtRNAME.Value);
valObj.EXP1 = Convert.ToString(txtEXP1.Value);
valObj.EXP2 = Convert.ToString(txtEXP2.Value);
valObj.EXP3 = Convert.ToString(txtEXP3.Value);
if (keyid != "")
{
valObj.STAFF_ID = Convert.ToDecimal(keyid);
count = StaffHelper.EditStaff(valObj);// BLLTable<HR_STAFF>.Factory(conn).Update(valObj, HR_STAFF.Attribute.STAFF_ID);
}
else
{
keyid = StaffHelper.AddStaff(valObj, pid);
count = keyid != "" ? 1 : 0;
//count = BLLTable<HR_STAFF>.Factory(conn).Insert(valObj, HR_STAFF.Attribute.STAFF_ID);
//keyid = valObj.STAFF_ID.ToString();
}
if (count > 0)
{
SYS_USER user = BLLTable <SYS_USER> .Factory(conn).GetRowData(SYS_USER.Attribute.STAFF_ID, valObj.STAFF_ID);
if (user != null && user.IsNotNull())
{
if (txtUSER_NAME.Value != "")
{
user.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
}
if (txtPASS.Value != "")
{
user.PASS = StringHelperExd.StringToMD5(txtPASS.Value);
}
user.EDITTIME = DateTime.Now;
int count2 = BLLTable <SYS_USER> .Factory(conn).Update(user, SYS_USER.Attribute.USER_ID);
}
else
{
user = new SYS_USER();
if (txtUSER_NAME.Value != "")
{
user.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
}
if (txtPASS.Value != "")
{
user.PASS = Convert.ToString(txtPASS.Value);
}
else
{
user.PASS = StringHelperExd.StringToMD5("123456");
}
user.STAFF_ID = valObj.STAFF_ID;
user.USER_TYPE = EnumInfo.SYS_UserType.Common.ToString("d");
user.USE_FLAG = "1";
user.EDITTIME = DateTime.Now;
user.ADDTIME = DateTime.Now;
user.REAL_NAME = valObj.STAFF_NAME;
user.RNAME = user.USER_NAME;
user.SNAME = user.USER_NAME;
int count2 = BLLTable <SYS_USER> .Factory(conn).Insert(user, SYS_USER.Attribute.USER_ID);
}
//StringBuilder sbData = new StringBuilder("({valObj:''");
//List<AttributeItem> lstCol = valObj.af_AttributeItemList;
//for (int i = 0; i < lstCol.Count; i++)
//{
// object val = valObj.GetValue(lstCol[i]);
// if (val != null)
// {
// sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
// }
//}
//sbData.Append("})");
string re = "re";
if (pid != "")
{
//re = "STAFFManage.aspx?PID="+pid;
}
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + re + "';}else{window.returnValue = '" + re + "';}window.close();", true);
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (ViewState["txtUSER_NAME"] == null || ViewState["txtUSER_NAME"].ToString() != txtUSER_NAME.Value)
{
SYS_USER hadCond = new SYS_USER();
hadCond.USER_NAME = txtUSER_NAME.Value;
if (BLLTable<SYS_USER>.Exists(hadCond))
{
litWarn.Text = "此用户已经存在，请重新输入！或换个名称。";
return;
}
}
try
{
SYS_USER valObj = new SYS_USER();
if (txtUSER_ID.Value != "")
valObj.USER_ID = Convert.ToDecimal(txtUSER_ID.Value);
if (txtUSER_NAME.Value != "")
valObj.USER_NAME = Convert.ToString(txtUSER_NAME.Value);
if (txtPASS.Value != "")
valObj.PASS =StringHelperExd.StringToMD5(txtPASS.Value);
if (txtEMAIL.Value != "")
valObj.EMAIL = Convert.ToString(txtEMAIL.Value);
if (txtLOGIN_IPS.Value != "")
valObj.LOGIN_IPS = Convert.ToString(txtLOGIN_IPS.Value);
#region wk(用户新增字段)
//if (txtUSER_QQ.Value != "")
valObj.USER_QQ = Convert.ToString(txtUSER_QQ.Value);
if (txtUSER_Taobao.Value != "")
valObj.USER_Taobao = Convert.ToString(txtUSER_Taobao.Value);
if (txtIS_FeiQ_Remind.Checked != true)
valObj.IS_FeiQ_Remind = Convert.ToBoolean(txtIS_FeiQ_Remind.Checked);
if (txtIS_EMAIL_Remind.Checked != true)
valObj.IS_EMAIL_Remind = Convert.ToBoolean(txtIS_EMAIL_Remind.Checked);
if (txtIS_Taobao_Remind.Checked != true)
valObj.IS_Taobao_Remind = Convert.ToBoolean(txtIS_Taobao_Remind.Checked);
if (txtIS_QQ_Remind.Checked != true)
valObj.IS_QQ_Remind = Convert.ToBoolean(txtIS_QQ_Remind.Checked);
if (txtSTATE_FLAG.Value != "")
valObj.USE_FLAG = Convert.ToString(txtSTATE_FLAG.Value);
#endregion
if (txtUSER_TYPE.Value != "")
valObj.USER_TYPE = Convert.ToString(txtUSER_TYPE.Value);
else
valObj.USER_TYPE = "1";
valObj.STAFF_ID = wucSelStaff1.Staff_ID;
valObj.REAL_NAME = wucSelStaff1.Staff_NAME;
if (keyid != "")
{
valObj.EDITTIME = DateTime.Now;
valObj.USER_ID = Convert.ToInt32(keyid);
count = BLLTable<SYS_USER>.Factory(conn).Update(valObj, SYS_USER.Attribute.USER_ID);
}
else
{
valObj.EDITTIME = DateTime.Now;
valObj.ADDTIME = DateTime.Now;
count = BLLTable<SYS_USER>.Factory(conn).Insert(valObj, SYS_USER.Attribute.USER_ID);
keyid = valObj.USER_ID.ToString();
}
if (count > 0)
{
BLLTable<HR_STAFF>.Factory(conn).Update(HR_STAFF.Attribute.STAFF_ID, wucSelStaff1.Staff_ID, HR_STAFF.Attribute.USER_ID, keyid);
BLLTable<SYS_USERROLE>.Factory(conn).Delete(SYS_USERROLE.Attribute.USER_ID, keyid);//先删除角色用户关联
string[] roles = StringHelper.GetStringArray(hidSelReals.Value, ',');//再根据当前选择的角色写入关联表
if (roles != null)
{
for (int i = 0; i < roles.Length; i++)
{
SYS_USERROLE ur = new SYS_USERROLE();
ur.ROLE_ID = int.Parse(roles[i]);
ur.USER_ID = int.Parse(keyid);
BLLTable<SYS_USERROLE>.Factory(conn).Insert(ur);
}
}
StringBuilder sbData = new StringBuilder("({valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
if (lstCol[i] == SYS_USER.Attribute.ADDTIME)
{
continue;
}
if (lstCol[i] == SYS_USER.Attribute.EDITTIME)
{
val = Convert.ToDateTime(val).ToString("yyyy-MM-dd");
}
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtUSER_NAME.Value = "";
txtPASS.Value = "";
txtEMAIL.Value = "";
txtLOGIN_IPS.Value = "";
txtSTATE_FLAG.Value = "";
txtUSER_TYPE.Value = "";
//ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "parent.addNewToList(\"" + sbData.ToString() + "\");", true);
ViewState["hadSave"] = 1;
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private string InsertUser()
{
string loginname = Common.GetReqStrValue("loginname");
string pwd = Common.GetReqStrValue("pwd");
string name = Common.GetReqStrValue("name");
string coname = Common.GetReqStrValue("coname");
string phone = Common.GetReqStrValue("phone");
int checknum = Common.GetReqIntValue("checknum");
string email = Common.GetReqStrValue("email");
if (Common.GetReqStrValue("hidFlag").Equals("0"))
{
SYS_CHECKNUM condobj = new SYS_CHECKNUM();
condobj.CHECKNUM = checknum;
condobj.PHONE = phone;
if (!BLLTable <SYS_CHECKNUM> .Exists(condobj))
{
return("-1");
}
}
SYS_TEMPUSER objval = new SYS_TEMPUSER();
objval.NAME = loginname;
SYS_USER objvalUser = new SYS_USER();
objvalUser.USER_NAME = loginname;
if (BLLTable <SYS_TEMPUSER> .Exists(objval) || BLLTable <SYS_USER> .Exists(objvalUser))
{
return("-2");
}
//事务处理
using (Transaction t = new Transaction("conn"))
{
objvalUser = new SYS_USER();
objvalUser.USER_NAME = loginname;
objvalUser.PASS = StringHelperExd.StringToMD5(pwd);
objvalUser.USER_TYPE = "4";
objvalUser.REAL_NAME = name;
objvalUser.STAFF_ID = 21;
int intRet = BLLTable <SYS_USER> .Factory(t).Insert(objvalUser, SYS_USER.Attribute.USER_ID);
if (intRet == -1)
{
t.RollBack();
}
string sql = " insert into SYS_USER_MDLPOWER_DIC select " + objvalUser.USER_ID + ",PAGE_URL,DIC_ID from SYS_USER_MDLPOWER_DIC where user_id =1";
intRet = BLLTable <SYS_USER> .Factory(t).ExecSQL(sql, System.Data.CommandType.Text);
if (intRet == -1)
{
t.RollBack();
}
objval = new SYS_TEMPUSER();
objval.LOGINNAME = loginname;
objval.PWD = pwd;
objval.NAME = name;
objval.CONAME = coname;
objval.PHONE = phone;
objval.IP = GetIP();
objval.USER_ID = objvalUser.USER_ID;
objval.EMAIL = email;
intRet = BLLTable <SYS_TEMPUSER> .Factory(t).Insert(objval, SYS_TEMPUSER.Attribute.ID);
if (intRet == -1)
{
t.RollBack();
}
intRet = BLLTable <SYS_CHECKNUM> .Factory(t).Delete(SYS_CHECKNUM.Attribute.PHONE, phone);
if (intRet == -1)
{
t.RollBack();
}
t.Commit();
}
return("0");
}
