public static string getGroupJson(FPRole role, List<UserAC> users)
{
if (role == null)
role = new FPRole();
if (users == null)
users = new List<UserAC>();
string str = string.Empty;
string ids = string.Empty;
foreach (var u in users)
{
str = str + u.eng_name + ",";
ids = ids + u.objectId + ",";
}
if (str != string.Empty)
str = str.Substring(0, str.Length - 1);
if (ids != string.Empty)
ids = ids.Substring(0, ids.Length - 1);
StringBuilder groupJson = new StringBuilder();
groupJson.Append("{").Append("objectid:'").Append(role.objectId.ToString()).Append("',")
.Append("name:'").Append(role.name == null ? string.Empty : role.name.ToString()).Append("',")
.Append("user_ids:'").Append(ids.Replace("'", "\\\'")).Append("',")
.Append("user_names:'").Append(str.Replace("'", "\\\'")).Append("'}");
return groupJson.ToString();
}
public bool update(FPRole role, DbTransaction transaction)
{
IFPObjectDAO fpObjectDAO = DAOFactory.getInstance().createFPObjectDAO();
fpObjectDAO.update(role, transaction);
SqlTransaction trans = (SqlTransaction)transaction;
String sql = "update FPRole set name=@name, other=@other where ObjectId = @ObjectId";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Transaction = trans;
cmd.Connection = trans.Connection;
cmd.Parameters.Add(genSqlParameter("ObjectId", SqlDbType.Int, 10, role.objectId));
cmd.Parameters.Add(genSqlParameter("name", SqlDbType.NVarChar, 255, role.name));
cmd.Parameters.Add(genSqlParameter("other", SqlDbType.NVarChar, 255, role.other));
cmd.ExecuteNonQuery();
cmd.Dispose();
return true;
}
public bool add(FPRole role, DbTransaction transaction)
{
IFPObjectDAO fpObjectDAO = DAOFactory.getInstance().createFPObjectDAO();
fpObjectDAO.add(role, transaction);
SqlTransaction trans = (SqlTransaction)transaction;
String sql = "insert into FPRole(ObjectId, name, other) values " +
"(@ObjectId, @name, @other)";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Transaction = trans;
cmd.Connection = trans.Connection;
cmd.Parameters.Add(genSqlParameter("ObjectId", SqlDbType.Int, 10, role.objectId));
cmd.Parameters.Add(genSqlParameter("name", SqlDbType.NVarChar, 255, role.name));
cmd.Parameters.Add(genSqlParameter("other", SqlDbType.NVarChar, 255, role.other));
cmd.ExecuteNonQuery();
cmd.Dispose();
return true;
}
public object AddGroup(string roleID, string name, string userids)
{
UserAC user = (UserAC)Session["user"];
IFPService service = (IFPService)FPServiceHolder.getInstance().getService("fpService");
IFPObjectService objectService = (IFPObjectService)FPServiceHolder.getInstance().getService("fpObjectService");
int rid = 0;
int.TryParse(roleID, out rid);
FPRole role = objectService.getRoles(" where FPObject.ObjectId='" + rid + "'", user).FirstOrDefault();
string result = string.Empty;
if (role ==null)//ÐÂÔö
{
role = new FPRole();
role.name = name;
service.addRole(role, user);
result = "your information added sucessfully!";
}
else//ÐÞ¸Ä
{
role.name = name;
service.updateRole(role, user);
result = "your information updated sucessfully!";
}
List<UserAC> users = objectService.getUsersByRole(roleID, user);
if (users != null)
{
foreach (var u in users)
{
if (u.roles != null && u.roles.Exists (c=>c.objectId ==role.objectId))
{
u.roles.RemoveAll(c => c.objectId == role.objectId);
service.updateUserRole(u);
}
}
}
if (!string.IsNullOrEmpty(userids))
{
var array = userids.Split(',');
foreach (var item in array)
{
if (!string.IsNullOrEmpty(item))
{
UserAC u = objectService.getUserByID(int.Parse(item), user);
if (u.roles .Count()==0|| (u.roles != null && u.roles.Exists(c => c.objectId == role.objectId)==false))
{
u.roles.Add(role);
service.updateUserRole(u);
}
}
}
}
return Json(result);
}
public bool delete(FPRole role, DbTransaction transaction)
{
IFPObjectDAO fpObjectDAO = DAOFactory.getInstance().createFPObjectDAO();
return fpObjectDAO.delete(role, transaction);
}
private List<FPRole> getQueryResult(SqlCommand cmd)
{
DbDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
IUserDAO userDao = DAOFactory.getInstance().createUserDAO();
List<FPRole> roles = new List<FPRole>();
FPRole role = null;
dt.Load(reader);
reader.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
role = new FPRole();
role.objectId = getInt(dt.Rows[i]["ObjectId"]);
role.createDate = getDateTime(dt.Rows[i]["CreateDate"]);
role.updateDate = getDateTime(dt.Rows[i]["UpdateDate"]);
role.updateBy = getString(dt.Rows[i]["UpdateBy"]);
role.isDeleted = (getInt(dt.Rows[i]["IsDeleted"]) == 1);
role.name = getString(dt.Rows[i]["name"]);
role.other = getString(dt.Rows[i]["other"]);
// role.userList = userDao.getUserByRole(role, cmd.Transaction);
roles.Add(role);
}
}
return roles;
}
public bool deleteRole(FPRole role, UserAC currentUser)
{
IDatabase db = DAOFactory.getInstance().getDatabase();
DbConnection conn = db.getConnection();
DbTransaction transaction = db.beginTransaction(conn);
try
{
IFPRoleDAO roleDao = DAOFactory.getInstance().createFPRoleDAO();
role.updateBy = currentUser.eng_name;
role.updateDate = DateTime.Now;
role.name = role.name;
role.other = role.other;
roleDao.delete(role, transaction);
transaction.Commit();
return true;
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
finally
{
conn.Close();
}
}
public object AddGroup(string roleID, string name, string itemselector)
{
try
{
UserAC user = (UserAC)Session["user"];
IFPService service = (IFPService)FPServiceHolder.getInstance().getService("fpService");
IFPObjectService objectService = (IFPObjectService)FPServiceHolder.getInstance().getService("fpObjectService");
int rid = 0;
int.TryParse(roleID, out rid);
FPRole role = objectService.getRoles(" and FPObject.ObjectId='" + rid + "'", user).FirstOrDefault();
string result = string.Empty;
bool bresult = false;
if (role == null)//新增
{
role = new FPRole();
role.name = name;
service.addRole(role, user);
result = "your information added sucessfully!";
bresult = true;
}
else//修改
{
role.name = name;
service.updateRole(role, user);
result = "your information updated sucessfully!";
bresult = true;
}
List<UserAC> users = objectService.getUsersByRole(roleID, user);
if (users != null)
{
foreach (var u in users)
{
if (u.roles != null && u.roles.Exists(c => c.objectId == role.objectId))
{
u.roles.RemoveAll(c => c.objectId == role.objectId);
service.updateUserRole(u);
}
}
}
if (!string.IsNullOrEmpty(itemselector))
{
var array = itemselector.Split(',');
foreach (var item in array)
{
if (!string.IsNullOrEmpty(item))
{
UserAC u = objectService.getUserByID(int.Parse(item), user);
if (u.roles.Count() == 0 || (u.roles != null && u.roles.Exists(c => c.objectId == role.objectId) == false))
{
u.roles.Add(role);
service.updateUserRole(u);
}
}
}
}
return Content("{success:" + bresult.ToString().ToLower() + ", result:\"" + result + "\"}");
}
catch (Exception ex)
{
return Content("{success:false, result:\"" + ex.Message + "\"}");
}
}
