/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_ZZJG_DWBM DataRowToModel(DataRow row)
{
EDRS.Model.XT_ZZJG_DWBM model = new EDRS.Model.XT_ZZJG_DWBM();
if (row != null)
{
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["DWMC"] != null)
{
model.DWMC = row["DWMC"].ToString();
}
if (row["DWJC"] != null)
{
model.DWJC = row["DWJC"].ToString();
}
if (row["DWJB"] != null)
{
model.DWJB = row["DWJB"].ToString();
}
if (row["FDWBM"] != null)
{
model.FDWBM = row["FDWBM"].ToString();
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
}
return(model);
}
/// <summary>
/// 添加单位数据
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
EDRS.Model.XT_ZZJG_DWBM model = new EDRS.Model.XT_ZZJG_DWBM();
model.FDWBM = Request.Form.Get("hidd_superiorNumber").Trim();
model.DWMC = Request.Form.Get("txt_name").Trim();
model.DWJC = Request.Form.Get("txt_abbreviation").Trim();
model.DWBM = Request.Form.Get("txt_number").Trim();
model.DWJB = Request.Form.Get("txt_rank").Trim();
XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request);
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "添加单位成功", model.DWMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "添加单位失败", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败，请先确认单位编码是否已存在", null));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_ZZJG_DWBM GetModel(string DWBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select DWBM,DWMC,DWJC,DWJB,FDWBM,SFSC from XT_ZZJG_DWBM ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where DWBM=:DWBM ");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters[0].Value = DWBM;
EDRS.Model.XT_ZZJG_DWBM model = new EDRS.Model.XT_ZZJG_DWBM();
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_DWBM GetModel(string DWBM)", "EDRS.OracleDAL.XT_ZZJG_DWBM", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_ZZJG_DWBM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_ZZJG_DWBM set ");
strSql.Append("DWMC=:DWMC,");
strSql.Append("DWJC=:DWJC,");
strSql.Append("DWJB=:DWJB,");
strSql.Append("FDWBM=:FDWBM,");
strSql.Append("SFSC=:SFSC");
strSql.Append(" where DWBM=:DWBM ");
OracleParameter[] parameters =
{
new OracleParameter(":DWMC", OracleType.VarChar, 300),
new OracleParameter(":DWJC", OracleType.VarChar, 60),
new OracleParameter(":DWJB", OracleType.Char, 1),
new OracleParameter(":FDWBM", OracleType.VarChar, 50),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters[0].Value = model.DWMC;
parameters[1].Value = model.DWJC;
parameters[2].Value = model.DWJB;
parameters[3].Value = model.FDWBM;
parameters[4].Value = model.SFSC;
parameters[5].Value = model.DWBM;
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_DWBM model)", "EDRS.OracleDAL.XT_ZZJG_DWBM", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dwbm"></param>
/// <returns></returns>
private string UpData()
{
string dwbm = Request.Form.Get("key_hidd");
if (string.IsNullOrEmpty(dwbm) || !Regex.IsMatch(dwbm.Trim(), @"^[A-Za-z0-9]{1,50}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request);
EDRS.Model.XT_ZZJG_DWBM model = bll.GetModel(dwbm.Trim());
if (model != null)
{
model.FDWBM = Request.Form.Get("hidd_superiorNumber").Trim();
model.DWMC = Request.Form.Get("txt_name").Trim();
model.DWJC = Request.Form.Get("txt_abbreviation").Trim();
//model.DWBM = Request.Form.Get("txt_number").Trim();
model.DWJB = Request.Form.Get("txt_rank").Trim();
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "修改单位成功", model.DWMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "修改单位失败", model.DWMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "修改单位未找到修改信息", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", 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>
/// <returns></returns>
private string GetModelOrParentList(string DWBM)
{
if (string.IsNullOrEmpty(DWBM))
{
DWBM = Request["id"];
if (string.IsNullOrEmpty(DWBM))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request);
EDRS.Model.XT_ZZJG_DWBM model = bll.GetModel(DWBM);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "根据编号获取单位成功", Request["dwmc"], UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "根据编号获取单位失败", Request["dwmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 绑定数据列表
/// </summary>
/// <returns></returns>
private string ListBindDW()
{
//数据查询条件
string where = string.Empty;
object[] values = new object[3];
where += " and SFSC=:SFSC";
values[0] = "N";
string key = Request["key"];
if (!string.IsNullOrEmpty(key))
{
where += " and (DWMC like :DWMC or DWJC like :DWJC)";
values[1] = "%" + key + "%";
values[2] = "%" + key + "%";
}
string levelNumber = "3";
string level = Request["level"];
if (level != null && !string.IsNullOrEmpty(level) && level != "0")
{
levelNumber = level;
}
//树形循环条件
bool direction = true;
bool isOpen = false;
string withWhere = string.Empty;
string levelNum = " and level < " + levelNumber;
bool isNameAll = false;
string pid = Request["pid"];
string parentid = "";
XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request);
if (!string.IsNullOrEmpty(pid))
{
withWhere = (string.IsNullOrEmpty(withWhere) ? " 1=1 " : withWhere) + " and FDWBM = '" + pid + "'";
}
else if (base.UserInfo != null) //判断根据登录用户进行筛选数据
{
withWhere = (string.IsNullOrEmpty(withWhere) ? " 1=1 " : withWhere) + " and DWBM='" + base.UserInfo.DWBM + "' ";
if (string.IsNullOrEmpty(pid))
{
EDRS.Model.XT_ZZJG_DWBM model = bll.GetModel(base.UserInfo.DWBM);
if (model != null)
{
pid = model.FDWBM;
parentid = pid;
}
else
{
pid = base.UserInfo.DWBM;
}
}
}
//根据搜索名称查询节点
string treeText = Request["treeText"];
if (!string.IsNullOrEmpty(treeText))
{
withWhere = (string.IsNullOrEmpty(withWhere) ? " 1=1 " : withWhere) + " and DWMC like '%" + treeText + "%'";
direction = false;
levelNum = "";
isOpen = true;
}
if (Request["bmbm"] != null && Request["jsbm"] != null && !string.IsNullOrEmpty(Request["bmbm"]) && !string.IsNullOrEmpty(Request["jsbm"]))
{
where += " AND DWBM not IN (SELECT distinct qxbm FROM xt_dm_qx WHERE trim(JSBM) = '" + Request["jsbm"].Replace("a", "") + "' AND TRIM(DWBM)='" + base.UserInfo.DWBM + "' AND TRIM(BMBM)='" + Request["bmbm"].Replace("a", "") + "' and QXLX='0')";
}
if (string.IsNullOrEmpty(withWhere))
{
withWhere = " FDWBM is NULL ";
}
where += levelNum;
try
{
DataSet ds = bll.GetTreeList(where, withWhere, direction, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
dt.Columns["DWBM"].ColumnName = "ID";
dt.Columns["FDWBM"].ColumnName = "PARENTID";
dt.Columns["DWMC"].ColumnName = "NAME";
return(new TreeJson(dt, "ID", "NAME", "PARENTID", "ISLEAF", parentid, string.IsNullOrEmpty(pid) ? "" : pid, isOpen, isNameAll).ResultJson.ToString());
}
return(ReturnString.JsonToString(Prompt.error, "未找到单位的数据", null));
}
catch (Exception ex)
{
return(ReturnString.JsonToString(Prompt.error, ex.Message, null));
}
}
/// <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>
/// <returns></returns>
private string ListBind()
{
//int pageNumber = 1; //int.Parse(Request["page"]);
//int pageSize = int.MaxValue;// int.Parse(Request["rows"]);
string where = string.Empty;
//树形循环条件
bool direction = true;
bool isOpen = false;
string withWhere = string.Empty;
string levelNum = " and level < " + (Request["level"] == null ? 3 : int.Parse(Request["level"].ToString()));
string isLeaf = "ISLEAF";
string parentid = "";
XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request);
object[] values = new object[1];
where += " and SFSC=:SFSC";
values[0] = "N";
//关键字搜索
string key = Request["key"];
//获取父级节点
string pid = "";
if (base.UserInfo != null) //判断根据登录用户进行筛选数据
{
withWhere = " DWBM='" + UserInfo.DWBM + "' ";
if (string.IsNullOrEmpty(pid))
{
EDRS.Model.XT_ZZJG_DWBM model = bll.GetModel(UserInfo.DWBM);
if (model != null)
{
pid = model.FDWBM;
parentid = pid;
}
else
{
pid = UserInfo.DWBM;
}
}
}
if (!string.IsNullOrEmpty(key) && !string.IsNullOrEmpty(Request["pid"]))
{
pid = Request["pid"];
withWhere = " (DWMC like '%" + StringPlus.ReplaceSingle(key) + "%' or DWJC like '%" + StringPlus.ReplaceSingle(key) + "%') and FDWBM = '" + pid + "'";
}
else if (!string.IsNullOrEmpty(key))
{
pid = UserInfo.DWBM;
withWhere = " (DWMC like '%" + StringPlus.ReplaceSingle(key) + "%' or DWJC like '%" + StringPlus.ReplaceSingle(key) + "%') and FDWBM = '" + pid + "'";
direction = true;
levelNum = "";
isOpen = true;
isLeaf = "";
}
else if (!string.IsNullOrEmpty(Request["pid"]))
{
pid = Request["pid"];
withWhere = " FDWBM = '" + StringPlus.ReplaceSingle(Request["pid"].ToString()) + "'";
}
if (string.IsNullOrEmpty(withWhere))
{
withWhere = " FDWBM is NULL ";
}
where += levelNum;
DataSet ds = bll.GetTreeList(where, withWhere, direction, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "获取单位列表", UserInfo, UserRole, this.Request);
return("{\"Rows\":" + new TreeJson(dt, "DWBM", "DWMC", "FDWBM", isLeaf, parentid, string.IsNullOrEmpty(pid) ? "" : pid, isOpen, true).ResultJson.ToString() + ",\"Total\":100}");
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.单位管理Web, "单位列表未找到数据", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到单位信息！", null));
}
