/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_ZZJG_RYBM GetModel(string GH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select GH,DWBM,MC,DLBM,KL,YDDHHM,DZYJ,GZZH,YDWBM,YDWMC,SFLSRY,SFTZ,SFSC,XB,CAID from XT_ZZJG_RYBM ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where GH=:GH ");
OracleParameter[] parameters =
{
new OracleParameter(":GH", OracleType.Char, 4)
};
parameters[0].Value = GH;
EDRS.Model.XT_ZZJG_RYBM model = new EDRS.Model.XT_ZZJG_RYBM();
DataSet ds = null;
try
{
ds = DbHelperOra.Query(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_ZZJG_RYBM GetModel(string GH)", "EDRS.OracleDAL.XT_ZZJG_RYBM", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 密码修改
/// </summary>
/// <returns></returns>
private string AlterPwd()
{
string before = Request.Form.Get("pwd_before");
string news = Request.Form.Get("pwd_news");
string newsto = Request.Form.Get("pwd_newsTo");
//验证旧密码
if (before == null || string.IsNullOrEmpty(before))
{
return(ReturnString.JsonToString(Prompt.error, "旧密码不能为空", "pwd_before"));
}
if (!Regex.IsMatch(before, @"^(\w){6,20}$"))
{
return(ReturnString.JsonToString(Prompt.error, "旧密码输入不正确", "pwd_before"));
}
//验证新密码
if (news == null || string.IsNullOrEmpty(news))
{
return(ReturnString.JsonToString(Prompt.error, "新密码不能为空", "pwd_news"));
}
if (!Regex.IsMatch(news, @"^(\w){6,20}$"))
{
return(ReturnString.JsonToString(Prompt.error, "新密码输入不正确", "pwd_news"));
}
//验证新密码与旧密码相同
if (!news.Equals(newsto))
{
return(ReturnString.JsonToString(Prompt.error, "新密码与确认密码不一致！", "pwd_newsTo"));
}
//判断新密码与旧密码是否相同
if (before.Equals(news))
{
return(ReturnString.JsonToString(Prompt.error, "旧密码与新密码相同无须修改！", "pwd_news"));
}
EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(this.Request);
string msg = string.Empty;
List <EDRS.Model.XT_QX_JSBM> jsbmList;
EDRS.Model.XT_ZZJG_RYBM rybm = bll.UserLogin(UserInfo.DWBM, UserInfo.DLBM, before, out jsbmList, out msg);
if (rybm != null)
{
rybm.KL = MD5Encrypt.Encrypt(news).ToLower();
if (bll.Update(rybm))
{
return(ReturnString.JsonToString(Prompt.win, "密码修改成功，重新登录生效！", null));
}
return(ReturnString.JsonToString(Prompt.error, "密码修改失败！", null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
}
public virtual void ProcessRequest(HttpContext context)
{
if (null == context.Session["user"])
{
return;
}
_userInfo = context.Session["user"] as EDRS.Model.XT_ZZJG_RYBM;
if (null == context.Session["userDwbm"])
{
return;
}
_userDwbm = context.Session["userDwbm"] as EDRS.Model.XT_ZZJG_DWBM;
if (null == context.Session["userRole"])
{
return;
}
_userRole = context.Session["userRole"] as List <EDRS.Model.XT_QX_JSBM>;
string jsbms = "";
string bmbms = "";
for (int i = 0; i < UserRole.Count; i++)
{
jsbms += "'" + UserRole[i].JSBM + "'";
bmbms += "'" + UserRole[i].BMBM + "'";
if (i < UserRole.Count - 1)
{
jsbms += ",";
bmbms += ",";
}
}
this.jsbms = jsbms;
this.bmbms = bmbms;
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private string UserLogin()
{
//List<FromValue> list = JsonConvert.DeserializeObject<List<FromValue>>(data);
//if (list == null || list.Count == 0)
// return ReturnString.JsonToString(Prompt.error, "参数错误", "");
string type = "";
string name = "";
string value = "";
if (string.IsNullOrEmpty(Request.Form.Get("tree_select_id")) && string.IsNullOrEmpty(Request.Form.Get("tree_select_hid")))
{
return(ReturnString.JsonToString(Prompt.error, "请先选择单位", "tree_select"));
}
if (string.IsNullOrEmpty(Request.Form.Get("txtUser")))
{
return(ReturnString.JsonToString(Prompt.error, "用户名不能为空", "txtUser"));
}
if (!Regex.IsMatch(Request.Form.Get("txtUser").ToString(), @"^(\w){1,20}$"))
{
return(ReturnString.JsonToString(Prompt.error, "用户名输入不正确", "txtUser"));
}
if (string.IsNullOrEmpty(Request.Form.Get("txtPwd")))
{
return(ReturnString.JsonToString(Prompt.error, "密码不能为空", "txtPwd"));
}
if (!Regex.IsMatch(Request.Form.Get("txtPwd").ToString(), @"^(\w){6,20}$"))
{
return(ReturnString.JsonToString(Prompt.error, "密码输入不正确", "txtPwd"));
}
if (string.IsNullOrEmpty(Request.Form.Get("tree_select_id")))
{
type = Request.Form.Get("tree_select_hid");
}
else
{
type = Request.Form.Get("tree_select_id").ToString();
}
name = Request.Form.Get("txtUser").ToString();
value = Request.Form.Get("txtPwd").ToString();
//else if (fv.Name == "txtVCode")
//{
// if (string.IsNullOrEmpty(fv.Value.ToString().Trim()))
// return ReturnString.JsonToString(Prompt.error, "验证码不能为空", "txtVCode");
// if (HttpContext.Current.Session["ValidateCode"].ToString().ToLower() != fv.Value.ToString().ToLower())
// return ReturnString.JsonToString(Prompt.error, "验证码错误", "txtVCode");
//}
//}
//1bbd886460827015e5d605ed44252251 8个1 [a-zA-Z]\w{1,3}
EDRS.BLL.XT_ZZJG_RYBM bll = new EDRS.BLL.XT_ZZJG_RYBM(request);
string msg = string.Empty;
List <EDRS.Model.XT_QX_JSBM> jsbmList;
try
{
EDRS.BLL.XT_ZZJG_DWBM dwbmBll = new EDRS.BLL.XT_ZZJG_DWBM(request);
EDRS.Model.XT_ZZJG_DWBM dwbmmodel = dwbmBll.GetModel(type);
if (dwbmmodel == null)
{
return(ReturnString.JsonToString(Prompt.error, "选择单位不存在，请重新选择", null));
}
EDRS.Model.XT_ZZJG_RYBM rybm = bll.UserLogin(type, name, value, out jsbmList, out msg);
if (rybm != null)
{
HttpContext.Current.Session["user"] = rybm;
HttpContext.Current.Session["userDwbm"] = dwbmmodel;
if (jsbmList != null)
{
HttpContext.Current.Session["userRole"] = jsbmList;
}
HttpCookie cookie = new HttpCookie("login");
//cookie.Values[EDRS.Common.DEncrypt.DESEncrypt.Encrypt("UnitOption", "UnitOption")] = EDRS.Common.DEncrypt.DESEncrypt.Encrypt(rybm.DWBM, "UnitOption");
//cookie.Values[EDRS.Common.DEncrypt.DESEncrypt.Encrypt("UserName", "UserName")] = EDRS.Common.DEncrypt.DESEncrypt.Encrypt(rybm.DLBM, "UserName");
cookie.Values["UnitOption"] = rybm.DWBM;
cookie.Values["UnitOptionName"] = HttpUtility.UrlEncode(rybm.DWMC, Encoding.UTF8);
cookie.Values["UserName"] = HttpUtility.UrlEncode(rybm.DLBM, Encoding.UTF8);
cookie.Expires = DateTime.MaxValue;
HttpContext.Current.Response.Cookies.Add(cookie);
OperateLog.AddLog(OperateLog.LogType.登录系统, msg, rybm, jsbmList, request);
return(ReturnString.JsonToString(Prompt.win, msg, null));
}
else
{
rybm = new EDRS.Model.XT_ZZJG_RYBM();
XT_ZZJG_DWBM dwbmbll = new XT_ZZJG_DWBM(request);
EDRS.Model.XT_ZZJG_DWBM dwbm = dwbmbll.GetModel(type);
if (dwbm != null)
{
rybm.MC = name;
rybm.DWBM = dwbm.DWBM;
rybm.DWMC = dwbm.DWMC;
}
OperateLog.AddLog(OperateLog.LogType.登录系统, msg, rybm, jsbmList, request);
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
}
catch (Exception ex)
{
msg = Regex.Replace(ex.Message, "[\r\n\"]", "");
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.XT_ZZJG_RYBM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_ZZJG_RYBM(");
strSql.Append("GH,DWBM,MC,DLBM,KL,YDDHHM,DZYJ,GZZH,YDWBM,YDWMC,SFLSRY,SFTZ,ZP,SFSC,XB,CAID)");
strSql.Append(" values (");
strSql.Append(":GH,:DWBM,:MC,:DLBM,:KL,:YDDHHM,:DZYJ,:GZZH,:YDWBM,:YDWMC,:SFLSRY,:SFTZ,:ZP,:SFSC,:XB,:CAID)");
OracleParameter[] parameters =
{
new OracleParameter(":GH", OracleType.Char, 4),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":MC", OracleType.VarChar, 60),
new OracleParameter(":DLBM", OracleType.VarChar, 60),
new OracleParameter(":KL", OracleType.VarChar, 128),
new OracleParameter(":YDDHHM", OracleType.VarChar, 60),
new OracleParameter(":DZYJ", OracleType.VarChar, 60),
new OracleParameter(":GZZH", OracleType.VarChar, 20),
new OracleParameter(":YDWBM", OracleType.VarChar, 50),
new OracleParameter(":YDWMC", OracleType.VarChar, 300),
new OracleParameter(":SFLSRY", OracleType.Char, 1),
new OracleParameter(":SFTZ", OracleType.Char, 1),
new OracleParameter(":ZP", OracleType.Blob),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":XB", OracleType.Char, 1),
new OracleParameter(":CAID", OracleType.VarChar, 100)
};
parameters[0].Value = model.GH;
parameters[1].Value = model.DWBM;
parameters[2].Value = model.MC;
parameters[3].Value = model.DLBM;
parameters[4].Value = model.KL;
parameters[5].Value = model.YDDHHM;
parameters[6].Value = model.DZYJ;
parameters[7].Value = model.GZZH;
parameters[8].Value = model.YDWBM;
parameters[9].Value = model.YDWMC;
parameters[10].Value = model.SFLSRY;
parameters[11].Value = model.SFTZ;
parameters[12].Value = model.ZP.Length == 0 ? new byte[1] : model.ZP;
parameters[13].Value = model.SFSC;
parameters[14].Value = model.XB;
parameters[15].Value = model.CAID;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XT_ZZJG_RYBM model)", "EDRS.OracleDAL.XT_ZZJG_RYBM", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_ZZJG_RYBM DataRowToModel(DataRow row)
{
EDRS.Model.XT_ZZJG_RYBM model = new EDRS.Model.XT_ZZJG_RYBM();
if (row != null)
{
if (row["GH"] != null)
{
model.GH = row["GH"].ToString();
}
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["DWMC"] != null)
{
model.DWMC = row["DWMC"].ToString();
}
if (row["MC"] != null)
{
model.MC = row["MC"].ToString();
}
if (row["DLBM"] != null)
{
model.DLBM = row["DLBM"].ToString();
}
if (row["KL"] != null)
{
model.KL = row["KL"].ToString();
}
if (row["YDDHHM"] != null)
{
model.YDDHHM = row["YDDHHM"].ToString();
}
if (row["DZYJ"] != null)
{
model.DZYJ = row["DZYJ"].ToString();
}
if (row["GZZH"] != null)
{
model.GZZH = row["GZZH"].ToString();
}
if (row["YDWBM"] != null)
{
model.YDWBM = row["YDWBM"].ToString();
}
if (row["YDWMC"] != null)
{
model.YDWMC = row["YDWMC"].ToString();
}
if (row["SFLSRY"] != null)
{
model.SFLSRY = row["SFLSRY"].ToString();
}
if (row["SFTZ"] != null)
{
model.SFTZ = row["SFTZ"].ToString();
}
if (row.Table.Columns.Contains("ZP") && row["ZP"] != null && row["ZP"].ToString() != "")
{
model.ZP = (byte[])row["ZP"];
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
if (row["XB"] != null)
{
model.XB = row["XB"].ToString();
}
if (row["CAID"] != null)
{
model.CAID = row["CAID"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_ZZJG_RYBM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_ZZJG_RYBM set ");
strSql.Append("MC=:MC,");
strSql.Append("DLBM=:DLBM,");
strSql.Append("KL=:KL,");
strSql.Append("YDDHHM=:YDDHHM,");
strSql.Append("DZYJ=:DZYJ,");
strSql.Append("GZZH=:GZZH,");
strSql.Append("YDWBM=:YDWBM,");
strSql.Append("YDWMC=:YDWMC,");
strSql.Append("SFLSRY=:SFLSRY,");
strSql.Append("SFTZ=:SFTZ,");
strSql.Append("ZP=:ZP,");
strSql.Append("SFSC=:SFSC,");
strSql.Append("XB=:XB,");
strSql.Append("CAID=:CAID");
strSql.Append(" where DWBM=:DWBM and GH=:GH ");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":MC", OracleType.VarChar, 60),
new OracleParameter(":DLBM", OracleType.VarChar, 60),
new OracleParameter(":KL", OracleType.VarChar, 128),
new OracleParameter(":YDDHHM", OracleType.VarChar, 60),
new OracleParameter(":DZYJ", OracleType.VarChar, 60),
new OracleParameter(":GZZH", OracleType.VarChar, 20),
new OracleParameter(":YDWBM", OracleType.VarChar, 50),
new OracleParameter(":YDWMC", OracleType.VarChar, 300),
new OracleParameter(":SFLSRY", OracleType.Char, 1),
new OracleParameter(":SFTZ", OracleType.Char, 1),
new OracleParameter(":ZP", OracleType.Blob),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":XB", OracleType.Char, 1),
new OracleParameter(":CAID", OracleType.VarChar, 100),
new OracleParameter(":GH", OracleType.Char, 4)
};
parameters[0].Value = model.DWBM;
parameters[1].Value = model.MC;
parameters[2].Value = model.DLBM;
parameters[3].Value = model.KL;
parameters[4].Value = model.YDDHHM;
parameters[5].Value = model.DZYJ;
parameters[6].Value = model.GZZH;
parameters[7].Value = model.YDWBM;
parameters[8].Value = model.YDWMC;
parameters[9].Value = model.SFLSRY;
parameters[10].Value = model.SFTZ;
parameters[11].Value = model.ZP == null ? new byte[1] : model.ZP;
parameters[12].Value = model.SFSC;
parameters[13].Value = model.XB;
parameters[14].Value = model.CAID;
parameters[15].Value = model.GH;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.XT_ZZJG_RYBM model)", "EDRS.OracleDAL.XT_ZZJG_RYBM", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
