public ActionResult OrgEdit(OrgModel model)
{
model.Provider = Provider;
if (model.Command == "save")
{
bool adding = false;
if (model.OrgID == 0)
{
adding = true;
model.Active = true; //new orgs are always active
}
if (model.Save())
{
//when OrgID is zero (adding a new Org) the page should reload so we can add addresses and departments
if (adding)
{
return(RedirectToAction("OrgEdit", new { model.OrgID }));
}
else
{
return(RedirectToAction("Org"));
}
}
}
else
{
model.Load();
}
return(View(model));
}
public async Task <IActionResult> UpdateOrg(int id, OrgModel orgView)
{
var orgUpdate = await _context.organizations.FindAsync(id);
if (orgUpdate == null)
{
return(NotFound());
}
orgUpdate.ID = orgView.Id;
orgUpdate.OrgName = orgView.Org_Name;
orgUpdate.OrgLocation = orgView.Org_Location;
try
{
_context.organizations.Update(orgUpdate);
_context.SaveChangesAsync();
}
catch (Exception e)
{
throw e;
}
return(NoContent());
}
/// <summary>
/// 根据用户管理的部门获取管理的部门及上级部门，并组装成树形结构
/// </summary>
/// <param name="orgList"></param>
/// <param name="ownList"></param>
/// <returns></returns>
public string GetOwndhtmlxTree(IList <OrgModel> orgList, IList <OrgModel> ownList)
{
//找出上级部门
IList <OrgModel> newList = new List <OrgModel>();
Hashtable ht = new Hashtable();
foreach (OrgModel org in ownList)
{
OrgModel model = new OrgModel();
model.OrgId = org.OrgId;
model.OrgName = org.OrgName;
model.OrgCode = org.OrgCode;
model.ParentOrgId = org.ParentOrgId;
ht.Add(org.OrgCode, org.OrgCode);
newList.Add(model);
RecursiveOwnDump(orgList, model.ParentOrgId, newList, ht);
}
StringBuilder sb = new StringBuilder();
sb.Append("<?xml version='1.0' encoding='utf-8'?>" + Environment.NewLine);
sb.AppendFormat("<tree id='0'>" + Environment.NewLine);
RecursiveDump(newList, 0, 1, sb);
sb.Append("</tree>");
return(sb.ToString());
}
public async Task <string> CreateOrg(OrgModel myOrg)
{
DocumentReference docRef = _db.Collection("organizations").Document(myOrg.UId);
await docRef.SetAsync(myOrg);
return(docRef.Id);
}
public ActionResult DocumentOwnInstrumentList(int documentId)
{
IList <ParamModel> list = Global.Business.ServiceProvider.ParamService.GetAll();
ParamModel paramModel = null;
string InstrumentType = null;
IList <OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll();
OrgModel org = new OrgModel();
string where = "InstrumentId in (Select InstrumentId From DocumentOwnInstrument Where SysDocumentId='" + documentId + "')";
IList <Instrument.Common.Models.InstrumentModel> instrumentList = ServiceProvider.InstrumentService.GetAllInstrumentListByWhere(where);
StringBuilder sb = new StringBuilder();
sb.Append("[");
foreach (var instrument in instrumentList)
{
paramModel = list.SingleOrDefault(p => p.ParamCode == Constants.SysParamType.InstrumentType);
InstrumentType = paramModel.itemsList.SingleOrDefault(p => p.ParamItemValue == instrument.InstrumentType.ToString()).ParamItemName;
org = orgList.SingleOrDefault(o => o.OrgCode == instrument.BelongDepart);
sb.AppendFormat("[\"<a href='#' onclick='fnDelete({0},{1});return false;'>删 除</a> "
+ "\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\",\"{10}\",\"{11}\""
+ "],", documentId, instrument.InstrumentId, instrument.InstrumentName, instrument.ManageNo, instrument.Specification, InstrumentType, instrument.Manufacturer,
instrument.SerialNo, instrument.CreateDate, instrument.DueStartDate, instrument.DueEndDate, org == null ? null : org.OrgName);
}
if (instrumentList.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
ViewBag.instrumentData = sb.ToString();
ViewBag.DocumentId = documentId.ToString();
return(View());
}
/// <summary>
/// 根据组织标识自动生成子组织节点的OrgCode
/// 找出最大的子组织编号+1，若无自组织，则编号为父组织编号+01【xxxxx01】
/// </summary>
/// <param name="parentId"></param>
/// <returns></returns>
public string BuildSubOrgCode(int parentId)
{
string subOrgCode = "";
OrgModel parentOrg = ServiceProvider.OrgService.GetById(parentId);
IList <OrgModel> subOrgs = DBProvider.OrgDAO.GetListByParentId(parentId);
if (subOrgs == null)
{
subOrgs = new List <OrgModel>();
}
if (subOrgs.Count == 0)
{
subOrgCode = parentOrg.OrgCode + "01";
}
else
{
string maxOrgCode = subOrgs.OrderByDescending(o => o.OrgId).First().OrgCode;
int code = 1;
int.TryParse(maxOrgCode.Replace(parentOrg.OrgCode, ""), out code);
code++;
if (code < 10)
{
subOrgCode = parentOrg.OrgCode + "0" + code;
}
else
{
subOrgCode = parentOrg.OrgCode + code;
}
}
return(subOrgCode);
}
public void CanSaveOrg()
{
IClient currentUser = new LNF.Data.ClientItem
{
ClientID = 1301,
UserName = "******",
LName = "Getty",
FName = "James"
};
var model = new OrgModel()
{
CurrentUser = currentUser,
OrgName = string.Format("Test Org [{0:yyyyMMddHHmmss}]", DateTime.Now),
OrgTypeID = 2
};
var result = model.Save();
var message = model.GetMessage();
Assert.IsNull(message);
Assert.IsTrue(result);
var alog = DataSession.Query <ActiveLog>().FirstOrDefault(x => x.TableName == "Org" && x.Record == model.OrgID);
Assert.IsNotNull(alog);
Assert.AreEqual(alog.EnableDate, DateTime.Now.Date);
Assert.IsNull(alog.DisableDate);
Console.WriteLine(model.OrgID);
}
/// <summary>
/// 更新组织信息
/// </summary>
/// <param name="orgModel"></param>
/// <returns></returns>
public bool update(OrgModel orgModel)
{
using (SqlSugarClient db = BaseDB.GetClient())
{
try
{
//db.BeginTran();//开启事务
//特别说明：在事务中，默认情况下是使用锁的，也就是说在当前事务没有结束前，其他的任何查询都需要等待
//ReadCommitted：在正在读取数据时保持共享锁，以避免脏读，但是在事务结束之前可以更改数据，从而导致不可重复的读取或幻像数据。
//db.BeginTran(System.Data.IsolationLevel.ReadCommitted); //重载指定事务的级别
db.BeginTran();//开始事物
db.Updateable <Organization>(orgModel.organization);
//组织关系表不会发生变化 不需要处理
//Dictionary<string, Object> updatec = new Dictionary<string, object>();
// updatec.Add("",)
// db.Updateable<OrganizationOrg>(updatec).Where(org=>org.orgid == orgModel.parentOrgId);
db.CommitTran();//提交事务
return(true);
}
catch (Exception ex)
{
db.RollbackTran();//回滚
return(false);
}
}
}
private static List <OrgModel> GetOrg(int idTeacher)
{
string expressSql = "getOrganization";
List <OrgModel> allOrganizations = new List <OrgModel>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(expressSql, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter teacherIdParam = new SqlParameter
{
ParameterName = "@idTeacher",
Value = idTeacher
};
command.Parameters.Add(teacherIdParam);
var organizations = command.ExecuteReader();
if (organizations.HasRows)
{
while (organizations.Read())
{
OrgModel e = new OrgModel
{
IdOrganization = organizations.GetInt32(0),
NameOrganization = organizations.GetString(1),
IdTeacher = idTeacher
};
allOrganizations.Add(e);
}
}
organizations.Close();
return(allOrganizations);
}
}
/// <summary>
/// 获取工种分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <WorkTypeCount> GetWorkType(OrgModel model)
{
if (null == model)
{
return(null);
}
return(DBSession.IA02DAL.GetWorkType(model));
}
public void SetOrgState(int orgId, bool state)
{
string code = GetCodeById(orgId);
OrgModel model = new OrgModel {
OrgCode = code, IsEnabled = state
};
DBProvider.dbMapper.Update("Organization.SetOrgState", model);
}
/// <summary>
/// 获取一个记录对象.
/// </summary>
public OrgModel GetById(int OrgId)
{
OrgModel model = DBProvider.OrgDAO.GetById(OrgId);
if (model == null)
{
model = new OrgModel();
}
return(model);
}
public ActionResult Create(string parentId)
{
var a = new OrgModel();
if (parentId != null)
{
a.Parent = _factory.CreateOrgDao().Get(parentId);
}
return(View(a));
}
/// <summary>
/// 保存实体数据.
/// </summary>
public void Save(OrgModel model)
{
if (model.OrgId == 0)
{
DBProvider.OrgDAO.Add(model);
}
else
{
DBProvider.OrgDAO.Update(model);
}
}
public static string GetOrgNameTreeByOrgId(int parentOrgId, IList <OrgModel> orgList, string strTree)
{
OrgModel model = orgList.SingleOrDefault(o => o.OrgId == parentOrgId);
if (model == null)
{
return(strTree);
}
strTree = model.OrgName + "—>" + strTree;
return(GetOrgNameTreeByOrgId(model.ParentOrgId, orgList, strTree));
}
public ActionResult CreateOrg(OrgModel OM)
{
DBController db = new DBController();
OM.OrgID = db.Count_Orgs() + 1;
//TODO
OM.AdminID = 2;
db.InsertOrg(OM);
return(View());
}
public int InsertOrg(OrgModel OM)
{
string StoredProcedureName = StoredProcedures.InsertOrg;
Dictionary <string, object> Parameters = new Dictionary <string, object>();
Parameters.Add("@OrgID", OM.OrgID);
Parameters.Add("@OrgName", OM.OrgName);
Parameters.Add("@AdminID", OM.AdminID);
return(dbMan.ExecuteNonQuery(StoredProcedureName, Parameters));
}
public JsonResult report(string organisation, string workitemtype = "0", string projectName = "0")
{
if (workitemtype != "0")
{
c.WIcountType = GetWorkitemCountByType(organisation, workitemtype, projectName);
org.counts = c;
return(Json(org, JsonRequestBehavior.AllowGet));
}
req = new APIRequest(Session["PAT"].ToString());
string url;
url = BaseURL + "/" + organisation + "/_apis/projects?api-version=" + version;
string response = req.ApiRequest(url);
org = JsonConvert.DeserializeObject <OrgModel>(response);
countGen count = new countGen();
org.counts = new orgCounts();
url = BaseURL + "/" + organisation + "/_apis/process/processes?api-version=" + version;
response = req.ApiRequest(url);
count = JsonConvert.DeserializeObject <countGen>(response);
c.processCount = count.Count;
foreach (var project in org.Value)
{
url = BaseURL + organisation + "/" + project.Name + "/_apis/build/definitions?api-version=" + version;
response = req.ApiRequest(url);
project.counts = new orgCounts();
count = JsonConvert.DeserializeObject <countGen>(response);
project.counts.buildDefCount = count.Count;
c.buildDefCount += count.Count;
url = BaseURLvsrm + organisation + "/" + project.Name + "/_apis/release/definitions?api-version=" + version;
response = req.ApiRequest(url);
count = JsonConvert.DeserializeObject <countGen>(response);
project.counts.releaseDefCount = count.Count;
c.releaseDefCount += count.Count;
url = BaseURL + organisation + "/" + project.Name + "/_apis/git/repositories?api-version=" + version;
response = req.ApiRequest(url);
count = JsonConvert.DeserializeObject <countGen>(response);
project.counts.repoCount = count.Count;
//c.repoCount += count.Count;
}
// Calling Repos Count
AllReposCount(organisation);
// Calling Users Count
AllUsersCount(organisation);
// Calling WorkitemsCount Count
AllWorKitemsCount(organisation);
WITypes(organisation);
//Calling WorkItemCountByType
org.counts = c;
return(Json(org, JsonRequestBehavior.AllowGet));
}
public List <WorkTypeCount> GetWorkType(OrgModel model)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT ISNULL(code1.E0386,'其他') AS E0386,A.numCount FROM
(SELECT ISNULL(E0386,'00') AS E0386,COUNT(ISNULL(E0386,'00')) AS numCount FROM dbo.A01 WHERE UnitID=@UnitID GROUP BY E0386) A LEFT JOIN
(SELECT CodeItemID,CodeItemName AS E0386 FROM dbo.SM_CodeItems WHERE CodeID='JA') code1
ON A.E0386=code1.CodeItemID "));
_param?.Clear();
_param.Add("@UnitID", model.orgid);
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param));
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <WorkTypeCount>(dt));
}
public int GetDutyCountByOrgId(int orgId)
{
OrgModel orgModel = DBProvider.OrgDAO.GetById(orgId);
IList <Hashtable> list = DBProvider.DutyDAO.GetAllDutyByOrgCode(orgModel.OrgCode);
if (list != null)
{
return(list.Count);
}
else
{
return(0);
}
}
public ActionResult Save(OrgModel org)
{
if (ModelState.IsValid)
{
IOrgDao orgDao = _factory.CreateOrgDao();
org.Save(orgDao);
if (org.Parent == null)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index", new { id = org.Parent.Id }));
}
return(View(String.IsNullOrEmpty(org.Id) ? "Create" : "Edit", org));
}
public async Task <string> UpdateOrg(OrgModel myOrg)
{
DocumentReference docRef = _db.Collection("organizations").Document(myOrg.UId);
Dictionary <string, object> updates = new Dictionary <string, object>();
PropertyInfo[] properties = typeof(OrgModel).GetProperties();
foreach (PropertyInfo property in properties)
{
updates.Add(property.Name, property.GetValue(myOrg));
}
await docRef.UpdateAsync(updates);
return(docRef.Id);
}
public ApiResult <bool> AddOrg(OrgModel org)
{
ApiResult <bool> apiResult = new ApiResult <bool>();
OrgModel orgnization = org;
if (org.organization.isroot)
{
org.parentOrgId = "-1";
}
bool res = orgManager.Add(orgnization);
apiResult.Code = res?ApiResultStatu.OK: ApiResultStatu.Error;
apiResult.Success = res;
apiResult.Data = res;
return(apiResult);
}
public ActionResult ViewGroupOrgs(int GroupID)
{
DBController dbController = new DBController();
DataTable dt = dbController.SelectMyGroups(GroupID);
List <OrgModel> Orgs = new List <OrgModel>();
for (int i = 0; i < dt.Rows.Count; ++i)
{
OrgModel Org = new OrgModel();
Org.OrgName = Convert.ToString(dt.Rows[i]["OrganizationName"]);
Org.OrgID = int.Parse(Convert.ToString(dt.Rows[i]["OrganizationID"]));
Org.AdminID = Convert.ToInt32(dt.Rows[i]["AdminID"]);
Orgs.Add(Org);
}
return(View(Orgs));
}
public bool delete(OrgModel orgModel)
{
try
{
using (SqlSugarClient db = BaseDB.GetClient())
{
db.BeginTran();//开始事物
db.Deleteable <Organization>(orgModel.organization).ExecuteCommand();
db.Deleteable <OrganizationOrg>().Where(orgo => orgo.orgid == orgModel.parentOrgId).ExecuteCommand();
db.CommitTran();//提交事务
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Save(OrgModel org, FormCollection collection)
{
try
{
//org.AppendInfo.OfficeAddress = collection["OfficeAddress"];
//org.AppendInfo.OfficeFax = collection["OfficeFax"];
//org.AppendInfo.OfficeTel = collection["OfficeTel"];
//org.AppendInfo.BusinessType = Convert.ToInt16(collection["BusinessType"]);
//org.AppendInfo.OrgLeader = Convert.ToInt16(collection["OrgLeader"]);
//org.AppendInfo.OrgType = int.Parse(collection["OrgType"]);
ServiceProvider.OrgService.Save(org);
return(Content("OK"));
}
catch (Exception e)
{
return(Content(e.Message));
}
}
public async Task getOrgData()
{
progress = new Android.App.ProgressDialog(this);
progress.Indeterminate = true;
progress.SetProgressStyle(Android.App.ProgressDialogStyle.Spinner);
progress.SetCancelable(false);
progress.SetMessage("Please wait...");
progress.Show();
//dynamic value = new ExpandoObject();
//value.OrgId = orgid;
// string json = JsonConvert.SerializeObject(value);
try
{
string item = await restservice.OrgnizationList(this, "", location);
//orgmodel[0].organizationName = "Select Orgnization";
orgmodel = JsonConvert.DeserializeObject <List <OrgModel> >(item);
orgmodel[0].organizationName = "Select Organization";
for (int i = 0; i < orgmodel.Count; i++)
{
OrgModel org = new OrgModel();
//org.organizationName=orgmodel[0].
org.organizationName = orgmodel[i].organizationName;
orgname.Add(org);
}
// db.InsertMarkingList(orgmodel);
progress.Dismiss();
spinner.ItemSelected += new EventHandler <AdapterView.ItemSelectedEventArgs>(Selectorg_ItemSelected);
ArrayAdapter adapter = new ArrayAdapter(this, Android.Resource.Layout.SimpleListItem1, orgname);
spinner.Adapter = adapter;
// getorglist()
}
catch (Exception ex)
{
progress.Dismiss();
}
}
/// <summary>
/// 根据用户管理的部门获取管理的部门及上级部门，并组装成树形结构
/// </summary>
/// <param name="ownList"></param>
/// <returns></returns>
public string GetParentdhtmlxTree(IList <OrgModel> ownList)
{
StringBuilder sb = new StringBuilder();
if (ownList.Count == 0)
{
sb.Append("<?xml version='1.0' encoding='utf-8'?>" + Environment.NewLine);
sb.AppendFormat("<tree id='0'><item text='无管理部门，请联系系统管理员' > </item>" + Environment.NewLine);
sb.Append("</tree>");
return(sb.ToString());
}
IList <OrgModel> orgList = DBProvider.OrgDAO.GetAll();
//管理员账号设置为GRGT，则获取所有子节点
if (ownList[0].OrgCode == "GRGT")
{
return(GetdhtmlxTree(orgList));
}
//找出上级部门
IList <OrgModel> newList = new List <OrgModel>();
Hashtable ht = new Hashtable();
foreach (OrgModel org in ownList)
{
OrgModel model = new OrgModel();
model.OrgId = org.OrgId;
model.OrgName = org.OrgName;
model.OrgCode = org.OrgCode;
model.ParentOrgId = org.ParentOrgId;
ht.Add(org.OrgCode, org.OrgCode);
newList.Add(model);
RecursiveOwnDump(orgList, model.ParentOrgId, newList, ht);
}
sb.Append("<?xml version='1.0' encoding='utf-8'?>" + Environment.NewLine);
sb.AppendFormat("<tree id='0'>" + Environment.NewLine);
RecursiveDump(newList, 0, 1, sb);
sb.Append("</tree>");
return(sb.ToString());
}
public void AllWorKitemsCount(string organisation)
{
APIRequest req;
OrgModel org = new OrgModel();
string url;
try
{
object Wiql = new { query = "Select [Id] From WorkItems" };
ProjectModel model = new ProjectModel();
url = "https://dev.azure.com/" + organisation + "/_apis/wit/wiql?api-version=5.1";
req = new APIRequest(Session["PAT"].ToString());
string response = req.ApiRequest(url, "POST", JsonConvert.SerializeObject(Wiql));
model = JsonConvert.DeserializeObject <ProjectModel>(response);
c.WIcountOrg = model.WorkItems.Count;
}
catch (Exception)
{
}
//return org;
}
public async Task <IActionResult> AddOrg([FromBody] OrgModel b)
{
try
{
Organization org = new Organization
{
RegistedDate = DateTime.Now,
IsActive = true,
OrgName = b.Org_Name,
OrgLocation = b.Org_Location,
};
_context.organizations.Add(org);
await _context.SaveChangesAsync();
return(Ok());
}
catch (Exception e)
{
throw e;
}
}
