public bool EditUser(RoadFlow.Data.Model.Users user)
{
if (user.Mobile.IsNullOrEmpty() && user.Email.IsNullOrEmpty() && user.WeiXin.IsNullOrEmpty())
{
return(false);
}
if (this.GetUser(user.Account).IsNullOrEmpty())
{
return(this.AddUser(user));
}
string url = "https://qyapi.weixin.qq.com/cgi-bin/user/update?access_token=" + this.GetAccessToken();
List <RoadFlow.Data.Model.UsersRelation> allByUserId = new RoadFlow.Platform.UsersRelation().GetAllByUserID(user.ID);
RoadFlow.Platform.Organize organize1 = new RoadFlow.Platform.Organize();
StringBuilder stringBuilder = new StringBuilder();
foreach (RoadFlow.Data.Model.UsersRelation usersRelation in allByUserId)
{
RoadFlow.Data.Model.Organize organize2 = organize1.Get(usersRelation.OrganizeID);
if (organize2 != null)
{
stringBuilder.Append(organize2.IntID);
stringBuilder.Append(",");
}
}
string str = "{\"userid\":\"" + user.Account + "\",\"name\":\"" + this.replaceName(user.Name) + "\",\"department\":[" + stringBuilder.ToString().TrimEnd(',') + "],\"position\":\"\",\"mobile\":\"" + user.Mobile + "\"," + (user.Sex.HasValue ? "\"gender\":\"" + (user.Sex.Value + 1).ToString() + "\"," : "") + "\"email\":\"" + user.Email + "\",\"weixinid\":\"" + user.WeiXin + "\",\"enable\":" + (user.Status == 0 ? 1 : 0).ToString() + "}";
string json = HttpHelper.SendPost(url, str);
JsonData jsonData = JsonMapper.ToObject(json);
bool flag = jsonData.ContainsKey("errcode") && jsonData["errcode"].ToString().ToInt() == 0;
RoadFlow.Platform.Log.Add("调用了微信修改人员-" + user.Name + "-" + (flag ? "成功" : "失败"), "返回：" + json, RoadFlow.Platform.Log.Types.微信企业号, user.Serialize(), str, (RoadFlow.Data.Model.Users)null);
return(flag);
}
public string ValidateLogin()
{
string str1 = this.Request.Form["Account"];
string str2 = this.Request.Form["Password"];
if (str1.IsNullOrEmpty() || str2.IsNullOrEmpty())
{
return("{\"id\":\"\",\"status\":0,\"msg\":\"帐号或密码不能为空\"}");
}
RoadFlow.Platform.Users users = new RoadFlow.Platform.Users();
RoadFlow.Data.Model.Users byAccount = users.GetByAccount(str1.Trim());
if (byAccount == null || string.Compare(byAccount.Password, users.GetUserEncryptionPassword(byAccount.ID.ToString(), str2.Trim()), false) != 0)
{
return("{\"id\":\"\",\"status\":0,\"msg\":\"帐号或密码错误\"}");
}
if (byAccount.Status == 1)
{
return("{\"id\":\"\",\"status\":0,\"msg\":\"帐号已被冻结\"}");
}
this.Session[Keys.SessionKeys.UserID.ToString()] = (object)byAccount.ID;
this.Session[Keys.SessionKeys.BaseUrl.ToString()] = (object)this.Url.Content("~/");
this.Session[Keys.SessionKeys.UserName.ToString()] = (object)byAccount.Name;
this.Response.Cookies.Add(new HttpCookie(Keys.SessionKeys.UserID.ToString(), byAccount.ID.ToString())
{
Expires = MyController.CurrentDateTime.AddDays(7.0)
});
RoadFlow.Platform.Log.Add("用户登录成功-test(帐号:" + str1 + ")", "", RoadFlow.Platform.Log.Types.用户登录, "", "", (RoadFlow.Data.Model.Users)null);
return("{\"id\":\"" + byAccount.ID.ToString() + "\",\"token\":\"" + RoadFlow.Utility.Config.GetTokenByUserId(byAccount.ID) + "\",\"status\":1,\"msg\":\"用户登录成功\"}");
}
public bool Add(RoadFlow.Data.Model.Users user, Guid uniqueID)
{
if (user == null)
{
return(false);
}
List <RoadFlow.Data.Model.OnlineUsers> all = this.GetAll();
bool flag = false;
RoadFlow.Data.Model.OnlineUsers onlineUsers = all.Find((Predicate <RoadFlow.Data.Model.OnlineUsers>)(p => p.ID == user.ID));
if (onlineUsers == null)
{
flag = true;
onlineUsers = new RoadFlow.Data.Model.OnlineUsers();
RoadFlow.Data.Model.UsersRelation mainByUserId = new UsersRelation().GetMainByUserID(user.ID);
if (mainByUserId != null)
{
onlineUsers.OrgName = new Organize().GetAllParentNames(mainByUserId.OrganizeID, false, " / ");
}
}
onlineUsers.ID = user.ID;
onlineUsers.ClientInfo = "操作系统：" + Tools.GetOSName() + " 浏览器：" + Tools.GetBrowse();
onlineUsers.IP = Tools.GetIPAddress();
onlineUsers.LastPage = "";
onlineUsers.LoginTime = DateTimeNew.Now;
onlineUsers.UniqueID = uniqueID;
onlineUsers.UserName = user.Name;
if (flag)
{
all.Add(onlineUsers);
}
this.set(all);
return(true);
}
/// <summary>
/// 添加一个用户到在线用户表
/// </summary>
public bool Add(RoadFlow.Data.Model.Users user, Guid uniqueID)
{
if (user == null)
{
return(false);
}
var onList = GetAll();
bool isadd = false;
var onUser = onList.Find(p => p.ID == user.ID);
if (onUser == null)
{
isadd = true;
onUser = new RoadFlow.Data.Model.OnlineUsers();
var station = new UsersRelation().GetMainByUserID(user.ID);
if (station != null)
{
onUser.OrgName = new Organize().GetAllParentNames(station.OrganizeID);
}
}
onUser.ID = user.ID;
onUser.ClientInfo = string.Concat("操作系统：", RoadFlow.Utility.Tools.GetOSName(), " 浏览器：", RoadFlow.Utility.Tools.GetBrowse());
onUser.IP = RoadFlow.Utility.Tools.GetIPAddress();
onUser.LastPage = "";
onUser.LoginTime = RoadFlow.Utility.DateTimeNew.Now;
onUser.UniqueID = uniqueID;
onUser.UserName = user.Name;
if (isadd)
{
onList.Add(onUser);
}
set(onList);
return(true);
}
public ActionResult UserAdd(FormCollection collection)
{
RoadFlow.Platform.Organize borganize = new RoadFlow.Platform.Organize();
RoadFlow.Platform.Users busers = new RoadFlow.Platform.Users();
string id = Request.QueryString["id"];
string name = string.Empty;
string account = string.Empty;
string status = string.Empty;
string note = string.Empty;
Guid parentID;
if (collection != null && id.IsGuid(out parentID))
{
name = Request.Form["Name"];
account = Request.Form["Account"];
status = Request.Form["Status"];
note = Request.Form["Note"];
Guid userID = Guid.NewGuid();
string userXML = string.Empty;
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
//添加人员
RoadFlow.Data.Model.Users user = new RoadFlow.Data.Model.Users();
user.Account = account.Trim();
user.Name = name.Trim();
user.Note = note.IsNullOrEmpty() ? null : note;
user.Password = busers.GetUserEncryptionPassword(userID.ToString(), busers.GetInitPassword());
user.Sort = 1;
user.Status = status.IsInt() ? status.ToInt() : 0;
user.ID = userID;
busers.Add(user);
//添加关系
RoadFlow.Data.Model.UsersRelation userRelation = new RoadFlow.Data.Model.UsersRelation();
userRelation.IsMain = 1;
userRelation.OrganizeID = parentID;
userRelation.Sort = new RoadFlow.Platform.UsersRelation().GetMaxSort(parentID);
userRelation.UserID = userID;
new RoadFlow.Platform.UsersRelation().Add(userRelation);
//更新父级[ChildsLength]字段
borganize.UpdateChildsLength(parentID);
//更新角色
new RoadFlow.Platform.UsersRole().UpdateByUserID(userID);
userXML = user.Serialize();
scope.Complete();
}
RoadFlow.Platform.Log.Add("添加了人员", userXML, RoadFlow.Platform.Log.Types.组织机构);
ViewBag.Script = "alert('添加成功!');parent.frames[0].reLoad('" + id + "');window.location=window.location;";
}
ViewBag.StatusRadios = borganize.GetStatusRadio("Status", "0", "validate=\"radio\"");
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
this.Account.Attributes.Add("validate_url", "CheckAccount.ashx");
RoadFlow.Platform.Organize borganize = new RoadFlow.Platform.Organize();
RoadFlow.Platform.Users busers = new RoadFlow.Platform.Users();
string id = Request.QueryString["id"];
string name = string.Empty;
string account = string.Empty;
string status = string.Empty;
string note = string.Empty;
Guid parentID;
if (IsPostBack && id.IsGuid(out parentID))
{
name = Request.Form["Name"];
account = Request.Form["Account"];
status = Request.Form["Status"];
note = Request.Form["Note"];
Guid userID = Guid.NewGuid();
string userXML = string.Empty;
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
//添加人员
RoadFlow.Data.Model.Users user = new RoadFlow.Data.Model.Users();
user.Account = account.Trim();
user.Name = name.Trim();
user.Note = note.IsNullOrEmpty() ? null : note;
user.Password = busers.GetUserEncryptionPassword(userID.ToString(), busers.GetInitPassword());
user.Sort = 1;
user.Status = status.IsInt() ? status.ToInt() : 0;
user.ID = userID;
busers.Add(user);
//添加关系
RoadFlow.Data.Model.UsersRelation userRelation = new RoadFlow.Data.Model.UsersRelation();
userRelation.IsMain = 1;
userRelation.OrganizeID = parentID;
userRelation.Sort = new RoadFlow.Platform.UsersRelation().GetMaxSort(parentID);
userRelation.UserID = userID;
new RoadFlow.Platform.UsersRelation().Add(userRelation);
//更新父级[ChildsLength]字段
borganize.UpdateChildsLength(parentID);
//更新角色
new RoadFlow.Platform.UsersRole().UpdateByUserID(userID);
userXML = user.Serialize();
scope.Complete();
}
RoadFlow.Platform.Log.Add("添加了人员", userXML, RoadFlow.Platform.Log.Types.组织机构);
Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');parent.frames[0].reLoad('" + id + "');window.location=window.location;", true);
}
this.StatusRadios.Text = borganize.GetStatusRadio("Status", "0", "validate=\"radio\"");
}
public int DeleteAndAllChilds(Guid orgID)
{
int num = 0;
using (TransactionScope transactionScope = new TransactionScope())
{
UsersRelation usersRelation1 = new UsersRelation();
Users users1 = new Users();
List <RoadFlow.Data.Model.Organize> allChilds = this.GetAllChilds(orgID);
List <string> stringList = new List <string>();
List <RoadFlow.Data.Model.Organize> organizeList = new List <RoadFlow.Data.Model.Organize>();
foreach (RoadFlow.Data.Model.Organize organize in allChilds)
{
foreach (RoadFlow.Data.Model.UsersRelation usersRelation2 in usersRelation1.GetAllByOrganizeID(organize.ID).FindAll((Predicate <RoadFlow.Data.Model.UsersRelation>)(p => p.IsMain == 1)))
{
RoadFlow.Data.Model.Users users2 = users1.Get(usersRelation2.UserID);
usersRelation1.Delete(usersRelation2.UserID, usersRelation2.OrganizeID);
num += users1.Delete(usersRelation2.UserID);
if (users2 != null)
{
stringList.Add(users2.Account);
}
}
num += this.Delete(organize.ID);
organizeList.Add(organize);
}
foreach (RoadFlow.Data.Model.UsersRelation usersRelation2 in usersRelation1.GetAllByOrganizeID(orgID).FindAll((Predicate <RoadFlow.Data.Model.UsersRelation>)(p => p.IsMain == 1)))
{
usersRelation1.Delete(usersRelation2.UserID, usersRelation2.OrganizeID);
num += users1.Delete(usersRelation2.UserID);
RoadFlow.Data.Model.Users users2 = users1.Get(usersRelation2.UserID);
if (users2 != null)
{
stringList.Add(users2.Account);
}
}
num += this.Delete(orgID);
RoadFlow.Data.Model.Organize organize1 = this.Get(orgID);
if (organize1 != null)
{
organizeList.Add(organize1);
}
if (RoadFlow.Platform.WeiXin.Config.IsUse)
{
RoadFlow.Platform.WeiXin.Organize organize2 = new RoadFlow.Platform.WeiXin.Organize();
if (stringList.Count > 0)
{
organize2.DeleteUserAsync(stringList.ToArray());
}
foreach (RoadFlow.Data.Model.Organize organize3 in organizeList)
{
organize2.DeleteDeptAsync(organize3.IntID);
}
}
transactionScope.Complete();
}
return(num);
}
public string GetAccountByID(Guid id)
{
RoadFlow.Data.Model.Users users = this.Get(id);
if (users != null)
{
return(users.Account);
}
return("");
}
private List <RoadFlow.Data.Model.Users> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.Users> usersList = new List <RoadFlow.Data.Model.Users>();
while (dataReader.Read())
{
RoadFlow.Data.Model.Users users = new RoadFlow.Data.Model.Users();
users.ID = dataReader.GetGuid(0);
users.Name = dataReader.GetString(1);
users.Account = dataReader.GetString(2);
users.Password = dataReader.GetString(3);
users.Status = dataReader.GetInt32(4);
users.Sort = dataReader.GetInt32(5);
if (!dataReader.IsDBNull(6))
{
users.Note = dataReader.GetString(6);
}
if (!dataReader.IsDBNull(7))
{
users.Mobile = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
users.Tel = dataReader.GetString(8);
}
if (!dataReader.IsDBNull(9))
{
users.OtherTel = dataReader.GetString(9);
}
if (!dataReader.IsDBNull(10))
{
users.Fax = dataReader.GetString(10);
}
if (!dataReader.IsDBNull(11))
{
users.Email = dataReader.GetString(11);
}
if (!dataReader.IsDBNull(12))
{
users.QQ = dataReader.GetString(12);
}
if (!dataReader.IsDBNull(13))
{
users.HeadImg = dataReader.GetString(13);
}
if (!dataReader.IsDBNull(14))
{
users.WeiXin = dataReader.GetString(14);
}
if (!dataReader.IsDBNull(15))
{
users.Sex = new int?(dataReader.GetInt32(15));
}
usersList.Add(users);
}
return(usersList);
}
public string GetName(Guid id)
{
RoadFlow.Data.Model.Users users = this.Get(id);
if (users != null)
{
return(users.Name);
}
return("");
}
public bool AddUser(RoadFlow.Data.Model.Users user)
{
if (user.Mobile.IsNullOrEmpty() && user.Email.IsNullOrEmpty() && user.WeiXin.IsNullOrEmpty())
{
return(false);
}
string url = "https://qyapi.weixin.qq.com/cgi-bin/user/create?access_token=" + this.GetAccessToken();
List <RoadFlow.Data.Model.UsersRelation> allByUserId = new RoadFlow.Platform.UsersRelation().GetAllByUserID(user.ID);
RoadFlow.Platform.Organize organize1 = new RoadFlow.Platform.Organize();
StringBuilder stringBuilder = new StringBuilder();
foreach (RoadFlow.Data.Model.UsersRelation usersRelation in allByUserId)
{
RoadFlow.Data.Model.Organize organize2 = organize1.Get(usersRelation.OrganizeID);
if (organize2 != null)
{
stringBuilder.Append(organize2.IntID);
stringBuilder.Append(",");
}
}
string[] strArray = new string[13] {
"{\"userid\":\"", user.Account, "\",\"name\":\"", this.replaceName(user.Name), "\",\"department\":[", stringBuilder.ToString().TrimEnd(','), "],\"position\":\"\",\"mobile\":\"", user.Mobile, "\",", null, null, null, null
};
int index = 9;
int? sex = user.Sex;
string str1;
if (!sex.HasValue)
{
str1 = "";
}
else
{
string str2 = "\"gender\":\"";
sex = user.Sex;
string str3 = (sex.Value + 1).ToString();
string str4 = "\",";
str1 = str2 + str3 + str4;
}
strArray[index] = str1;
strArray[10] = "\"weixinid\":\"";
strArray[11] = user.WeiXin;
strArray[12] = "\"}";
string str5 = string.Concat(strArray);
string json = HttpHelper.SendPost(url, str5);
JsonData jsonData = JsonMapper.ToObject(json);
bool flag = jsonData.ContainsKey("errcode") && jsonData["errcode"].ToString().ToInt() == 0;
RoadFlow.Platform.Log.Add("调用了微信添加人员-" + user.Name + "-" + (flag ? "成功" : "失败"), "返回：" + json, RoadFlow.Platform.Log.Types.微信企业号, user.Serialize(), str5, (RoadFlow.Data.Model.Users)null);
return(flag);
}
public ActionResult EditUserInfo(FormCollection collection)
{
RoadFlow.Platform.Users users = new RoadFlow.Platform.Users();
Guid currentUserId = RoadFlow.Platform.Users.CurrentUserID;
RoadFlow.Data.Model.Users model = users.Get(currentUserId);
if (collection != null)
{
string str1 = this.Request.Form["Tel"];
string str2 = this.Request.Form["MobilePhone"];
string str3 = this.Request.Form["WeiXin"];
string str4 = this.Request.Form["Email"];
string str5 = this.Request.Form["QQ"];
string str6 = this.Request.Form["OtherTel"];
string str7 = this.Request.Form["Note"];
int num = 0;
model.Tel = str1;
model.Mobile = str2;
model.WeiXin = str3;
model.Email = str4;
model.QQ = str5;
model.OtherTel = str6;
model.Note = str7;
if (num != 0)
{
users.Add(model);
}
else
{
users.Update(model);
}
// ISSUE: reference to a compiler-generated field
if (UserInfoController.\u003C\u003Eo__2.\u003C\u003Ep__0 == null)
{
// ISSUE: reference to a compiler-generated field
UserInfoController.\u003C\u003Eo__2.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "script", typeof(UserInfoController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.Constant, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj = UserInfoController.\u003C\u003Eo__2.\u003C\u003Ep__0.Target((CallSite)UserInfoController.\u003C\u003Eo__2.\u003C\u003Ep__0, this.ViewBag, "alert('保存成功!');window.location=window.location;");
}
return((ActionResult)this.View((object)model));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Users实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.Users model)
{
string sql = @"INSERT INTO Users
(ID,Name,Account,Password,Status,Sort,Note)
VALUES(@ID,@Name,@Account,@Password,@Status,@Sort,@Note)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@Name", SqlDbType.NVarChar, 100)
{
Value = model.Name
},
new SqlParameter("@Account", SqlDbType.VarChar, 255)
{
Value = model.Account
},
new SqlParameter("@Password", SqlDbType.VarChar, 500)
{
Value = model.Password
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Users实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(RoadFlow.Data.Model.Users model)
{
string sql = @"INSERT INTO Users
(ID,Name,Account,Password,Status,Sort,Note)
VALUES(:ID,:Name,:Account,:Password,:Status,:Sort,:Note)" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
},
new OracleParameter(":Name", OracleDbType.NVarchar2, 100)
{
Value = model.Name
},
new OracleParameter(":Account", OracleDbType.Varchar2, 255)
{
Value = model.Account
},
new OracleParameter(":Password", OracleDbType.Varchar2, 500)
{
Value = model.Password
},
new OracleParameter(":Status", OracleDbType.Int32)
{
Value = model.Status
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = model.Note
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Users实体类</param>
public int Update(RoadFlow.Data.Model.Users model)
{
string sql = @"UPDATE Users SET
Name=:Name,Account=:Account,Password=:Password,Status=:Status,Sort=:Sort,Note=:Note
WHERE ID=:ID" ;
OracleParameter[] parameters = new OracleParameter[] {
new OracleParameter(":Name", OracleDbType.NVarchar2, 100)
{
Value = model.Name
},
new OracleParameter(":Account", OracleDbType.Varchar2, 255)
{
Value = model.Account
},
new OracleParameter(":Password", OracleDbType.Varchar2, 500)
{
Value = model.Password
},
new OracleParameter(":Status", OracleDbType.Int32)
{
Value = model.Status
},
new OracleParameter(":Sort", OracleDbType.Int32)
{
Value = model.Sort
},
model.Note == null ? new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = DBNull.Value
} : new OracleParameter(":Note", OracleDbType.NVarchar2)
{
Value = model.Note
},
new OracleParameter(":ID", OracleDbType.Varchar2, 40)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">RoadFlow.Data.Model.Users实体类</param>
public int Update(RoadFlow.Data.Model.Users model)
{
string sql = @"UPDATE Users SET
Name=@Name,Account=@Account,Password=@Password,Status=@Status,Sort=@Sort,Note=@Note
WHERE ID=@ID" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Name", SqlDbType.NVarChar, 100)
{
Value = model.Name
},
new SqlParameter("@Account", SqlDbType.VarChar, 255)
{
Value = model.Account
},
new SqlParameter("@Password", SqlDbType.VarChar, 500)
{
Value = model.Password
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = model.Note
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameters));
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <RoadFlow.Data.Model.Users> DataReaderToList(OracleDataReader dataReader)
{
List <RoadFlow.Data.Model.Users> List = new List <RoadFlow.Data.Model.Users>();
RoadFlow.Data.Model.Users model = null;
while (dataReader.Read())
{
model = new RoadFlow.Data.Model.Users();
model.ID = dataReader.GetString(0).ToGuid();
model.Name = dataReader.GetString(1);
model.Account = dataReader.GetString(2);
model.Password = dataReader.GetString(3);
model.Status = dataReader.GetInt32(4);
model.Sort = dataReader.GetInt32(5);
if (!dataReader.IsDBNull(6))
{
model.Note = dataReader.GetString(6);
}
List.Add(model);
}
return(List);
}
public string SaveUserHead()
{
string str1 = this.Request.Form["x"];
string str2 = this.Request.Form["y"];
string str3 = this.Request.Form["x2"];
string str4 = this.Request.Form["y2"];
string str5 = this.Request.Form["w"];
string str6 = this.Request.Form["h"];
string str7 = (this.Request.Form["img"] ?? "").DesDecrypt();
Guid currentUserId = RoadFlow.Platform.Users.CurrentUserID;
if (!str7.IsNullOrEmpty())
{
if (File.Exists(str7))
{
try
{
string str8 = ImgHelper.CutAvatar(str7, WebMvc.Common.Tools.BaseUrl + "/Content/UserHeads/" + (object)currentUserId + ".jpg", str1.ToInt(), str2.ToInt(), str5.ToInt(), str6.ToInt());
if (str8.IsNullOrEmpty())
{
return("保存失败!");
}
RoadFlow.Platform.Users users = new RoadFlow.Platform.Users();
RoadFlow.Data.Model.Users model = users.Get(currentUserId);
if (model != null)
{
model.HeadImg = str8;
users.Update(model);
}
return("保存成功!");
}
catch
{
return("保存失败!");
}
}
}
return("文件不存在!");
}
/// <summary>
/// 记录日志
/// </summary>
/// <param name="err"></param>
public static void Add(string title, string contents, Types type = Types.其它分类, string oldXML = "", string newXML = "", RoadFlow.Data.Model.Users user = null)
{
if (user == null)
{
user = Platform.Users.CurrentUser;
}
RoadFlow.Data.Model.Log log = new RoadFlow.Data.Model.Log();
log.Contents = contents;
log.ID = Guid.NewGuid();
log.IPAddress = RoadFlow.Utility.Tools.GetIPAddress();
log.Others = string.Format("操作系统：{0} 浏览器：{1}", RoadFlow.Utility.Tools.GetOSName(), RoadFlow.Utility.Tools.GetBrowse());
log.Title = title;
log.OldXml = oldXML.IsNullOrEmpty() ? null : oldXML;
log.NewXml = newXML.IsNullOrEmpty() ? null : newXML;
log.Type = type.ToString();
log.URL = System.Web.HttpContext.Current.Request.Url.ToString();
if (user != null)
{
log.UserID = user.ID;
log.UserName = user.Name;
}
log.WriteTime = RoadFlow.Utility.DateTimeNew.Now;
Add(log);
}
public int Update(RoadFlow.Data.Model.Users model)
{
string sql = "UPDATE Users SET \r\n\t\t\t\tName=:Name,Account=:Account,Password=:Password,Status=:Status,Sort=:Sort,Note=:Note,Mobile=:Mobile,Tel=:Tel,OtherTel=:OtherTel,Fax=:Fax,Email=:Email,QQ=:QQ,HeadImg=:HeadImg,WeiXin=:WeiXin,Sex=:Sex\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] oracleParameterArray = new OracleParameter[16];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":Name", OracleDbType.NVarchar2, 100);
oracleParameter1.Value = (object)model.Name;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":Account", OracleDbType.Varchar2, (int)byte.MaxValue);
oracleParameter2.Value = (object)model.Account;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Password", OracleDbType.Varchar2, 500);
oracleParameter3.Value = (object)model.Password;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":Status", OracleDbType.Int32);
oracleParameter4.Value = (object)model.Status;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter5.Value = (object)model.Sort;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6;
if (model.Note != null)
{
OracleParameter oracleParameter7 = new OracleParameter(":Note", OracleDbType.NVarchar2);
oracleParameter7.Value = (object)model.Note;
oracleParameter6 = oracleParameter7;
}
else
{
oracleParameter6 = new OracleParameter(":Note", OracleDbType.NVarchar2);
oracleParameter6.Value = (object)DBNull.Value;
}
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter8;
if (model.Mobile != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@Mobile", OracleDbType.NVarchar2, 50);
oracleParameter7.Value = (object)model.Mobile;
oracleParameter8 = oracleParameter7;
}
else
{
oracleParameter8 = new OracleParameter("@Mobile", OracleDbType.NVarchar2, 50);
oracleParameter8.Value = (object)DBNull.Value;
}
oracleParameterArray[index7] = oracleParameter8;
int index8 = 7;
OracleParameter oracleParameter9;
if (model.Tel != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@Tel", OracleDbType.NVarchar2, 500);
oracleParameter7.Value = (object)model.Tel;
oracleParameter9 = oracleParameter7;
}
else
{
oracleParameter9 = new OracleParameter("@Tel", OracleDbType.NVarchar2, 500);
oracleParameter9.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter9;
int index9 = 8;
OracleParameter oracleParameter10;
if (model.OtherTel != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@OtherTel", OracleDbType.NVarchar2, 500);
oracleParameter7.Value = (object)model.OtherTel;
oracleParameter10 = oracleParameter7;
}
else
{
oracleParameter10 = new OracleParameter("@OtherTel", OracleDbType.NVarchar2, 500);
oracleParameter10.Value = (object)DBNull.Value;
}
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
OracleParameter oracleParameter11;
if (model.Fax != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@Fax", OracleDbType.NVarchar2, 50);
oracleParameter7.Value = (object)model.Fax;
oracleParameter11 = oracleParameter7;
}
else
{
oracleParameter11 = new OracleParameter("@Fax", OracleDbType.NVarchar2, 50);
oracleParameter11.Value = (object)DBNull.Value;
}
oracleParameterArray[index10] = oracleParameter11;
int index11 = 10;
OracleParameter oracleParameter12;
if (model.Email != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@Email", OracleDbType.NVarchar2, 500);
oracleParameter7.Value = (object)model.Email;
oracleParameter12 = oracleParameter7;
}
else
{
oracleParameter12 = new OracleParameter("@Email", OracleDbType.NVarchar2, 500);
oracleParameter12.Value = (object)DBNull.Value;
}
oracleParameterArray[index11] = oracleParameter12;
int index12 = 11;
OracleParameter oracleParameter13;
if (model.QQ != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@QQ", OracleDbType.NVarchar2, 50);
oracleParameter7.Value = (object)model.QQ;
oracleParameter13 = oracleParameter7;
}
else
{
oracleParameter13 = new OracleParameter("@QQ", OracleDbType.NVarchar2, 50);
oracleParameter13.Value = (object)DBNull.Value;
}
oracleParameterArray[index12] = oracleParameter13;
int index13 = 12;
OracleParameter oracleParameter14;
if (model.HeadImg != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@HeadImg", OracleDbType.NVarchar2, 500);
oracleParameter7.Value = (object)model.HeadImg;
oracleParameter14 = oracleParameter7;
}
else
{
oracleParameter14 = new OracleParameter("@HeadImg", OracleDbType.NVarchar2, 500);
oracleParameter14.Value = (object)DBNull.Value;
}
oracleParameterArray[index13] = oracleParameter14;
int index14 = 13;
OracleParameter oracleParameter15;
if (model.WeiXin != null)
{
OracleParameter oracleParameter7 = new OracleParameter("@WeiXin", OracleDbType.NVarchar2, 50);
oracleParameter7.Value = (object)model.WeiXin;
oracleParameter15 = oracleParameter7;
}
else
{
oracleParameter15 = new OracleParameter("@WeiXin", OracleDbType.NVarchar2, 50);
oracleParameter15.Value = (object)DBNull.Value;
}
oracleParameterArray[index14] = oracleParameter15;
int index15 = 14;
int? sex = model.Sex;
OracleParameter oracleParameter16;
if (sex.HasValue)
{
OracleParameter oracleParameter7 = new OracleParameter("@Sex", OracleDbType.Int32, 11);
sex = model.Sex;
oracleParameter7.Value = (object)sex.Value;
oracleParameter16 = oracleParameter7;
}
else
{
oracleParameter16 = new OracleParameter("@Sex", OracleDbType.Int32);
oracleParameter16.Value = (object)DBNull.Value;
}
oracleParameterArray[index15] = oracleParameter16;
int index16 = 15;
OracleParameter oracleParameter17 = new OracleParameter(":ID", OracleDbType.Varchar2, 40);
oracleParameter17.Value = (object)model.ID;
oracleParameterArray[index16] = oracleParameter17;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.Users model)
{
string sql = "UPDATE Users SET \r\n\t\t\t\tName=@Name,Account=@Account,Password=@Password,Status=@Status,Sort=@Sort,Note=@Note,Mobile=@Mobile,Tel=@Tel,OtherTel=@OtherTel,Fax=@Fax,Email=@Email,QQ=@QQ,HeadImg=@HeadImg,WeiXin=@WeiXin,Sex=@Sex\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] sqlParameterArray = new SqlParameter[16];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
sqlParameter1.Value = (object)model.Name;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@Account", SqlDbType.VarChar, (int)byte.MaxValue);
sqlParameter2.Value = (object)model.Account;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Password", SqlDbType.VarChar, 500);
sqlParameter3.Value = (object)model.Password;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@Status", SqlDbType.Int, -1);
sqlParameter4.Value = (object)model.Status;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter5.Value = (object)model.Sort;
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter6;
if (model.Note != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@Note", SqlDbType.NVarChar, -1);
sqlParameter7.Value = (object)model.Note;
sqlParameter6 = sqlParameter7;
}
else
{
sqlParameter6 = new SqlParameter("@Note", SqlDbType.NVarChar, -1);
sqlParameter6.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter6;
int index7 = 6;
SqlParameter sqlParameter8;
if (model.Mobile != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@Mobile", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.Mobile;
sqlParameter8 = sqlParameter7;
}
else
{
sqlParameter8 = new SqlParameter("@Mobile", SqlDbType.VarChar, 50);
sqlParameter8.Value = (object)DBNull.Value;
}
sqlParameterArray[index7] = sqlParameter8;
int index8 = 7;
SqlParameter sqlParameter9;
if (model.Tel != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@Tel", SqlDbType.VarChar, 500);
sqlParameter7.Value = (object)model.Tel;
sqlParameter9 = sqlParameter7;
}
else
{
sqlParameter9 = new SqlParameter("@Tel", SqlDbType.VarChar, 500);
sqlParameter9.Value = (object)DBNull.Value;
}
sqlParameterArray[index8] = sqlParameter9;
int index9 = 8;
SqlParameter sqlParameter10;
if (model.OtherTel != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@OtherTel", SqlDbType.VarChar, 500);
sqlParameter7.Value = (object)model.OtherTel;
sqlParameter10 = sqlParameter7;
}
else
{
sqlParameter10 = new SqlParameter("@OtherTel", SqlDbType.VarChar, 500);
sqlParameter10.Value = (object)DBNull.Value;
}
sqlParameterArray[index9] = sqlParameter10;
int index10 = 9;
SqlParameter sqlParameter11;
if (model.Fax != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@Fax", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.Fax;
sqlParameter11 = sqlParameter7;
}
else
{
sqlParameter11 = new SqlParameter("@Fax", SqlDbType.VarChar, 50);
sqlParameter11.Value = (object)DBNull.Value;
}
sqlParameterArray[index10] = sqlParameter11;
int index11 = 10;
SqlParameter sqlParameter12;
if (model.Email != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@Email", SqlDbType.VarChar, 500);
sqlParameter7.Value = (object)model.Email;
sqlParameter12 = sqlParameter7;
}
else
{
sqlParameter12 = new SqlParameter("@Email", SqlDbType.VarChar, 500);
sqlParameter12.Value = (object)DBNull.Value;
}
sqlParameterArray[index11] = sqlParameter12;
int index12 = 11;
SqlParameter sqlParameter13;
if (model.QQ != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@QQ", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.QQ;
sqlParameter13 = sqlParameter7;
}
else
{
sqlParameter13 = new SqlParameter("@QQ", SqlDbType.VarChar, 50);
sqlParameter13.Value = (object)DBNull.Value;
}
sqlParameterArray[index12] = sqlParameter13;
int index13 = 12;
SqlParameter sqlParameter14;
if (model.HeadImg != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@HeadImg", SqlDbType.VarChar, 500);
sqlParameter7.Value = (object)model.HeadImg;
sqlParameter14 = sqlParameter7;
}
else
{
sqlParameter14 = new SqlParameter("@HeadImg", SqlDbType.VarChar, 500);
sqlParameter14.Value = (object)DBNull.Value;
}
sqlParameterArray[index13] = sqlParameter14;
int index14 = 13;
SqlParameter sqlParameter15;
if (model.WeiXin != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@WeiXin", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.WeiXin;
sqlParameter15 = sqlParameter7;
}
else
{
sqlParameter15 = new SqlParameter("@WeiXin", SqlDbType.VarChar, 50);
sqlParameter15.Value = (object)DBNull.Value;
}
sqlParameterArray[index14] = sqlParameter15;
int index15 = 14;
SqlParameter sqlParameter16;
if (model.Sex.HasValue)
{
SqlParameter sqlParameter7 = new SqlParameter("@Sex", SqlDbType.Int, -1);
sqlParameter7.Value = (object)model.Sex;
sqlParameter16 = sqlParameter7;
}
else
{
sqlParameter16 = new SqlParameter("@Sex", SqlDbType.Int, -1);
sqlParameter16.Value = (object)DBNull.Value;
}
sqlParameterArray[index15] = sqlParameter16;
int index16 = 15;
SqlParameter sqlParameter17 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter17.Value = (object)model.ID;
sqlParameterArray[index16] = sqlParameter17;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
/// <summary>
/// 更新
/// </summary>
public int Update(RoadFlow.Data.Model.Users model)
{
return(dataUsers.Update(model));
}
/// <summary>
/// 新增
/// </summary>
public int Add(RoadFlow.Data.Model.Users model)
{
return(dataUsers.Add(model));
}
public ActionResult Index()
{
RoadFlow.Data.Model.Users currentUser = MyController.CurrentUser;
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "UserName", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj1 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__0, this.ViewBag, currentUser == null ? "" : currentUser.Name);
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "DateTime", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj2 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__1, this.ViewBag, MyController.CurrentDateTime.ToDateWeekString());
List <RoadFlow.Data.Model.ShortMessage> allNoReadByUserId = new RoadFlow.Platform.ShortMessage().GetAllNoReadByUserID(currentUser.ID);
if (allNoReadByUserId.Count > 0)
{
JsonData jsonData = new JsonData();
string empty = string.Empty;
RoadFlow.Data.Model.ShortMessage shortMessage = allNoReadByUserId.OrderByDescending <RoadFlow.Data.Model.ShortMessage, DateTime>((Func <RoadFlow.Data.Model.ShortMessage, DateTime>)(p => p.SendTime)).FirstOrDefault <RoadFlow.Data.Model.ShortMessage>();
string str;
if (!shortMessage.LinkUrl.IsNullOrEmpty())
{
str = "<a class=\"blue1\" href=\"" + shortMessage.LinkUrl + "\">" + shortMessage.Contents.RemoveHTML() + "</a>";
}
else
{
str = shortMessage.Contents.RemoveHTML();
}
jsonData["title"] = (JsonData)shortMessage.Title;
jsonData["contents"] = (JsonData)str;
jsonData["count"] = (JsonData)allNoReadByUserId.Count;
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "NoReadMsgJson", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj3 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__2, this.ViewBag, jsonData.ToJson(true));
}
string str1 = this.Url.Content("~/Content/UserHeads/default.jpg");
if (!currentUser.HeadImg.IsNullOrEmpty() && File.Exists(this.Server.MapPath(this.Url.Content("~" + currentUser.HeadImg))))
{
str1 = this.Url.Content("~" + currentUser.HeadImg);
}
// ISSUE: reference to a compiler-generated field
if (HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3 == null)
{
// ISSUE: reference to a compiler-generated field
HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3 = CallSite <Func <CallSite, object, string, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "HeadImg", typeof(HomeController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj4 = HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3.Target((CallSite)HomeController.\u003C\u003Eo__0.\u003C\u003Ep__3, this.ViewBag, str1);
return((ActionResult)this.View());
}
public static void Add(string title, string contents, Log.Types type = Log.Types.其它分类, string oldXML = "", string newXML = "", RoadFlow.Data.Model.Users user = null)
{
RoadFlow.Data.Model.Log model = new RoadFlow.Data.Model.Log();
model.Contents = contents;
model.ID = Guid.NewGuid();
model.Title = title;
model.OldXml = oldXML.IsNullOrEmpty() ? (string)null : oldXML;
model.NewXml = newXML.IsNullOrEmpty() ? (string)null : newXML;
model.Type = type.ToString();
try
{
if (user == null)
{
user = Users.CurrentUser;
}
if (user != null)
{
model.UserID = new Guid?(user.ID);
model.UserName = user.Name;
}
model.IPAddress = Tools.GetIPAddress();
model.Others = string.Format("操作系统：{0} 浏览器：{1}", (object)Tools.GetOSName(), (object)Tools.GetBrowse());
model.URL = HttpContext.Current.Request.Url.ToString();
}
catch
{
}
model.WriteTime = DateTimeNew.Now;
Log.Add(model);
}
public ActionResult User(FormCollection collection)
{
RoadFlow.Platform.Organize borganize = new RoadFlow.Platform.Organize();
RoadFlow.Platform.Users busers = new RoadFlow.Platform.Users();
RoadFlow.Platform.UsersRelation buserRelation = new RoadFlow.Platform.UsersRelation();
RoadFlow.Data.Model.Users user = null;
RoadFlow.Data.Model.Organize organize = null;
string id = Request.QueryString["id"];
string parentID = Request.QueryString["parentid"];
string name = string.Empty;
string account = string.Empty;
string status = string.Empty;
string note = string.Empty;
string parentString = string.Empty;
Guid userID, organizeID;
if (id.IsGuid(out userID))
{
user = busers.Get(userID);
if (user != null)
{
name = user.Name;
account = user.Account;
status = user.Status.ToString();
note = user.Note;
//所在组织字符串
System.Text.StringBuilder sb = new System.Text.StringBuilder();
var userRelations = buserRelation.GetAllByUserID(user.ID).OrderByDescending(p => p.IsMain);
foreach (var userRelation in userRelations)
{
sb.Append("<div style='margin:3px 0;'>");
sb.Append(borganize.GetAllParentNames(userRelation.OrganizeID, true));
if (userRelation.IsMain == 0)
{
sb.Append("<span style='color:#999'> [兼职]</span>");
}
sb.Append("</div>");
}
ViewBag.ParentString = sb.ToString();
var roles = new RoadFlow.Platform.UsersRole().GetByUserIDFromCache(userID);
RoadFlow.Platform.Role brole = new RoadFlow.Platform.Role();
System.Text.StringBuilder rolesb = new System.Text.StringBuilder();
foreach (var role in roles)
{
var role1 = brole.Get(role.RoleID);
if (role1 == null)
{
continue;
}
rolesb.Append(role1.Name);
rolesb.Append("，");
}
ViewBag.RoleString = rolesb.ToString().TrimEnd('，');
}
}
if (parentID.IsGuid(out organizeID))
{
organize = borganize.Get(organizeID);
}
if (collection != null)
{
//保存
if (!Request.Form["Save"].IsNullOrEmpty() && user != null)
{
name = Request.Form["Name"];
account = Request.Form["Account"];
status = Request.Form["Status"];
note = Request.Form["Note"];
string oldXML = user.Serialize();
user.Name = name.Trim();
user.Account = account.Trim();
user.Status = status.ToInt(1);
user.Note = note.IsNullOrEmpty() ? null : note.Trim();
busers.Update(user);
RoadFlow.Platform.Log.Add("修改了用户", "", RoadFlow.Platform.Log.Types.组织机构, oldXML, user.Serialize());
ViewBag.Script = "alert('保存成功!');parent.frames[0].reLoad('" + parentID + "');";
}
//删除用户
if (!Request.Form["DeleteBut"].IsNullOrEmpty() && user != null && organize != null)
{
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
var urs = buserRelation.GetAllByUserID(user.ID);
busers.Delete(user.ID);
buserRelation.DeleteByUserID(user.ID);
new RoadFlow.Platform.UsersInfo().Delete(user.ID);
new RoadFlow.Platform.UsersRole().DeleteByUserID(user.ID);
//更新父级[ChildsLength]字段
foreach (var ur in urs)
{
borganize.UpdateChildsLength(ur.OrganizeID);
}
scope.Complete();
}
string refreshID = parentID;
string url = string.Empty;
var users = borganize.GetAllUsers(refreshID.ToGuid());
if (users.Count > 0)
{
url = "User?id=" + users.Last().ID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&parentid=" + parentID;
}
else
{
refreshID = organize.ParentID == Guid.Empty ? organize.ID.ToString() : organize.ParentID.ToString();
url = "Body?id=" + parentID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&parentid=" + organize.ParentID;
}
RoadFlow.Platform.Log.Add("删除了用户", user.Serialize(), RoadFlow.Platform.Log.Types.组织机构);
ViewBag.Script = "alert('删除成功');parent.frames[0].reLoad('" + refreshID + "');window.location='" + url + "'";
new RoadFlow.Platform.AppLibrary().ClearUseMemberCache();
}
//初始化密码
if (!Request.Form["InitPass"].IsNullOrEmpty() && user != null)
{
string initpass = busers.GetInitPassword();
busers.InitPassword(user.ID);
RoadFlow.Platform.Log.Add("初始化了用户密码", user.Serialize(), RoadFlow.Platform.Log.Types.组织机构);
ViewBag.Script = "alert('密码已初始化为：" + initpass + "');";
}
//调动
if (!Request.Form["Move1"].IsNullOrEmpty() && user != null)
{
string moveto = Request.Form["movetostation"];
string movetostationjz = Request.Form["movetostationjz"];
Guid moveToID;
if (moveto.IsGuid(out moveToID))
{
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
var us = buserRelation.GetAllByUserID(user.ID);
if ("1" != movetostationjz)
{
buserRelation.DeleteByUserID(user.ID);
}
RoadFlow.Data.Model.UsersRelation ur = new RoadFlow.Data.Model.UsersRelation();
ur.UserID = user.ID;
ur.OrganizeID = moveToID;
ur.IsMain = "1" == movetostationjz ? 0 : 1;
ur.Sort = buserRelation.GetMaxSort(moveToID);
buserRelation.Add(ur);
foreach (var u in us)
{
borganize.UpdateChildsLength(u.OrganizeID);
}
borganize.UpdateChildsLength(organizeID);
borganize.UpdateChildsLength(moveToID);
scope.Complete();
ViewBag.Script = "alert('调动成功!');parent.frames[0].reLoad('" + parentID + "');parent.frames[0].reLoad('" + moveto + "')";
}
RoadFlow.Platform.Log.Add(("1" == movetostationjz ? "兼职" : "全职") + "调动了人员的岗位", "将人员调往岗位(" + moveto + ")", RoadFlow.Platform.Log.Types.组织机构);
new RoadFlow.Platform.AppLibrary().ClearUseMemberCache();
}
}
}
ViewBag.StatusRadios = borganize.GetStatusRadio("Status", status, "validate=\"radio\"");
return(View(user));
}
public string CheckLogin()
{
string name1 = Keys.SessionKeys.IsValidateCode.ToString();
string index1 = Keys.SessionKeys.ValidateCode.ToString();
string str1 = this.Request.Form["Account"];
string str2 = this.Request.Form["Password"];
string str3 = this.Request.Form["VCode"];
string str4 = this.Request.Form["Force"];
string str5 = "(帐号:" + str1 + " 密码:" + str2 + " 验证码:" + str3 + ")";
if (str1.IsNullOrEmpty() || str2.IsNullOrEmpty())
{
RoadFlow.Platform.Log.Add("用户登录失败(帐号或密码为空)" + str5, "", RoadFlow.Platform.Log.Types.用户登录, "", "", (RoadFlow.Data.Model.Users)null);
return("{\"status\":0,\"msg\":\"帐号或密码不能为空!\"}");
}
if (this.Session[name1] != null && "1" == this.Session[name1].ToString() && (this.Session[index1] == null || string.Compare(this.Session[index1].ToString(), str3.Trim1(), true) != 0))
{
RoadFlow.Platform.Log.Add("用户登录失败(验证码错误)" + str5, "", RoadFlow.Platform.Log.Types.用户登录, "", "", (RoadFlow.Data.Model.Users)null);
return("{\"status\":0,\"msg\":\"验证码错误!\"}");
}
RoadFlow.Platform.Users users = new RoadFlow.Platform.Users();
RoadFlow.Data.Model.Users byAccount = users.GetByAccount(str1.Trim());
if (byAccount == null || string.Compare(byAccount.Password, users.GetUserEncryptionPassword(byAccount.ID.ToString(), str2.Trim()), false) != 0)
{
this.Session[name1] = (object)"1";
RoadFlow.Platform.Log.Add("用户登录失败(帐号或密码错误)" + str5, "", RoadFlow.Platform.Log.Types.用户登录, "", "", (RoadFlow.Data.Model.Users)null);
return("{\"status\":0,\"msg\":\"帐号或密码错误!\"}");
}
if (byAccount.Status == 1)
{
this.Session[name1] = (object)"1";
RoadFlow.Platform.Log.Add("用户登录失败(帐号已被冻结)" + str5, "", RoadFlow.Platform.Log.Types.用户登录, "", "", (RoadFlow.Data.Model.Users)null);
return("{\"status\":0,\"msg\":\"帐号已被冻结!\"}");
}
RoadFlow.Platform.OnlineUsers onlineUsers1 = new RoadFlow.Platform.OnlineUsers();
RoadFlow.Data.Model.OnlineUsers onlineUsers2 = onlineUsers1.Get(byAccount.ID);
if (onlineUsers2 != null && "1" != str4)
{
string ip = onlineUsers2.IP;
this.Session.Remove(name1);
return("{\"status\":2,\"msg\":\"当前帐号已经在" + ip + "登录,您要强行登录吗?\"}");
}
Guid uniqueID = Guid.NewGuid();
this.Session[Keys.SessionKeys.UserID.ToString()] = (object)byAccount.ID;
HttpSessionStateBase session1 = this.Session;
Keys.SessionKeys sessionKeys = Keys.SessionKeys.UserUniqueID;
string index2 = sessionKeys.ToString();
// ISSUE: variable of a boxed type
__Boxed <Guid> local = (ValueType)uniqueID;
session1[index2] = (object)local;
HttpSessionStateBase session2 = this.Session;
sessionKeys = Keys.SessionKeys.BaseUrl;
string index3 = sessionKeys.ToString();
string str6 = this.Url.Content("~/");
session2[index3] = (object)str6;
HttpSessionStateBase session3 = this.Session;
sessionKeys = Keys.SessionKeys.UserName;
string index4 = sessionKeys.ToString();
string name2 = byAccount.Name;
session3[index4] = (object)name2;
HttpCookieCollection cookies = this.Response.Cookies;
sessionKeys = Keys.SessionKeys.UserID;
cookies.Add(new HttpCookie(sessionKeys.ToString(), byAccount.ID.ToString())
{
Expires = MyController.CurrentDateTime.AddDays(7.0)
});
onlineUsers1.Add(byAccount, uniqueID);
this.Session.Remove(name1);
RoadFlow.Platform.Log.Add("用户登录成功(帐号:" + str1 + ")", "", RoadFlow.Platform.Log.Types.用户登录, "", "", (RoadFlow.Data.Model.Users)null);
return("{\"status\":1,\"msg\":\"成功!\"}");
}
public void EditUserAsync(RoadFlow.Data.Model.Users user)
{
new Organize.del_SaveUser(this.EditUser).BeginInvoke(user, (AsyncCallback)null, (object)null);
}
public int Add(RoadFlow.Data.Model.Users model)
{
string sql = "INSERT INTO users\r\n\t\t\t\t(ID,Name,Account,Password,Status,Sort,Note,Mobile,Tel,OtherTel,Fax,Email,QQ,HeadImg,WeiXin,Sex) \r\n\t\t\t\tVALUES(@ID,@Name,@Account,@Password,@Status,@Sort,@Note,@Mobile,@Tel,@OtherTel,@Fax,@Email,@QQ,@HeadImg,@WeiXin,@Sex)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[16];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter1.Value = (object)model.ID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@Name", MySqlDbType.VarChar, 50);
mySqlParameter2.Value = (object)model.Name;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3 = new MySqlParameter("@Account", MySqlDbType.VarChar, (int)byte.MaxValue);
mySqlParameter3.Value = (object)model.Account;
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter4 = new MySqlParameter("@Password", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)model.Password;
mySqlParameterArray[index4] = mySqlParameter4;
int index5 = 4;
MySqlParameter mySqlParameter5 = new MySqlParameter("@Status", MySqlDbType.Int32, 11);
mySqlParameter5.Value = (object)model.Status;
mySqlParameterArray[index5] = mySqlParameter5;
int index6 = 5;
MySqlParameter mySqlParameter6 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter6.Value = (object)model.Sort;
mySqlParameterArray[index6] = mySqlParameter6;
int index7 = 6;
MySqlParameter mySqlParameter7;
if (model.Note != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@Note", MySqlDbType.LongText, -1);
mySqlParameter8.Value = (object)model.Note;
mySqlParameter7 = mySqlParameter8;
}
else
{
mySqlParameter7 = new MySqlParameter("@Note", MySqlDbType.LongText, -1);
mySqlParameter7.Value = (object)DBNull.Value;
}
mySqlParameterArray[index7] = mySqlParameter7;
int index8 = 7;
MySqlParameter mySqlParameter9;
if (model.Mobile != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@Mobile", MySqlDbType.VarChar, 50);
mySqlParameter8.Value = (object)model.Mobile;
mySqlParameter9 = mySqlParameter8;
}
else
{
mySqlParameter9 = new MySqlParameter("@Mobile", MySqlDbType.VarChar, 50);
mySqlParameter9.Value = (object)DBNull.Value;
}
mySqlParameterArray[index8] = mySqlParameter9;
int index9 = 8;
MySqlParameter mySqlParameter10;
if (model.Tel != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@Tel", MySqlDbType.VarChar, 500);
mySqlParameter8.Value = (object)model.Tel;
mySqlParameter10 = mySqlParameter8;
}
else
{
mySqlParameter10 = new MySqlParameter("@Tel", MySqlDbType.VarChar, 500);
mySqlParameter10.Value = (object)DBNull.Value;
}
mySqlParameterArray[index9] = mySqlParameter10;
int index10 = 9;
MySqlParameter mySqlParameter11;
if (model.OtherTel != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@OtherTel", MySqlDbType.VarChar, 500);
mySqlParameter8.Value = (object)model.OtherTel;
mySqlParameter11 = mySqlParameter8;
}
else
{
mySqlParameter11 = new MySqlParameter("@OtherTel", MySqlDbType.VarChar, 500);
mySqlParameter11.Value = (object)DBNull.Value;
}
mySqlParameterArray[index10] = mySqlParameter11;
int index11 = 10;
MySqlParameter mySqlParameter12;
if (model.Fax != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@Fax", MySqlDbType.VarChar, 50);
mySqlParameter8.Value = (object)model.Fax;
mySqlParameter12 = mySqlParameter8;
}
else
{
mySqlParameter12 = new MySqlParameter("@Fax", MySqlDbType.VarChar, 50);
mySqlParameter12.Value = (object)DBNull.Value;
}
mySqlParameterArray[index11] = mySqlParameter12;
int index12 = 11;
MySqlParameter mySqlParameter13;
if (model.Email != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@Email", MySqlDbType.VarChar, 500);
mySqlParameter8.Value = (object)model.Email;
mySqlParameter13 = mySqlParameter8;
}
else
{
mySqlParameter13 = new MySqlParameter("@Email", MySqlDbType.VarChar, 500);
mySqlParameter13.Value = (object)DBNull.Value;
}
mySqlParameterArray[index12] = mySqlParameter13;
int index13 = 12;
MySqlParameter mySqlParameter14;
if (model.QQ != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@QQ", MySqlDbType.VarChar, 50);
mySqlParameter8.Value = (object)model.QQ;
mySqlParameter14 = mySqlParameter8;
}
else
{
mySqlParameter14 = new MySqlParameter("@QQ", MySqlDbType.VarChar, 50);
mySqlParameter14.Value = (object)DBNull.Value;
}
mySqlParameterArray[index13] = mySqlParameter14;
int index14 = 13;
MySqlParameter mySqlParameter15;
if (model.HeadImg != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@HeadImg", MySqlDbType.VarChar, 500);
mySqlParameter8.Value = (object)model.HeadImg;
mySqlParameter15 = mySqlParameter8;
}
else
{
mySqlParameter15 = new MySqlParameter("@HeadImg", MySqlDbType.VarChar, 500);
mySqlParameter15.Value = (object)DBNull.Value;
}
mySqlParameterArray[index14] = mySqlParameter15;
int index15 = 14;
MySqlParameter mySqlParameter16;
if (model.WeiXin != null)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@WeiXin", MySqlDbType.VarChar, 50);
mySqlParameter8.Value = (object)model.WeiXin;
mySqlParameter16 = mySqlParameter8;
}
else
{
mySqlParameter16 = new MySqlParameter("@WeiXin", MySqlDbType.VarChar, 50);
mySqlParameter16.Value = (object)DBNull.Value;
}
mySqlParameterArray[index15] = mySqlParameter16;
int index16 = 15;
int? sex = model.Sex;
MySqlParameter mySqlParameter17;
if (sex.HasValue)
{
MySqlParameter mySqlParameter8 = new MySqlParameter("@Sex", MySqlDbType.Int32, 11);
sex = model.Sex;
mySqlParameter8.Value = (object)sex.Value;
mySqlParameter17 = mySqlParameter8;
}
else
{
mySqlParameter17 = new MySqlParameter("@Sex", MySqlDbType.Int32, 11);
mySqlParameter17.Value = (object)DBNull.Value;
}
mySqlParameterArray[index16] = mySqlParameter17;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
