/// <summary>
/// 修改用户最后操作时间
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message MdyLastOpTime(T_SYSSEC_IPSUSER_Model m)
{
//判断用户序号是否存在于系统扩展表中
if (T_SYSSEC_USER.isExists(new T_SYSSEC_IPSUSER_SW {
USERID = m.USERID
}) == false)
{
return(new Message(false, "修改失败，系统用户不存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("update T_SYSSEC_USER");
sb.AppendFormat(" set ");
sb.AppendFormat(" LASTOPTIME='{0}'", ClsSql.EncodeSql(PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now)));
sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(T_SYSSEC_IPSUSER_Model m)
{
//判断用户序号是否存在于系统扩展表中
if (T_SYSSEC_USER.isExists(new T_SYSSEC_IPSUSER_SW {
USERID = m.USERID
}) == false)
{
return(new Message(false, "添加失败，系统用户不存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO T_SYSSEC_IPSUSER(USERID,SEX,PHONE,USERJOB)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.USERID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SEX));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PHONE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.USERJOB));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(T_SYSSEC_IPSUSER_Model m)
{
//判断用户序号是否存在于系统扩展表中
if (T_SYSSEC_USER.isExists(new T_SYSSEC_IPSUSER_SW {
USERID = m.USERID
}) == false)
{
return(new Message(false, "修改失败，系统用户不存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("update T_SYSSEC_IPSUSER");
sb.AppendFormat(" set ");
sb.AppendFormat(" SEX='{0}'", ClsSql.EncodeSql(m.SEX));
sb.AppendFormat(",PHONE='{0}'", ClsSql.EncodeSql(m.PHONE));
sb.AppendFormat(",USERJOB='{0}'", ClsSql.EncodeSql(m.USERJOB));
sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(T_SYSSEC_IPSUSER_Model m)
{
if (isExists(new T_SYSSEC_IPSUSER_SW {
LOGINUSERNAME = m.LOGINUSERNAME
}) == true)
{
return(new Message(false, "添加失败，登陆名重复请重新输入!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO T_SYSSEC_USER(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE,DEPARTMENT)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.ORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LOGINUSERNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.USERNAME));
sb.AppendFormat(",'{0}'", ClsStr.getSystemManMd5(ClsSql.EncodeSql(m.USERPWD)));
sb.AppendFormat(",'{0}'", PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now));
sb.AppendFormat(",'{0}'", "0");
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.NOTE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DEPARTMENT));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 获取用户ID
/// </summary>
/// <returns>用户ID</returns>
public static string getUserID()
{
CookieModel cm = getCookieInfo();
if (ConfigCls.getIsSaveLastOpTime() != "0" && string.IsNullOrEmpty(cm.UID) == false)//需要判断用户在线状态
{
//更改该用户最后操作时间
T_SYSSEC_IPSUSER_Model m = new T_SYSSEC_IPSUSER_Model {
USERID = cm.UID, opMethod = "MdyLastOpTime"
};
T_SYSSEC_IPSUSERCls.Manager(m);
}
return(cm.UID);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(T_SYSSEC_IPSUSER_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete T_SYSSEC_USER");
sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确!", ""));
}
}
//
// GET: /Interface/
public ActionResult SystemRedirect()
{
SystemCls.ClearLoginState();
string uid = Request.Params["uid"];
if (string.IsNullOrEmpty(uid))
{
ViewBag.logined = "自动登录失败";
}
else
{
T_SYSSEC_IPSUSER_Model m = T_SYSSEC_IPSUSERCls.getModel(new T_SYSSEC_IPSUSER_SW {
USERID = uid
});
CookieModel cookieM = new CookieModel();
if (m != null)
{
if (string.IsNullOrEmpty(m.USERID))
{
ViewBag.logined = "自动登录失败";
}
else
{
cookieM.UID = m.USERID;
cookieM.userName = m.LOGINUSERNAME;
cookieM.trueName = m.USERNAME;
cookieM.SaveType = "true";
SystemCls.SaveLoginState(cookieM);
ViewBag.logined = "<script language=\"javascript\">window.location.href = '" + ConfigCls.getLoginRedirectUrl(m.USERID) + "';</script>";
}
}
else
{
ViewBag.logined = "自动登录失败";
}
}
return(View());
}
/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(T_SYSSEC_IPSUSER_Model m)
{
if (string.IsNullOrEmpty(m.USERID))
{
return(new Message(false, "修改失败，无效的用户序号!", ""));
}
if (isExists(new T_SYSSEC_IPSUSER_SW {
USERID = m.USERID
}) == false)
{
return(new Message(false, "修改失败，用户名不存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE T_SYSSEC_USER");
sb.AppendFormat(" set ");
sb.AppendFormat("ORGNO='{0}'", ClsSql.EncodeSql(m.ORGNO));
sb.AppendFormat(",LOGINUSERNAME='******'", ClsSql.EncodeSql(m.LOGINUSERNAME));
sb.AppendFormat(",USERNAME='******'", ClsSql.EncodeSql(m.USERNAME));
if (string.IsNullOrEmpty(m.USERPWD) == false)
{
sb.AppendFormat(",USERPWD='{0}'", ClsStr.getSystemManMd5(ClsSql.EncodeSql(m.USERPWD)));
}
sb.AppendFormat(" ,NOTE= '{0}'", ClsSql.EncodeSql(m.NOTE));
sb.AppendFormat(" ,DEPARTMENT= '{0}'", ClsSql.EncodeSql(m.DEPARTMENT));
sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(T_SYSSEC_IPSUSER_Model m)
{
//判断用户序号是否存在于系统扩展表中
if (isExists(new T_SYSSEC_IPSUSER_SW {
USERID = m.USERID
}) == false)
{
return(new Message(false, "删除失败，系统用户不存在!", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete T_SYSSEC_IPSUSER");
sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功!", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确!", ""));
}
}