public Int32 InsertSYS_USER(SYS_USER objRecord) { Int32 objRet = 0; ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["EventRegConnectionString"]; using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString)) { objCnn.Open(); using (SqlCommand objCmd = objCnn.CreateCommand()) { objCmd.CommandType = System.Data.CommandType.StoredProcedure; objCmd.CommandText = "[AddSYS_USER]"; objCmd.Parameters.Add(new SqlParameter("@USER_ID", objRecord.USER_ID)); objCmd.Parameters.Add(new SqlParameter("@USER_FULLNAME", objRecord.USER_FULLNAME)); objCmd.Parameters.Add(new SqlParameter("@USER_EMAIL", objRecord.USER_EMAIL)); objCmd.Parameters.Add(new SqlParameter("@USER_NAME", objRecord.USER_NAME)); objCmd.Parameters.Add(new SqlParameter("@USER_PASSWORD", objRecord.USER_PASSWORD)); objCmd.Parameters.Add(new SqlParameter("@Isdelete", objRecord.Isdelete)); object obj = objCmd.ExecuteScalar(); if (obj != null) { objRet = Convert.ToInt32(obj); } } } return(objRet); }
public String updateLoanTransactionItem(FormCollection form) { log.Info("form:" + form.Count); string msg = "更新成功!!"; FIN_LOAN_TRANACTION item = new FIN_LOAN_TRANACTION(); item.BL_ID = Int64.Parse(form["blId"]); item.TID = Int64.Parse(form["tid"]); item.TRANSACTION_TYPE = int.Parse(form["transaction_type"]); item.PERIOD = int.Parse(form["Period"]); if (int.Parse(form["transaction_type"]) == -1) { item.EVENT_DATE = Convert.ToDateTime(form.Get("event_date")); } if (int.Parse(form["transaction_type"]) == 1) { item.PAYBACK_DATE = Convert.ToDateTime(form.Get("payback_date")); } if (int.Parse(form["transaction_type"]) == -1) { try { item.AMOUNT = decimal.Parse(form["amount"]); } catch (Exception ex) { log.Error(item.AMOUNT + " not paid amount:" + ex.Message); } } else { try { item.AMOUNT = decimal.Parse(form["payback_amt"]); } catch (Exception ex) { log.Error(item.AMOUNT + " not paid amount:" + ex.Message); } } item.REMARK = form["remark"]; item.VA_FORM_ID = form["formid"]; item.CREATE_ID = form["create_id"]; item.CREATE_DATE = Convert.ToDateTime(form.Get("create_date")); SYS_USER loginUser = (SYS_USER)Session["user"]; item.MODIFY_ID = loginUser.USER_ID; item.MODIFY_DATE = DateTime.Now; ContextService4BankInfo service = new ContextService4BankInfo(); int i = 0; i = service.updateLoanTransactionItem(item); if (i == 0) { msg = service.message; } return(msg); }
/// <summary> /// 增加貸款銀行基本資料 /// </summary> /// <returns></returns> public string addBankLoan(FormCollection f) { SYS_USER u = (SYS_USER)Session["user"]; FIN_BANK_LOAN bankloanInfo = new FIN_BANK_LOAN(); if (Request["BL_ID"] != "") { bankloanInfo.BL_ID = Convert.ToInt64(Request["BL_ID"]); } bankloanInfo.BANK_ID = Request["BANK_ID"]; bankloanInfo.BANK_NAME = Request["BANK_NAME"]; //bankloanInfo.BRANCH_NAME = Request["BRANCH_NAME"]; bankloanInfo.ACCOUNT_NAME = Request["ACCOUNT_NAME"]; //bankloanInfo.ACCOUNT_NO = Request["ACCOUNT_NO"]; bankloanInfo.START_DATE = DateTime.Parse(Request["START_DATE"]); bankloanInfo.DUE_DATE = DateTime.Parse(Request["DUE_DATE"]); bankloanInfo.PERIOD_COUNT = int.Parse(Request["PERIOD_COUNT"]); decimal quota = decimal.Parse(Request["QUOTA"]); bankloanInfo.QUOTA = quota; if (Request["AR_PAYBACK_RATIO"] != "") { bankloanInfo.AR_PAYBACK_RATIO = decimal.Parse(Request["AR_PAYBACK_RATIO"]); } if (Request["CUM_AR_RATIO"] != "") { bankloanInfo.CUM_AR_RATIO = decimal.Parse(Request["CUM_AR_RATIO"]); } if (Request["QUOTA_AVAILABLE_RATIO"] != "") { bankloanInfo.QUOTA_AVAILABLE_RATIO = decimal.Parse(Request["QUOTA_AVAILABLE_RATIO"]); } else { bankloanInfo.QUOTA_AVAILABLE_RATIO = 100; } bankloanInfo.QUOTA_RECYCLABLE = Request["QUOTA_RECYCLABLE"]; bankloanInfo.REMARK = Request["REMARK"]; bankloanInfo.ACCOUNT_NAME = Request["ACCOUNT_NAME"]; if (Request["plans"] != "") { bankloanInfo.PROJECT_ID = Request["plans"]; } bankloanInfo.CREATE_ID = u.USER_ID; bankloanInfo.CREATE_DATE = DateTime.Now; ContextService4BankInfo service = new ContextService4BankInfo(); int i = service.addBankLoan(bankloanInfo); if (i > 0) { return("更新成功(" + bankloanInfo.BL_ID + ")!!"); } else { return("更新失敗!!"); } }
/// <summary> /// 修改 /// </summary> public void Update(SYS_USER info) { using (var session = DBHelper.GetSession()) { info.UPDATE_TIME = DateTime.Now; session.Update(info); } }
public static SysUserDto ToSysUserDto(this SYS_USER u) { return(new SysUserDto { UserName = u.USERNAME, Id = u.Key }); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <SYS_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
public ActionResult Logout() { SYS_USER u = UtilService.GetUserInfoFromSession(Session); log.Info(u.USER_ID + " Logout!!"); Session.Clear();//["UserService"] = null; return(View("Index")); }
/// <summary> /// 添加 /// </summary> public void Insert(SYS_USER info) { using (var session = DBHelper.GetSession()) { info.CREATE_TIME = DateTime.Now; session.Insert(info); } }
//批次產生空白詢價單 public string createEmptyForm() { log.Info("project id=" + Request["projectid"]); SYS_USER u = (SYS_USER)Session["user"]; int i = service.createEmptyForm(Request["projectid"], u); return("共產生 " + i + "空白詢價單樣本!!"); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<SYS_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
public ActionResult DeleteConfirmed(int id) { SYS_USER sYS_USER = db.SYS_USER.Find(id); db.SYS_USER.Remove(sYS_USER); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// 添加 /// </summary> public async Task InsertAsync(SYS_USER info) { using (var session = await DBHelper.GetSessionAsync()) { info.CREATE_TIME = DateTime.Now; await session.InsertAsync(info); } }
// GET: SYS_DEPART/Create public ActionResult Create() { List <SYS_USER> categories = SYS_USER.GETALL(); ViewData["Categories"] = new SelectList(categories, "id", "cname"); return(View()); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["USER_ID"])) { valObj = BLLTable<SYS_USER>.Factory(conn).GetRowData(SYS_USER.Attribute.USER_ID, Request["USER_ID"]); if(valObj==null) return ; txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtUSER_NAME.Text = Convert.ToString(valObj.USER_NAME);//Convert.ToString txtPASS.Text = Convert.ToString(valObj.PASS);//Convert.ToString txtEMAIL.Text = Convert.ToString(valObj.EMAIL);//Convert.ToString txtLOGIN_IPS.Text = Convert.ToString(valObj.LOGIN_IPS);//Convert.ToString txtSTATE_FLAG.Text = valObj.USE_FLAG.ToString(); txtEDITIME.Text = (valObj.EDITTIME == DateTime.MinValue) ? "" : valObj.EDITTIME.ToString("yyyy-MM-dd HH:mm"); txtADDTIME.Text = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm"); txtUSER_TYPE.Text=valObj.USER_TYPE.ToString(); } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//���������Ϊ�������� //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void btnSetPageNum_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageNum.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<SYS_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { string msg = ""; if (userBase.UserType == "3") { Response.Write("您没有权限删除用户信息!"); Response.End(); } //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelUSER_ID"] != null) { int re = UserHelper.DelUser(int.Parse(Request["DelUSER_ID"]), out msg); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { int re = UserHelper.DelUsers(Request["DelKeyIDS"], out msg); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { SYS_USER val = new SYS_USER(); val.USER_ID = int.Parse(Request["FieldKeyID"]); List <AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]); } } BLLTable <SYS_USER> .Factory(conn).Update(val, SYS_USER.Attribute.USER_ID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void btnSetPageNum_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageNum.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <SYS_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
// GET: //成本異動採購作業(針對已經完成審核之異動單進行採購作業 public ActionResult Index() { SYS_USER u = (SYS_USER)Session["user"]; CostChangeService cs = new CostChangeService(); SelectList lstProject = new SelectList(PlanService.SearchProjectByName("", "專案執行", u), "PROJECT_ID", "PROJECT_NAME"); ViewData.Add("projects", lstProject); return(View()); }
/// <summary> /// 判断用户名密码与指定用户是否匹配 /// </summary> /// <param name="user">指定用户</param> /// <param name="pwd">密码</param> /// <param name="username">用户名</param> /// <returns>匹配:true/不匹配:false</returns> private bool isUserValid(SYS_USER user, string pwd, string username) { if (isPasswordValid(user, pwd, username)) { return(user.DELETE_FLAG != 1); } return(false); }
/// <summary> /// 修改 /// </summary> public async Task UpdateAsync(SYS_USER info) { using (var session = await DBHelper.GetSessionAsync()) { info.UPDATE_TIME = DateTime.Now; var task = session.UpdateAsync(info); await task; } }
public ActionResult Logout() { SYS_USER u = (SYS_USER)Session["user"]; log.Info(u.USER_ID + " Logout!!"); //1.清空Session Session.RemoveAll(); //2.導回登入頁 return(RedirectToAction("Login", "Home")); }
public void TestInsertUser() { SYS_USER user = new SYS_USER(); user.USER_NAME = "testUser"; user.REAL_NAME = "测试插入用户"; user.PASSWORD = "******"; user.CREATE_USERID = "1"; m_SysUserDal.Insert(user); }
// GET: BankInfo public ActionResult Index() { SYS_USER u = (SYS_USER)Session["user"]; log.Debug(u.USER_ID + " Query BankInfo!!"); ContextService4BankInfo service = new ContextService4BankInfo(); List <FIN_BANK_ACCOUNT> lstBankAccount = service.getAllBankAccount(); return(View(lstBankAccount)); }
//取消 public String CancelForm(FormCollection form) { Flow4CompanyExpense wfs = new Flow4CompanyExpense(); wfs.task = (ExpenseTask)Session["process"]; SYS_USER u = (SYS_USER)Session["user"]; wfs.Cancel(u); return(wfs.Message); }
public string delTaskItem() { TND_TASKASSIGN t = new TND_TASKASSIGN(); t.TASK_ID = long.Parse(Request["itemid"].ToString()); SYS_USER u = (SYS_USER)Session["user"]; service.delTask(u, t); return(service.message); }
public ActionResult Delete(int id) { SYS_USER oldUser = DA_User.Instance.GetById(id); //Ghi log WriteLog("User", "Delete", oldUser); DA_User.Instance.Delete(id); return(RedirectToAction("Index")); }
protected void Page_Load(object sender, EventArgs e) { string msg = ""; if (userBase.UserType == "3") { Response.Write("��û��Ȩ��ɾ���û���Ϣ��"); Response.End(); } //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelUSER_ID"] != null) { int re = UserHelper.DelUser(int.Parse(Request["DelUSER_ID"]),out msg); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { int re = UserHelper.DelUsers(Request["DelKeyIDS"],out msg); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { SYS_USER val = new SYS_USER(); val.USER_ID = int.Parse(Request["FieldKeyID"]); List<AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]); } } BLLTable<SYS_USER>.Factory(conn).Update(val, SYS_USER.Attribute.USER_ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
public async Task TestInsertUserAsync() { SYS_USER user = new SYS_USER(); user.USER_NAME = "testUser"; user.REAL_NAME = "测试插入用户"; user.PASSWORD = "******"; user.CREATE_USERID = "1"; var task = m_SysUserDal.InsertAsync(user); await task; }
// GET: FLOW_PRODUCT/Create public ActionResult Create() { List <SYS_USER> categories = SYS_USER.GETALL(); ViewData["Categories"] = new SelectList(categories, "id", "cname"); List <FLOW_CLIENT> categoriesclient = FLOW_CLIENT.GETALL(); ViewData["Categoriesclient"] = new SelectList(categoriesclient, "id", "company_name"); return(View()); }
/// <summary> /// 存入Session /// </summary> /// <param name="LoginID"></param> public void SaveSession(SYS_LOGIN loginmodel) { List <UserMenuModel> mennulist = null; SYS_USER usermodel = null; List <SYS_ROLE> userrolelist = null; using (var dbcontext = DbFactory.Create()) { #region 获取用户菜单 var args1 = new DbParameter[] { new SqlParameter { ParameterName = "@id", Value = loginmodel.ID }, }; StringBuilder strmenuSql = new StringBuilder(); strmenuSql.Append(" SELECT distinct(M.MenuCode),M.MenuName,M.ParentCode,M.LinkAddress,M.Sort,M.IconScript FROM [SYS_USER] U "); strmenuSql.Append(" INNER JOIN [SYS_LOGIN] L ON L.UserName =U.UserName"); strmenuSql.Append(" INNER JOIN [SYS_ROLE_USER] R ON R.UserID=U.UserID"); strmenuSql.Append(" INNER JOIN [SYS_ROLE_MENU_BUTTON] MB ON R.RoleID=MB.RoleID"); strmenuSql.Append(" INNER JOIN [SYS_MENU] M ON M.MenuCode=MB.MenuCode WHERE L.ID=@id order by M.ParentCode,M.Sort"); mennulist = dbcontext.SqlQuery <UserMenuModel>(strmenuSql.ToString(), args1); #endregion #region 获取用户信息 Expression <Func <SYS_USER, bool> > exp = a => a.UserName == loginmodel.UserName; usermodel = dbcontext.Get(exp); #endregion #region 获取用户角色 var args2 = new DbParameter[] { new SqlParameter { ParameterName = "@userid", Value = usermodel.UserID }, }; StringBuilder strroleSql1 = new StringBuilder(); strroleSql1.Append(" SELECT R.* FROM [SYS_ROLE_USER] RU"); strroleSql1.Append(" INNER JOIN [SYS_USER] U ON RU.UserID=U.UserID"); strroleSql1.Append(" INNER JOIN [SYS_ROLE] R ON R.RoleID=RU.RoleID"); strroleSql1.Append(" WHERE U.UserID=@userid"); userrolelist = dbcontext.SqlQuery <SYS_ROLE>(strroleSql1.ToString(), args2); #endregion UserSession user = new UserSession(); user.Rolelist = userrolelist; user.Menulist = mennulist; user.AccountInfo = usermodel; user.logininfo = loginmodel; SessionHelper.Add("Account", user, 30); } }
//取得某一User 基本資料 public string getUser(string userid) { log.Info("get user id=" + userid); SYS_USER u = userService.getUser(userid); System.Web.Script.Serialization.JavaScriptSerializer objSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string userJson = objSerializer.Serialize(u); log.Info("user info=" + userJson); return(userJson); }
// GET: FLOW_PROJECT/Create public ActionResult Create() { List <SYS_USER> categories_user = SYS_USER.GETALL(); ViewData["Categories_user"] = new SelectList(categories_user, "id", "cname"); List <FLOW_PRODUCT> categories = FLOW_PRODUCT.GETALL(); ViewData["Categories_prod"] = new SelectList(categories, "id", "name"); return(View()); }
//退件 public String RejectForm(FormCollection form) { //取得表單資料 from Session Flow4CompanyExpense wfs = new Flow4CompanyExpense(); wfs.task = (ExpenseTask)Session["process"]; SYS_USER u = (SYS_USER)Session["user"]; wfs.Reject(u, null, form["RejectDesc"]); return(wfs.Message); }
private void BindList(SYS_USER condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(SYS_USER.Attribute.USER_ID, Order.Desc); } listObj = BLLTable <SYS_USER> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void Page_Load(object sender, EventArgs e) { SYS_USER ucond = new SYS_USER(); ucond.USER_ID =decimal.Parse( Request["SID"]); SYS_USER val = BLLTable<SYS_USER>.Factory(conn).GetRowData(new SYS_USER(), ucond); if (val != null) { PowerHelper.SetCurLoginUser(val); Response.Redirect(Request["url"]); } else { AgileFrame.Core.ScriptHelper.Alert(Page, "用户名或密码错误!请重新输入。"); } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new SYS_USER(); if(txtUSER_NAME.Value !="" ) condObj.Like(SYS_USER.Attribute.USER_NAME, Convert.ToString(txtUSER_NAME.Value)); if(txtSTATE_FLAG.Value !="" ) condObj.USE_FLAG = Convert.ToString(txtSTATE_FLAG.Value); if(txtUSER_TYPE.Value !="" ) condObj.USER_TYPE = Convert.ToString(txtUSER_TYPE.Value); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
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 aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<SYS_USER>(hidCondition.Value); } listObj = BLLTable<SYS_USER>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new SYS_USER(); if(txtUSER_ID.Value !="" ) condObj.Like(SYS_USER.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value)); if(txtUSER_NAME.Value !="" ) condObj.Like(SYS_USER.Attribute.USER_NAME, Convert.ToString(txtUSER_NAME.Value)); if(txtPASS.Value !="" ) condObj.Like(SYS_USER.Attribute.PASS, Convert.ToString(txtPASS.Value)); if(txtEMAIL.Value !="" ) condObj.Like(SYS_USER.Attribute.EMAIL, Convert.ToString(txtEMAIL.Value)); if(txtLOGIN_IPS.Value !="" ) condObj.Like(SYS_USER.Attribute.LOGIN_IPS, Convert.ToString(txtLOGIN_IPS.Value)); if(txtSTATE_FLAG.Value !="" ) condObj.USE_FLAG = Convert.ToString(txtSTATE_FLAG.Value); if(txtEDITIME.Value !="" ) condObj.Like(SYS_USER.Attribute.EDITTIME, Convert.ToDateTime(txtEDITIME.Value)); if(txtADDTIME.Value !="" ) condObj.Like(SYS_USER.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value)); if(txtUSER_TYPE.Value !="" ) condObj.USER_TYPE = Convert.ToString(txtUSER_TYPE.Value); listObj = BLLTable<SYS_USER>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; }
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账户已存在,并重新进行了密码初始化"); } }
private void BindList(SYS_USER condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(SYS_USER.Attribute.USER_ID, Order.Desc); listObj = BLLTable<SYS_USER>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
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"; }
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(); HR_DEPT_STAFF valdeps = new HR_DEPT_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; valdeps.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); valdeps.STAFF_ID = Convert.ToDecimal(keyid); //���²���Ա����ϵ HR_DEPT_STAFF conds = new HR_DEPT_STAFF(); conds.STAFF_ID = Convert.ToInt32(keyid); conds.DEPT_ID = hidDEPT_ID.Value; if (BLLTable<HR_DEPT_STAFF>.Exists(conds)) { BLLTable<HR_DEPT_STAFF>.Update(valdeps, conds); } else { BLLTable<HR_DEPT_STAFF>.Insert(valdeps); } } 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(); //��Ӳ���Ա����ϵ valdeps.STAFF_ID = Convert.ToDecimal(keyid); BLLTable<HR_DEPT_STAFF>.Insert(valdeps); } 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 { SYS_USER hadCond = new SYS_USER(); hadCond.USER_NAME = txtUSER_NAME.Value; if (BLLTable<SYS_USER>.Exists(hadCond)) { litWarn.Text = "���û����Ѿ����ڣ����������룡�����ơ�"; return; } 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) { string ipsStr = txtLOGIN_IPS.Value; if (!string.IsNullOrEmpty(ipsStr)) { string[] ips = ipsStr.Split(','); foreach (string ipstr in ips) { IPAddress ip = null; if (!IPAddress.TryParse(ipstr, out ip)) { Response.Write("<script type=\"text/javascript\">alert('IP��ַ" + ipstr + "��ʽ����');</script>"); return; } } if (ips.Length > 5) { Response.Write("<script type=\"text/javascript\">alert('����IP��������5����');</script>"); return; } } if (!string.IsNullOrEmpty(txtUSER_QQ.Value)) { decimal qq = -1; if (!decimal.TryParse(txtUSER_QQ.Value, out qq)) { Response.Write("<script type=\"text/javascript\">alert('QQ�Ÿ�ʽ����');</script>"); return; } } if (!string.IsNullOrEmpty(txtEMAIL.Value)) { if(!Regex.IsMatch(txtEMAIL.Value, @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$")) { Response.Write("<script type=\"text/javascript\">alert('Email��ַ��ʽ����');</script>"); 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 (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); #endregion 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); if (count > 0) Response.Write("<script type=\"text/javascript\">alert('����ɹ���');</script>"); else Response.Write("<script type=\"text/javascript\">alert('����ʧ�ܣ�');</script>"); } } 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; } }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { //Response.Write(keyid); txtSTATE_FLAG.Items.AddRange(FormHelper.GetListItem(SYS_USER.Attribute.USE_FLAG)); txtUSER_TYPE.Items.AddRange(FormHelper.GetListItem(SYS_USER.Attribute.USER_TYPE)); try { if (keyid != "") { valObj = BLLTable<SYS_USER>.Factory(conn).GetRowData(SYS_USER.Attribute.USER_ID, keyid); if (valObj == null) return; List<SYS_USERROLE> lst = BLLTable<SYS_USERROLE>.Factory(conn).Select(SYS_USERROLE.Attribute.USER_ID, keyid); string user_role = ""; if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { user_role += user_role == "" ? lst[i].ROLE_ID.ToString() : "," + lst[i].ROLE_ID; } } hidSelReals.Value = user_role; txtUSER_ID.Value = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal txtUSER_NAME.Value = Convert.ToString(valObj.USER_NAME);//Convert.ToString ViewState["txtUSER_NAME"] = valObj.USER_NAME; //txtPASS.Value = Convert.ToString(valObj.PASS);//Convert.ToString txtEMAIL.Value = Convert.ToString(valObj.EMAIL);//Convert.ToString txtLOGIN_IPS.Value = Convert.ToString(valObj.LOGIN_IPS);//Convert.ToString #region wk(�û������ֶ�) txtUSER_QQ.Value = Convert.ToString(valObj.USER_QQ);//Convert.ToString txtUSER_Taobao.Value = Convert.ToString(valObj.USER_Taobao);//Convert.ToString txtIS_FeiQ_Remind.Checked = Convert.ToBoolean(valObj.IS_FeiQ_Remind);//Convert.ToString txtIS_EMAIL_Remind.Value = Convert.ToString(valObj.IS_EMAIL_Remind);//Convert.ToString txtIS_Taobao_Remind.Value = Convert.ToString(valObj.IS_Taobao_Remind);//Convert.ToString txtIS_QQ_Remind.Value = Convert.ToString(valObj.IS_QQ_Remind);//Convert.ToString #endregion if (!string.IsNullOrEmpty(valObj.USE_FLAG)) { txtSTATE_FLAG.Value = valObj.USE_FLAG.ToString(); } if (!string.IsNullOrEmpty(valObj.USER_TYPE)) { txtUSER_TYPE.Value = valObj.USER_TYPE.ToString(); } HR_STAFF staff = BLLTable<HR_STAFF>.Factory(conn).GetRowData(HR_STAFF.Attribute.STAFF_ID, valObj.STAFF_ID); if (staff == null || staff.IsNull()) { litWarn.Text = "���˻�δ�ж�ӦԱ����Ϣ���������ӹ�����ɾ����Ч�˻�"; } else { wucSelStaff1.Staff_ID = staff.STAFF_ID; wucSelStaff1.Staff_NAME = valObj.REAL_NAME; //wk 2012��9��14�� 15:29:18 } btnSave.Enabled = false; } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
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, "用户名或密码错误!请重新输入。"); } }