private void SetVicePresidentByCompany(Project proj, SqlConnection sqlc, IUserService _userService, IMfUserGroupService _mfusergroupService, long companyid)
{
try
{
var select1 = string.Format("select userid,groupid from usergroup where id = '{0}' ", companyid);
var sqlcommand1 = new SqlCommand(select1, sqlc);
var rds1 = new SqlDataAdapter(sqlcommand1);
var dt1 = new DataTable();
rds1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
foreach (DataRow row in dt1.Rows)
{
var index = 0;
var userg = new UserGroupDb();
foreach (DataColumn column in dt1.Columns)
{
switch (index)
{
case 0:
userg.UserId = int.Parse(row[column].ToString());
break;
case 1:
userg.GroupId = int.Parse(row[column].ToString());
break;
}
index++;
}
var username = _userService.GetUserById(userg.UserId).UserName;
string mfigroupid = GetMfGroupName(userg.GroupId);
_mfusergroupService.AddUserToGroup(proj.Vault, username, mfigroupid);
}
}
}
catch (Exception ex)
{
// Log.Info(companyid + "SetVicePresidentByCompany error:" + ex.Message);
}
}
//[HttpPost]
//public ActionResult ChangePassword(ChangePasswordViewModel model)
//{
// SimpleLog("in post changepassword");
// SimpleLog("in post changepassword"+model.OldPassword);
// SimpleLog("in post changepassword" + model.NewPassword);
// SimpleLog("in post changepassword" + model.ConfirmPassword);
// try
// {
// var userid = User.Identity.GetUserName();
// SimpleLog("in post 11");
// var pass = DBWorldCache.Get(User.Identity.GetUserId());
// SimpleLog("in post 22");
// var vs = _mfvaultServerService.GetServer();
// SimpleLog("in post 33");
// var app = MFServerUtility.ConnectToServer(userid, pass, vs.Ip, vs.Port);
// SimpleLog("in post 44");
// app.LoginAccountOperations.UpdateLoginPassword(userid, model.NewPassword);
// SimpleLog("in post 55");
// }
// catch (Exception ex)
// {
// return View(model);
// }
// return RedirectToAction("Welcome", "Manage");
//}
//[HttpPost]
//public async Task<ActionResult> CheckProjectCreationPermission(int userid)
//{
// var res = await Task.Run(() => ProjectCreationPermission(userid));
// if (!String.IsNullOrEmpty(res))
// {
// return Content(res);
// }
// return Content("success");
//}
//private string ProjectCreationPermission(int userid)
//{
// var connstr = ConfigurationManager.ConnectionStrings["AecCloudObjects"].ConnectionString;
// var ret = string.Empty;
// var sqlc = new SqlConnection(connstr);
// sqlc.Open();
// try
// {
// var select = string.Format("select id from erppm where userid ={0} ", userid);
// var sqlcommand = new SqlCommand(select, sqlc);
// var rds = new SqlDataAdapter(sqlcommand);
// var dt = new DataTable();
// rds.Fill(dt);
// if (dt.Rows.Count <1)
// {
// ret = string.Format("您没有创建项目的权限，请联系公司总部工程管理部ERP立项信息负责人! ");
// }
// }
// catch (Exception ex)
// {
// Log.Info(string.Format("ProjectCreationPermission {0} ", ex.Message));
// ret = ex.Message;
// }
// sqlc.Close();
// return ret;
//}
public ActionResult GetDbUserGroup(string code)
{
var connstr = ConfigurationManager.ConnectionStrings["AecCloudObjects"].ConnectionString;
Log.Info("--" + connstr);
var sqlc = new SqlConnection(connstr);
Log.Info("333");
sqlc.Open();
var ugs = new List <UserGroupDb>();
try
{
var companyid = int.Parse(GetCompanyId(sqlc, code));
Log.Info("555");
var select = string.Format("select * from usergroup where companyid = '{0}' ", companyid);
var sqlcommand = new SqlCommand(select, sqlc);
var rds = new SqlDataAdapter(sqlcommand);
var dt = new DataTable();
rds.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var index = 0;
var userg = new UserGroupDb();
foreach (DataColumn column in dt.Columns)
{
switch (index)
{
case 0:
userg.Id = int.Parse(row[column].ToString());
break;
case 1:
userg.CompanyId = int.Parse(row[column].ToString());
break;
case 2:
userg.UserId = int.Parse(row[column].ToString());
break;
case 3:
userg.GroupId = int.Parse(row[column].ToString());
break;
}
index++;
}
userg.GroupName = GetUgName(sqlc, userg.GroupId);
userg.Dbusers = GetUsersForUg(sqlc, code);
ugs.Add(userg);
}
}
else
{
Log.Info(select + "GetDbUserGroup there is no usegroup for --" + companyid);
}
}
catch (Exception ex)
{
Log.Info(string.Format("ConCompanyUg {0} ", ex.Message));
}
sqlc.Close();
// return Json(ugs,JsonRequestBehavior.AllowGet);
var json = JsonConvert.SerializeObject(ugs,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
Formatting = Newtonsoft.Json.Formatting.None
});
return(Content(json));
}
public ActionResult PermissionManagement()
{
var companies = _projService.GetAllCompany();
var clist = new List <CompanyManager>();
var connstr = ConfigurationManager.ConnectionStrings["AecCloudObjects"].ConnectionString;
var sqlc = new SqlConnection(connstr);
sqlc.Open();
try
{
foreach (Company company in companies)
{
var select = string.Format("select * from usergroup where companyid = '{0}' ", company.Id);
var sqlcommand = new SqlCommand(select, sqlc);
var rds = new SqlDataAdapter(sqlcommand);
var dt = new DataTable();
rds.Fill(dt);
var cm = new CompanyManager
{
Code = company.Code,
Id = company.Id,
Name = company.Name
};
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
var index = 0;
var userg = new UserGroupDb();
foreach (DataColumn column in dt.Columns)
{
switch (index)
{
case 0:
userg.Id = int.Parse(row[column].ToString());
break;
case 1:
userg.CompanyId = int.Parse(row[column].ToString());
break;
case 2:
userg.UserId = int.Parse(row[column].ToString());
break;
case 3:
userg.GroupId = int.Parse(row[column].ToString());
break;
}
index++;
}
cm.UserGroups.Add(userg);
}
}
clist.Add(cm);
}
}
catch (Exception ex)
{
Log.Info("PermissionManagement error:" + connstr + ex.Message);
}
sqlc.Close();
return(View(clist));
}
public static void Main(string[] args)
{
var userGroupDb = new UserGroupDb("test");
Console.WriteLine("Works : {0}", userGroupDb);
}
