protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_TEMPUSER();
if(txtID.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.ID, Convert.ToDecimal(txtID.Value));
if(txtNAME.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.NAME, Convert.ToString(txtNAME.Value));
if(txtCONAME.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.CONAME, Convert.ToString(txtCONAME.Value));
if(txtPHONE.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));
if(txtIP.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.IP, Convert.ToString(txtIP.Value));
if(txtADDTIME.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));
if(txtLOGINNAME.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.LOGINNAME, Convert.ToString(txtLOGINNAME.Value));
if(txtPWD.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.PWD, Convert.ToString(txtPWD.Value));
if(txtUSER_ID.Value !="" )
condObj.Like(SYS_TEMPUSER.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_TEMPUSER>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_TEMPUSER>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
recount = aspPager.RecordCount;
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_TEMPUSER>(hidCondition.Value);
}
List<SYS_TEMPUSER> listVal = BLLTable<SYS_TEMPUSER>.SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repList.DataSource = listVal;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_TEMPUSER();
if(txtID.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.ID, Convert.ToDecimal(txtID.Value));
if(txtNAME.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.NAME, Convert.ToString(txtNAME.Value));
if(txtCONAME.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.CONAME, Convert.ToString(txtCONAME.Value));
if(txtPHONE.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));
if(txtIP.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.IP, Convert.ToString(txtIP.Value));
if(txtADDTIME.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));
if(txtLOGINNAME.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.LOGINNAME, Convert.ToString(txtLOGINNAME.Value));
if(txtPWD.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.PWD, Convert.ToString(txtPWD.Value));
if(txtUSER_ID.Value !="" )
condObj.Like_OR(SYS_TEMPUSER.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value));
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable<SYS_TEMPUSER>.SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelID"] != null)
{
int re = BLLTable<SYS_TEMPUSER>.Delete(SYS_TEMPUSER.Attribute.ID, Request["DelID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
SYS_TEMPUSER cond = new SYS_TEMPUSER();
cond.In(SYS_TEMPUSER.Attribute.ID, Request["DelKeyIDS"]);
int re = BLLTable<SYS_TEMPUSER>.Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
SYS_TEMPUSER val = new SYS_TEMPUSER();
val.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_TEMPUSER>.Update(val, SYS_TEMPUSER.Attribute.ID);
Response.Write("���û���Ϣ�ɹ�");
}
if (!IsPostBack)
{
string strRet = "";
//��ȡ��������
switch (Common.GetReqStrValue("action"))
{
//��ȡ��֤��
case "GetCheckNum":
strRet = GetCheckNum();
break;
//��ȡ��֤��
case "Add":
strRet = InsertUser();
break;
default:
strRet = "";
break;
}
Response.Write(strRet);
}
Response.End();
}
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 Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["ID"]))
{
valObj = BLLTable <SYS_TEMPUSER> .GetRowData(SYS_TEMPUSER.Attribute.ID, Request["ID"]);
if (valObj == null)
{
return;
}
txtID.Text = Convert.ToString(valObj.ID);//Convert.ToDecimal
txtNAME.Text = Convert.ToString(valObj.NAME);//Convert.ToString
txtCONAME.Text = Convert.ToString(valObj.CONAME);//Convert.ToString
txtPHONE.Text = Convert.ToString(valObj.PHONE);//Convert.ToString
txtIP.Text = Convert.ToString(valObj.IP);//Convert.ToString
txtADDTIME.Text = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm");
txtLOGINNAME.Text = Convert.ToString(valObj.LOGINNAME);//Convert.ToString
txtPWD.Text = Convert.ToString(valObj.PWD);//Convert.ToString
txtUSER_ID.Text = Convert.ToString(valObj.USER_ID);//Convert.ToDecimal
}
}
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 Page_Load(object sender, EventArgs e)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(SYS_TEMPUSER.Attribute.EXP1);
//hideTableColumnList.Add(SYS_TEMPUSER.Attribute.EXP2);
//hideTableColumnList.Add(SYS_TEMPUSER.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(SYS_TEMPUSER.Attribute.EXP1);
//hideFindColumnList.Add(SYS_TEMPUSER.Attribute.EXP2);
//hideFindColumnList.Add(SYS_TEMPUSER.Attribute.EXP3);
#endregion
condObj.OrderBy(SYS_TEMPUSER.Attribute.ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
SYS_TEMPUSER roleOld = new SYS_TEMPUSER();
roleOld.Where(SYS_TEMPUSER.Attribute.ID, Request["ids"].ToString());
listObj = BLLTable<SYS_TEMPUSER>.Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].ID + "',Name:'" + listObj[i].ID + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].ID;
}
}
try
{
listObj = BLLTable<SYS_TEMPUSER>.SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
private void BindList(SYS_TEMPUSER condObj, int curPage)
{
if (valObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
valObj.af_PageBy(SYS_TEMPUSER.Attribute.ID, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<SYS_TEMPUSER>.SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelID"] != null)
{
int re = BLLTable <SYS_TEMPUSER> .Delete(SYS_TEMPUSER.Attribute.ID, Request["DelID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
SYS_TEMPUSER cond = new SYS_TEMPUSER();
cond.In(SYS_TEMPUSER.Attribute.ID, Request["DelKeyIDS"]);
int re = BLLTable <SYS_TEMPUSER> .Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
SYS_TEMPUSER val = new SYS_TEMPUSER();
val.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_TEMPUSER> .Update(val, SYS_TEMPUSER.Attribute.ID);
Response.Write("修改用户信息成功");
}
if (!IsPostBack)
{
string strRet = "";
//获取操作类型
switch (Common.GetReqStrValue("action"))
{
//获取验证码
case "GetCheckNum":
strRet = GetCheckNum();
break;
//获取验证码
case "Add":
strRet = InsertUser();
break;
default:
strRet = "";
break;
}
Response.Write(strRet);
}
Response.End();
}
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 btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_TEMPUSER();
if (txtID.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.ID, Convert.ToDecimal(txtID.Value));
}
if (txtNAME.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.NAME, Convert.ToString(txtNAME.Value));
}
if (txtCONAME.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.CONAME, Convert.ToString(txtCONAME.Value));
}
if (txtPHONE.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.PHONE, Convert.ToString(txtPHONE.Value));
}
if (txtIP.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.IP, Convert.ToString(txtIP.Value));
}
if (txtADDTIME.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value));
}
if (txtLOGINNAME.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.LOGINNAME, Convert.ToString(txtLOGINNAME.Value));
}
if (txtPWD.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.PWD, Convert.ToString(txtPWD.Value));
}
if (txtUSER_ID.Value != "")
{
condObj.Like_OR(SYS_TEMPUSER.Attribute.USER_ID, Convert.ToDecimal(txtUSER_ID.Value));
}
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable <SYS_TEMPUSER> .SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
