/// <summary>
/// 上传外部单位附件
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="objectID"></param>
/// <param name="content"></param>
/// <returns></returns>
public string UploadAttachFileToResource(SessionPara para, SQLTransaction trans, string objectID, string content)
{
string retStr = "";
if (!string.IsNullOrEmpty(objectID) && !string.IsNullOrEmpty(content))
{
StringBuilder sb = new StringBuilder();
var fileDataList = JsonConvert.DeserializeObject <List <FileInformation> >(content);
foreach (var file in fileDataList)
{
var newObj = ObjectFactoryUtility.CreateInstance(para, trans, "TESTATTACH");
newObj.SetObjectDBValue("ENAME", file.FileName);
newObj.SetObjectDBValue("PATH", file.Path);
newObj.SetObjectDBValue("MASTERID", objectID);
newObj.SetObjectDBValue("UPLOADUSER", para.UserID);
newObj.SetObjectDBValue("UPLOADTIME", DatetimeUtil.GetInternalTicksByDateTime(DateTime.Now));
newObj.SetObjectDBValue("FILEINFO", JsonConvert.SerializeObject(new List <FileInformation>()
{
file
}));
newObj.SaveObject(para, trans);
sb.Append(";" + newObj.ObjectID);
}
if (sb.Length > 0)
{
retStr = sb.ToString().Substring(1);
}
}
return(retStr);
}
public TreeRootData GetTestTaskPlanTreeNode(SessionPara para, SQLTransaction trans)
{
TreeRootData rootData = new TreeRootData();
var rootTxt = Dictionarys.Instance.GetText("TestPlan", "AllProject", para.Lang);
var rootNodeId = "ALLPROJECT_" + para.CompanyID.Split('_')[1];
rootData.RootData = new List <TreeNodeObject>();
var rootNode = ServiceUtility.GetTreeNodeObject(rootTxt, rootNodeId, "", "ALLPROJECT", "-1", "", "ALLPROJECT", true);
rootNode.Children = new List <TreeNodeObject>();
ObjectQuery query = new ObjectQuery("PMSPROJECT");
query.FilterString = " STATEID <> 'Finished' ";
var queryResult = query.ExecObjectQuery(para, trans);
foreach (var tempProject in queryResult)
{
var tempName = tempProject.GetObjectDBValue(ObjectInfoConst.EntityName).ToString();
var tempNodeType = tempProject.ObjType.Name;
var tempImg = ServiceUtility.ToWebIconPath(tempProject.ObjType.IconPath);
var tempNode = ServiceUtility.GetTreeNodeObject(tempName, tempProject.ObjectID, "", tempNodeType, "1", tempImg, tempNodeType, true);
tempNode.ContentPermission = true;
rootNode.Children.Add(tempNode);
}
rootData.RootData.Add(rootNode);
rootNode.ContentPermission = true;
return(rootData);
}
public override void SaveObject(SessionPara session, SQLTransaction trans)
{
var type = this.GetObjectDBValue("TYPE").ToString();
var filter = type + DateTime.Now.ToString("yyyy");
ObjectQuery query = new ObjectQuery(this.ObjType.TableName);
query.FilterString = " ECODE LIKE '" + filter + "%'";
var queryResult = query.ExecObjectQuery(session, trans);
List <int> listCode = new List <int>()
{
1
};
foreach (EntityObject item in queryResult)
{
var lastCode = item.EntityCode.Substring(item.EntityCode.Length - 3);
listCode.Add(int.Parse(lastCode));
}
var maxCode = listCode.Max().ToString();
while (maxCode.Length < 3)
{
maxCode = "0" + maxCode;
}
this.SetObjectDBValue(ObjectInfoConst.EntityCode, filter + maxCode);
base.SaveObject(session, trans);
}
/// <summary>
/// 批量设置对象的属性值
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="objectId">对象id集合</param>
/// <param name="fieldName">属性名称集合</param>
/// <param name="value">值</param>
/// <returns></returns>
public bool SetObjectValueByFiledName(SessionPara para, SQLTransaction trans, string objectId, string fieldName, string value)
{
bool result = false;
if (!string.IsNullOrEmpty(objectId) && !string.IsNullOrEmpty(fieldName))
{
var objList = ObjectFactoryUtility.GetObjListByIdList(para, trans, objectId.Split(';'));
var fields = fieldName.Split(';');
var values = value.Split(';');
if (fields.Length == values.Length)
{
foreach (var curObj in objList)
{
for (int i = 0; i < fields.Length; i++)
{
var tempField = fields[i];
var tempValue = values[i];
curObj.SetObjectDBValue(tempField, tempValue);
}
curObj.SaveObject(para, trans);
}
result = true;
}
}
return(result);
}
/// <summary>
/// 获取实验能力树列表标题
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="objectId"></param>
/// <returns></returns>
public EditTreeGridRowTitleData GetTestCapabilityTreeGridRowTitle(SessionPara para)
{
EditTreeGridRowTitleData titleData = new EditTreeGridRowTitleData();
titleData.ColumnData = new EditTreeGridRowTitleObject();
var viewConfig = Views.Instance.Get("TESTCAPABILITYView");
foreach (var item in viewConfig.ViewColumnList.Where(d => d.Width > 0 || d.Width == -1 || d.Name == ObjectInfoConst.EntityID))
{
var colType = EditTreeGridColType.Text;
if (item.Name == ObjectInfoConst.EntityID)
{
colType = EditTreeGridColType.Hidden;
}
else if (item.Name == ObjectInfoConst.EntityName)
{
colType = EditTreeGridColType.Link;
}
titleData.ColumnData.Add(new EditTreeGridColTitleObject()
{
Name = item.Name,
ColType = colType,
Width = item.Width,
Text = viewConfig.GetColHeader(item.Name, para.Lang),
Editable = false,
Resizable = true
});
}
return(titleData);
}
public TreeRootData GetTestTaskPlanTreeNode(SessionPara para)
{
using (SQLTransaction trans = new SQLTransaction(para))
{
TestPlanBusiness business = new TestPlanBusiness();
return(business.GetTestTaskPlanTreeNode(para, trans));
}
}
public TreeRootData GetProjectCapabilityTreeRootNode(SessionPara para)
{
using (SQLTransaction trans = new SQLTransaction(para))
{
TestResourceLibBusiness business = new TestResourceLibBusiness();
return(business.GetProjectCapabilityTreeRootNode(para, trans));
}
}
public TreeRootData GetTestKnowlwdgeTreeNode(SessionPara para)
{
using (SQLTransaction trans = new SQLTransaction(para))
{
TestResourceLibBusiness business = new TestResourceLibBusiness();
return(business.GetTestKnowlwdgeTreeNode(para, trans));
}
}
/// <summary>
/// 获取组织下第一层试验能力
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="orgId">组织id</param>
/// <returns></returns>
public List <EditTreeGridRowObject> GetTestCapabilityTreeGridRowData(SessionPara para, SQLTransaction trans, string orgId, string tableName)
{
List <EditTreeGridRowObject> rowList = new List <EditTreeGridRowObject>();
if (string.IsNullOrEmpty(tableName))
{
tableName = "TESTCAPABILITY";
}
ObjectQuery query = new ObjectQuery(tableName);
if (!string.IsNullOrEmpty(orgId))
{
var tempData = orgId.Split('_');
if (tempData.Length > 1)
{
//按组织进入
query.FilterInfo.Add("ORG", QueryOperator.Equal, orgId);
query.FilterInfo.Add(QueryOperator.And);
}
else
{
//按类别进入
query.FilterInfo.Add("TYPE", QueryOperator.Equal, orgId);
query.FilterInfo.Add(QueryOperator.And);
}
}
query.FilterInfo.Add(QueryOperator.Left);
query.FilterInfo.Add("TESTPROJECT", QueryOperator.IsNull);
query.FilterInfo.Add(QueryOperator.Or);
query.FilterInfo.Add("TESTPROJECT", QueryOperator.Equal, "");
query.FilterInfo.Add(QueryOperator.Right);
var queryResult = query.ExecObjectQuery(para, trans);
if (queryResult.Count > 0)
{
var viewConfig = Views.Instance.Get(tableName + "View");
var columns = viewConfig.ViewColumnList.Where(d => d.Width > 0 || d.Width == -1 || d.Name == ObjectInfoConst.EntityID);
foreach (var item in queryResult)
{
EditTreeGridRowObject tempRow = new EditTreeGridRowObject();
foreach (var column in columns)
{
tempRow.ColDatas.Add(new EditTreeGridColDataObject(column.Name, item.GetObjectDisplayValue(para, trans, column.Name, "")));
}
tempRow.Children = new List <EditTreeGridRowObject>();
tempRow.IsShowExpandIcon = true;
rowList.Add(tempRow);
}
}
return(rowList);
}
/// <summary>
/// 根据关系id移除关系
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="linkIds"></param>
/// <returns></returns>
public bool RemoveLinkObject(SessionPara para, SQLTransaction trans, string linkIds)
{
bool result = false;
if (!string.IsNullOrEmpty(linkIds))
{
var objList = ObjectFactoryUtility.GetObjListByIdList(para, trans, linkIds.Split(';'));
foreach (var obj in objList)
{
obj.DeleteObject(para, trans);
}
result = true;
}
return(result);
}
/// <summary>
/// 通过关系名称父子级id建立关系
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="linkTypeName"></param>
/// <param name="peid"></param>
/// <param name="ceids"></param>
/// <returns></returns>
public bool AddLinkByObjectIdAndLinkTypeName(SessionPara para, SQLTransaction trans, string linkTypeName, string peid, string ceids)
{
bool result = false;
if (!string.IsNullOrEmpty(linkTypeName) && !string.IsNullOrEmpty(peid) && !string.IsNullOrEmpty(ceids))
{
var ids = ceids.Split(';');
var objList = ObjectFactoryUtility.GetObjListByIdList(para, trans, ids);
foreach (var cid in ceids.Split(';'))
{
ObjectFactoryUtility.AddLink(para, trans, linkTypeName, peid, cid);
}
result = true;
}
return(result);
}
public override string GetDisplayValue(SessionPara session, SQLTransaction trans, string format)
{
if (DBValue == null || DBValue == DBNull.Value)
{
return("");
}
var value = DBValue.ToString();
try
{
List <FileInformation> valueList = (List <FileInformation>)(JsonConvert.DeserializeObject(DBValue.ToString(), typeof(List <FileInformation>)));
if (valueList != null && valueList.Count > 0)
{
string tempValue = "";
foreach (var item in valueList)
{
tempValue += ";" + item.FileName;
}
if (string.IsNullOrEmpty(tempValue) == false)
{
value = tempValue.Substring(1);
if (string.IsNullOrEmpty(format) == false)
{
value = string.Format(format, value);
}
else if (string.IsNullOrEmpty(CurObjectInfoType.PropertyFormat) == false)
{
value = string.Format(CurObjectInfoType.PropertyFormat, value);
}
}
}
else
{
value = "";
}
}
catch (Exception ex)
{
}
return(value);
}
public TreeRootData GetTestKnowlwdgeTreeNode(SessionPara para, SQLTransaction trans)
{
TreeRootData rootData = new TreeRootData();
var rootTxt = Dictionarys.Instance.GetText("TestResourceLib", "KnowledgeType", para.Lang);
var rootNodeId = "KNOWLEDGEROOT_" + para.CompanyID.Split('_')[1];
rootData.RootData = new List <TreeNodeObject>();
var rootNode = ServiceUtility.GetTreeNodeObject(rootTxt, rootNodeId, "", "KNOWLEDGEROOT", "-1", "", "KNOWLEDGEROOT", true);
rootNode.Children = new List <TreeNodeObject>();
var enumData = EnumerationUtility.GetDBEnumerationItem(para, trans, "KnowledgeType");
foreach (var key in enumData.Keys)
{
var tempNode = ServiceUtility.GetTreeNodeObject(enumData[key], key, "", "KNOWLEDGETYPE", "1", "", "KNOWLEDGETYPE", true);
rootNode.Children.Add(tempNode);
}
rootData.RootData.Add(rootNode);
rootNode.ContentPermission = true;
return(rootData);
}
public TreeRootData GetProjectCapabilityTreeRootNode(SessionPara para, SQLTransaction trans)
{
TreeRootData rootData = new TreeRootData();
rootData.RootData = new List <TreeNodeObject>();
string rootNodeType = "PROJECTROOT";
string childNodeType = "RESOURCETYPE";
var projectNodeText = Dictionarys.Instance.GetText("TestResourceLib", "TestProject", para.Lang);
var enumData = EnumerationUtility.GetDBEnumerationItem(para, trans, "OutResourceType");
var rootNode = ServiceUtility.GetTreeNodeObject(projectNodeText, rootNodeType, rootNodeType, rootNodeType, "-1", "", rootNodeType, true);
rootData.RootData.Add(rootNode);
if (enumData.Keys.Count > 0)
{
rootNode.Children = new List <TreeNodeObject>();
foreach (var key in enumData.Keys)
{
var childNode = ServiceUtility.GetTreeNodeObject(enumData[key], key, key, childNodeType, "1", "", childNodeType, false);
rootNode.Children.Add(childNode);
}
}
return(rootData);
}
public TreeRootData GetPMSProjectTreeNode(SessionPara para)
{
TreeRootData rootData = new TreeRootData();
var context = Dictionarys.Instance.GetContext("PMSProject");
var rootTxt = context.GetText("MyProject", para.Lang);
var responseProjectTxt = context.GetText("ResponseProject", para.Lang);
var ParticProjectTxt = context.GetText("ParticipateProject", para.Lang);
var endProjectTxt = context.GetText("CompleteProject", para.Lang);
string rootNodeType = "MYPROJECT";
string rNodeType = "RPROJECT";
string pNodeType = "PPROJECT";
string cNodeType = "CPROJECT";
rootData.RootData = new List <Service.Interface.Control.TreeNodeObject>();
var rootNode = ServiceUtility.GetTreeNodeObject(rootTxt, rootNodeType, "", rootNodeType, "-1", "", rootNodeType, true);
rootNode.Children = new List <Service.Interface.Control.TreeNodeObject>();
rootNode.Children.Add(ServiceUtility.GetTreeNodeObject(responseProjectTxt, rNodeType, "", rNodeType, "1", "", rNodeType, false));
rootNode.Children.Add(ServiceUtility.GetTreeNodeObject(ParticProjectTxt, pNodeType, "", pNodeType, "2", "", pNodeType, false));
rootNode.Children.Add(ServiceUtility.GetTreeNodeObject(endProjectTxt, cNodeType, "", cNodeType, "3", "", cNodeType, false));
rootData.RootData.Add(rootNode);
return(rootData);
}
public TreeRootData GetPMSProjectTreeNode(SessionPara para)
{
GACProjectBusiness business = new GACProjectBusiness();
return(business.GetPMSProjectTreeNode(para));
}
public TreeRootData GetTestTaskTreeNode(SessionPara para)
{
WorkSpaceBusiness business = new WorkSpaceBusiness();
return(business.GetTestTaskTreeNode(para));
}
public EditTreeGridRowTitleData GetTestCapabilityTreeGridRowTitle(SessionPara para)
{
TestResourceLibBusiness business = new TestResourceLibBusiness();
return(business.GetTestCapabilityTreeGridRowTitle(para));
}
/// <summary>
/// 批量更改试验能力组织
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="objectID"></param>
/// <param name="fieldName"></param>
/// <param name="value"></param>
/// <returns></returns>
public bool ChangeCapabilityOrg(SessionPara para, SQLTransaction trans, string objectID, string value)
{
bool result = false;
if (!string.IsNullOrEmpty(objectID))
{
var objList = ObjectFactoryUtility.GetObjListByIdList(para, trans, objectID.Split(';'));
List <string> list = new List <string>();
//获取试验能力所在的组织集合
foreach (var obj in objList)
{
var orgStr = obj.GetObjectDBValue("ORG").ToString();
if (!list.Contains(orgStr))
{
list.Add(orgStr);
}
}
ObjectQuery query = new ObjectQuery("TESTCAPABILITY");
query.FilterString = " ORG IN(" + list.Select(d => "'" + d + "'").Aggregate((a, b) => a + "," + b) + ")";
var queryResult = query.ExecObjectQuery(para, trans);
List <string> objIdList = new List <string>();
foreach (var obj in objList)
{
var curOrg = obj.GetObjectDBValue("ORG").ToString();
//更改的数据与之前的相同则不再处理
if (curOrg == value || objIdList.Contains(obj.ObjectID))
{
continue;
}
var parentProject = obj.GetObjectDBValue("TESTPROJECT").ToString();
//存在父级且父级不在此次更改组织的范围内，清空父级项目
if (!string.IsNullOrEmpty(parentProject))
{
if (!objList.Any(t => t.ObjectID == parentProject))
{
obj.SetObjectDBValue("TESTPROJECT", DBNull.Value);
obj.SaveObject(para, trans);
}
else
{
continue;
}
}
else if (string.IsNullOrEmpty(parentProject))
{
parentProject = obj.ObjectID;
}
List <BaseObject> tempList = new List <BaseObject>();
tempList.Add(obj);
DeepGetChildCapabilityObj(parentProject, tempList, queryResult);
foreach (var item in tempList)
{
item.SetObjectDBValue("ORG", value);
item.SaveObject(para, trans);
objIdList.Add(item.ObjectID);
}
}
result = true;
}
return(result);
}
/// <summary>
/// 保存试验能力，并且创建试验资源、知识的关系
/// </summary>
/// <param name="para"></param>
/// <param name="trans"></param>
/// <param name="baseData"></param>
/// <param name="knowledgeId"></param>
/// <param name="resourceId"></param>
/// <param name="objectId"></param>
/// <returns></returns>
public string SaveCapabilityData(SessionPara para, SQLTransaction trans, string baseData, string knowledgeId, string resourceId, string objectId)
{
string ret = "";
if (!string.IsNullOrEmpty(baseData))
{
BaseObject abilityObj = null;
BaseObject projectObj = null;
if (!string.IsNullOrEmpty(objectId))
{
abilityObj = ObjectFactoryUtility.CreateInstance(para, trans, objectId, false);
ObjectFactoryUtility.DeleteObjByTypeAndFilter(para, trans, "TESTABILITIYTORESOUCE", " AND PEID ='" + objectId + "'");
ObjectFactoryUtility.DeleteObjByTypeAndFilter(para, trans, "TESTABILITYTOKNOWLEDGE", " AND PEID ='" + objectId + "'");
}
else
{
abilityObj = ObjectFactoryUtility.CreateInstance(para, trans, "TESTCAPABILITY");
}
abilityObj.FromJsonString(para, baseData);
var objName = abilityObj.GetObjectDBValue("ENAME").ToString();
if (!string.IsNullOrEmpty(objName))
{
//根据前端传过来的项目数据判断是id还是名称，如果是名称则编辑是否已经存在相同名称的项目，否则新建项目
var objTypeName = ObjectFactoryUtility.TypeFromID(objName);
if (DataModels.Instance.GetEntityType(objTypeName) == null)
{
ObjectQuery query = new ObjectQuery("TESTPROJECT");
var projectList = query.ExecObjectQuery(para, trans);
projectObj = projectList.FirstOrDefault(d => d.GetObjectDBValue(ObjectInfoConst.EntityName).ToString() == objName);
if (projectObj == null)
{
projectObj = ObjectFactoryUtility.CreateInstance(para, trans, "TESTPROJECT");
projectObj.SetObjectDBValue("ENAME", abilityObj.GetObjectDBValue("ENAME"));
projectObj.SetObjectDBValue("ECODE", abilityObj.GetObjectDBValue("ECODE"));
projectObj.SetObjectDBValue("STANDARDCODE", abilityObj.GetObjectDBValue("STANDARDCODE"));
projectObj.SetObjectDBValue("STANDARDNAME", abilityObj.GetObjectDBValue("STANDARDNAME"));
projectObj.SetObjectDBValue("TYPE", abilityObj.GetObjectDBValue("TYPE"));
projectObj.SetObjectDBValue("SCHEDULETYPE", abilityObj.GetObjectDBValue("SCHEDULETYPE"));
projectObj.SetObjectDBValue("ABILITYORDER", abilityObj.GetObjectDBValue("ABILITYORDER"));
projectObj.SetObjectDBValue("ISCNAS", abilityObj.GetObjectDBValue("ISCNAS"));
//根据父级试验能力设置项目的父级项目
var pCapabilityId = abilityObj.GetObjectDBValue("TESTPROJECT").ToString();
if (!string.IsNullOrEmpty(pCapabilityId))
{
var pCapability = ObjectFactoryUtility.CreateInstance(para, trans, pCapabilityId, false);
if (pCapability != null)
{
projectObj.SetObjectDBValue("TESTPROJECT", pCapability.GetObjectDBValue(ObjectInfoConst.EntityName));
}
}
projectObj.SaveObject(para, trans);
}
abilityObj.SetObjectDBValue("ENAME", projectObj.ObjectID);
}
}
abilityObj.SaveObject(para, trans);
if (!string.IsNullOrEmpty(knowledgeId))
{
var kIds = JsonConvert.DeserializeObject <List <string> >(knowledgeId);
foreach (var kid in kIds)
{
ObjectFactoryUtility.AddLink(para, trans, "TESTABILITYTOKNOWLEDGE", abilityObj.ObjectID, kid);
}
}
if (!string.IsNullOrEmpty(resourceId))
{
var resIds = JsonConvert.DeserializeObject <List <string> >(resourceId);
foreach (var resid in resIds)
{
ObjectFactoryUtility.AddLink(para, trans, "TESTABILITIYTORESOUCE", abilityObj.ObjectID, resid);
}
}
ret = abilityObj.ObjectID;
}
return(ret);
}