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, "用户名或密码错误！请重新输入。");
}
}
