/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ITC_Userinfo_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ITC_Userinfo(");
strSql.Append("User_ID,User_Mobile,User_Createdtime,User_Status,User_Oprt,User_Remark,Orga_ID,User_Account,User_Pwd,User_Name,User_Spelling,User_Sex,User_Email,User_Tel");
strSql.Append(") values (");
strSql.Append("@User_ID,@User_Mobile,@User_Createdtime,@User_Status,@User_Oprt,@User_Remark,@Orga_ID,@User_Account,@User_Pwd,@User_Name,@User_Spelling,@User_Sex,@User_Email,@User_Tel");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@User_ID", SqlDbType.Char, 8),
new SqlParameter("@User_Mobile", SqlDbType.VarChar, 15),
new SqlParameter("@User_Createdtime", SqlDbType.DateTime),
new SqlParameter("@User_Status", SqlDbType.Int, 4),
new SqlParameter("@User_Oprt", SqlDbType.VarChar, 50),
new SqlParameter("@User_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Orga_ID", SqlDbType.Char, 8),
new SqlParameter("@User_Account", SqlDbType.VarChar, 50),
new SqlParameter("@User_Pwd", SqlDbType.VarChar, 50),
new SqlParameter("@User_Name", SqlDbType.VarChar, 50),
new SqlParameter("@User_Spelling", SqlDbType.VarChar, 50),
new SqlParameter("@User_Sex", SqlDbType.Bit, 1),
new SqlParameter("@User_Email", SqlDbType.VarChar, 50),
new SqlParameter("@User_Tel", SqlDbType.VarChar, 15)
};
parameters[0].Value = model.User_ID;
parameters[1].Value = model.User_Mobile;
parameters[2].Value = model.User_Createdtime;
parameters[3].Value = model.User_Status;
parameters[4].Value = model.User_Oprt;
parameters[5].Value = model.User_Remark;
parameters[6].Value = model.Orga_ID;
parameters[7].Value = model.User_Account;
parameters[8].Value = model.User_Pwd;
parameters[9].Value = model.User_Name;
parameters[10].Value = model.User_Spelling;
parameters[11].Value = model.User_Sex;
parameters[12].Value = model.User_Email;
parameters[13].Value = model.User_Tel;
int result = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 初始化用户信息、菜单操作权限
/// </summary>
/// <param name="id"></param>
public static void Init(string userid)
{
if (userid != null && userid != "")
{
ITC_Userinfo usr = new ITC_Userinfo();
ITC_Userinfo_M model_usr = usr.GetModel(userid);
if (model_usr != null)
{
System.Web.HttpContext.Current.Session[SessionKeys.UserID.ToString()] = model_usr.User_ID;
System.Web.HttpContext.Current.Session[SessionKeys.UserName.ToString()] = model_usr.User_Name;
System.Web.HttpContext.Current.Session[SessionKeys.OrgaID.ToString()] = model_usr.Orga_ID;
System.Web.HttpContext.Current.Session[SessionKeys.Power.ToString()] = usr.GetUserRoleOperater(model_usr.User_ID);
System.Web.HttpContext.Current.Session[SessionKeys.Orgas.ToString()] = usr.GetOrgaIDs(model_usr.User_ID);
}
}
}
private List <ITC_Userinfo_M> DsToList(DataSet ds)
{
List <ITC_Userinfo_M> list = new List <ITC_Userinfo_M>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ITC_Userinfo_M model = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new ITC_Userinfo_M();
model.User_ID = ds.Tables[0].Rows[i]["User_ID"].ToString().Trim();
model.User_Mobile = ds.Tables[0].Rows[i]["User_Mobile"].ToString();
if (ds.Tables[0].Rows[i]["User_Createdtime"].ToString() != "")
{
model.User_Createdtime = DateTime.Parse(ds.Tables[0].Rows[i]["User_Createdtime"].ToString());
}
if (ds.Tables[0].Rows[i]["User_Status"].ToString() != "")
{
model.User_Status = int.Parse(ds.Tables[0].Rows[i]["User_Status"].ToString());
}
model.User_Oprt = ds.Tables[0].Rows[i]["User_Oprt"].ToString();
model.User_Remark = ds.Tables[0].Rows[i]["User_Remark"].ToString();
model.Orga_ID = ds.Tables[0].Rows[i]["Orga_ID"].ToString().Trim();
model.User_Account = ds.Tables[0].Rows[i]["User_Account"].ToString();
model.User_Pwd = ds.Tables[0].Rows[i]["User_Pwd"].ToString();
model.User_Name = ds.Tables[0].Rows[i]["User_Name"].ToString();
model.User_Spelling = ds.Tables[0].Rows[i]["User_Spelling"].ToString();
if (ds.Tables[0].Rows[i]["User_Sex"].ToString() != "")
{
if ((ds.Tables[0].Rows[i]["User_Sex"].ToString() == "1") || (ds.Tables[0].Rows[i]["User_Sex"].ToString().ToLower() == "true"))
{
model.User_Sex = true;
}
else
{
model.User_Sex = false;
}
}
model.User_Email = ds.Tables[0].Rows[i]["User_Email"].ToString();
model.User_Tel = ds.Tables[0].Rows[i]["User_Tel"].ToString();
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 登录验证
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult DL(ITC_Userinfo_M model)
{
if (!string.IsNullOrEmpty(model.User_ID) && !string.IsNullOrEmpty(model.User_Pwd))
{
ITC_Userinfo bll = new ITC_Userinfo();
model.User_Pwd = bll.pwEcncrystr(model.User_Pwd);
if (bll.Exists(model.User_ID, model.User_Pwd))
{
UserContext.Init(model.User_ID);
//设置登录cookie，名称为：SdlCookie
HttpCookie SdlCookie = new HttpCookie("SdlCookie");
//EmpNo:登录工号
SdlCookie["EmpNo"] = UserContext.UserID;
//EmpName:姓名
SdlCookie["EmpName"] = System.Web.HttpContext.Current.Server.UrlEncode(UserContext.UserName);
//LastLoginTime:上次登录日期
//LastLoginIP:上次登录IP
if (false)
{
//SdlCookie["LastLoginTime"] = model_log_last.Entry.ToString();
//SdlCookie["LastLoginIP"] = model_log_last.IP;
}
else
{
SdlCookie["LastLoginTime"] = "";
SdlCookie["LastLoginIP"] = "";
}
System.Web.HttpContext.Current.Response.Cookies.Add(SdlCookie);
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.message = "帐号和密码不正确！请重新输入！";
ViewBag.SysName = "盒子系统";
return(View("Index"));
}
}
else
{
ViewBag.message = "请输入帐号和密码！";
ViewBag.SysName = "盒子系统";
return(View("Index"));
}
}
//保存用户角色
public ActionResult SaveRoles(FormCollection collection)
{
string userid = Request["userid"];
if (!string.IsNullOrEmpty(userid))
{
//删除角色 部门范围
uifo.DeleteRoles(userid);
uifo.DeleteRoleRange(userid);
if (collection.Count > 0)
{
string roleid = "";
string orgaid = "";
for (int i = 0; i < collection.Count; i++)
{
string key = collection.Keys[i];
string value = collection[i];
roleid = key.Split('|')[0];
orgaid = key.Split('|')[1];
//添加角色 部门范围
if (value == "on")
{
uifo.AddRoles(userid, roleid);
uifo.AddRoleRange(userid, roleid, orgaid);
}
}
}
ITC_Userinfo_M model = uifo.GetModel(userid);
model.User_Oprt = Session["username"].ToString();
model.User_Createdtime = DateTime.Now;
uifo.Update(model);
EventContext.Add(MenuID, string.Format("分配角色:{0}", userid));
return(Content("保存成功!"));
}
else
{
return(Content("参数错误!"));
}
}
//编辑保存
public ActionResult SaveEdit(ITC_Userinfo_M model)
{
model.User_Createdtime = DateTime.Now;
model.User_Account = model.User_ID.Trim();
model.User_Oprt = UserContext.UserName;
if (uifo.Exists(model.User_ID))
{
if (uifo.Update(model))
{
EventContext.Add(MenuID, string.Format("修改:{0}", model.User_ID));
return(Content("保存成功!"));
}
else
{
return(Content("保存失败!"));
}
}
else
{
return(Content("保存失败! 编码[" + model.User_ID + "]不存在!"));
}
}
//添加保存
public ActionResult SaveAdd(ITC_Userinfo_M model)
{
model.User_Createdtime = DateTime.Now;
model.User_Pwd = uifo.pwEcncrystr("123456");//加密
model.User_Account = model.User_ID.Trim();
model.User_Oprt = UserContext.UserName;
if (!uifo.Exists(model.User_ID))
{
if (uifo.Add(model))
{
EventContext.Add(MenuID, string.Format("添加:{0}", model.User_ID));
return(Content("保存成功!"));
}
else
{
return(Content("保存失败!"));
}
}
else
{
return(Content("保存失败! 编码[" + model.User_ID + "]已存在!"));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(ITC_Userinfo_M model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(ITC_Userinfo_M model)
{
return(dal.Add(model));
}
/// <summary>
/// 获取用户名称
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public string GetUserName(string userid)
{
ITC_Userinfo_M model = GetModel(userid);
return(model != null ? model.User_Name : "");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITC_Userinfo_M model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ITC_Userinfo set ");
strSql.Append(" User_Mobile = @User_Mobile , ");
strSql.Append(" User_Createdtime = @User_Createdtime , ");
strSql.Append(" User_Status = @User_Status , ");
strSql.Append(" User_Oprt = @User_Oprt , ");
strSql.Append(" User_Remark = @User_Remark , ");
strSql.Append(" Orga_ID = @Orga_ID , ");
strSql.Append(" User_Account = @User_Account , ");
//strSql.Append(" User_Pwd = @User_Pwd , ");
strSql.Append(" User_Name = @User_Name , ");
strSql.Append(" User_Spelling = @User_Spelling , ");
strSql.Append(" User_Sex = @User_Sex , ");
strSql.Append(" User_Email = @User_Email , ");
strSql.Append(" User_Tel = @User_Tel ");
strSql.Append(" where User_ID=@User_ID ");
SqlParameter[] parameters =
{
new SqlParameter("@User_ID", SqlDbType.Char, 8),
new SqlParameter("@User_Mobile", SqlDbType.VarChar, 15),
new SqlParameter("@User_Createdtime", SqlDbType.DateTime),
new SqlParameter("@User_Status", SqlDbType.Int, 4),
new SqlParameter("@User_Oprt", SqlDbType.VarChar, 50),
new SqlParameter("@User_Remark", SqlDbType.VarChar, 500),
new SqlParameter("@Orga_ID", SqlDbType.Char, 8),
new SqlParameter("@User_Account", SqlDbType.VarChar, 50),
new SqlParameter("@User_Pwd", SqlDbType.VarChar, 50),
new SqlParameter("@User_Name", SqlDbType.VarChar, 50),
new SqlParameter("@User_Spelling", SqlDbType.VarChar, 50),
new SqlParameter("@User_Sex", SqlDbType.Bit, 1),
new SqlParameter("@User_Email", SqlDbType.VarChar, 50),
new SqlParameter("@User_Tel", SqlDbType.VarChar, 15)
};
parameters[0].Value = model.User_ID;
parameters[1].Value = model.User_Mobile;
parameters[2].Value = model.User_Createdtime;
parameters[3].Value = model.User_Status;
parameters[4].Value = model.User_Oprt;
parameters[5].Value = model.User_Remark;
parameters[6].Value = model.Orga_ID;
parameters[7].Value = model.User_Account;
parameters[8].Value = model.User_Pwd;
parameters[9].Value = model.User_Name;
parameters[10].Value = model.User_Spelling;
parameters[11].Value = model.User_Sex;
parameters[12].Value = model.User_Email;
parameters[13].Value = model.User_Tel;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//获取模型
public ActionResult GetModel(string id)
{
ITC_Userinfo_M mo = uifo.GetModel(id);
return(Json(mo, JsonRequestBehavior.AllowGet));
}
