public static int Add(List <string> userCodes, string relationsTable, string relationsKey)
{
using (pm2Entities entities = new pm2Entities())
{
foreach (Basic_Privilege privilege in (from m in entities.Basic_Privilege
where (m.RelationsTable == relationsTable) && (m.RelationsKey == relationsKey)
select m).ToList <Basic_Privilege>())
{
entities.DeleteObject(privilege);
}
if (userCodes != null)
{
foreach (string str in userCodes)
{
string str2 = Guid.NewGuid().ToString();
Basic_Privilege privilege2 = new Basic_Privilege {
PrivilegeId = str2,
RelationsTable = relationsTable,
RelationsKey = relationsKey,
UserCode = str
};
entities.AddToBasic_Privilege(privilege2);
}
}
return(entities.SaveChanges());
}
}
public void Add(cn.justwin.BLL.ProgressManagement.Version entity)
{
if (entity != null)
{
using (pm2Entities entities = new pm2Entities())
{
plus_progress_version _version = new plus_progress_version {
ProgressVersionId = entity.ProgressVersionId,
ParentVersionId = entity.ParentVersionId,
VersionCode = entity.VersionCode,
VersionName = entity.VersionName,
FlowState = new int?(entity.FlowState),
InputDate = new DateTime?(entity.InputDate),
IsLatest = new bool?(entity.IsLatest),
Note = entity.Note,
PT_yhmc = (from m in entities.PT_yhmc
where m.v_yhdm == entity.InputUser
select m).FirstOrDefault <PT_yhmc>(),
plus_progress = (from m in entities.plus_progress
where m.ProgressId == entity.ProgressId
select m).FirstOrDefault <plus_progress>()
};
entities.AddToplus_progress_version(_version);
entities.SaveChanges();
}
}
}
private static void Delete(List <string> idList, pm2Entities context)
{
bool flag = true;
List <Bud_TemplateType> list = GetBud_TemplateType(idList, context);
using (List <Bud_TemplateType> .Enumerator enumerator = list.GetEnumerator())
{
Bud_TemplateType bud_TemplateType;
while (enumerator.MoveNext())
{
bud_TemplateType = enumerator.Current;
if (context.Bud_Template.Count <Bud_Template>(c => (c.Bud_TemplateType.TypeId == bud_TemplateType.TypeId)) > 0)
{
flag = false;
goto Label_00ED;
}
}
}
Label_00ED:
if (!flag)
{
throw new Exception("当前模板类型不是最底层的模板类型");
}
foreach (Bud_TemplateType type in list)
{
context.DeleteObject(type);
}
}
public static void Delete(List <string> idList, pm2Entities context)
{
foreach (string str in idList)
{
Delete(str, context);
}
}
public IList <string> GetAllResourceTypeId(string resourceTypeName)
{
using (pm2Entities entities = new pm2Entities())
{
IQueryable <string> queryable = from rt in entities.Res_ResourceType
where rt.ResourceTypeName == resourceTypeName
select rt.ResourceTypeId;
IQueryable <string> queryable2 = queryable;
using (IEnumerator <string> enumerator = queryable.GetEnumerator())
{
string id;
while (enumerator.MoveNext())
{
id = enumerator.Current;
IQueryable <string> queryable3 = from rt in entities.Res_ResourceType
join r in entities.Res_ResourceType on rt.ResourceTypeId equals r.Res_ResourceType2.ResourceTypeId into r
where rt.Res_ResourceType2.ResourceTypeId == id
select r.ResourceTypeId;
IQueryable <string> queryable4 = from rt in entities.Res_ResourceType
where rt.Res_ResourceType2.ResourceTypeId == id
select rt.ResourceTypeId;
queryable2 = queryable2.Union <string>(queryable3).Union <string>(queryable4);
}
}
return(queryable2.ToList <string>());
}
}
public static decimal GetSumAmountByInDiaryId(string diaryId)
{
decimal num = 0M;
if (!string.IsNullOrEmpty(diaryId))
{
pm2Entities entities = new pm2Entities();
try
{
num = ((IQueryable <decimal>)(from m in entities.Bud_IndirectDiaryDetails
where m.Bud_IndirectDiaryCost.InDiaryId == diaryId
select m.Amount)).Sum();
}
catch
{
num = 0M;
}
finally
{
if (entities != null)
{
entities.Dispose();
}
}
}
return(num);
}
public static void AddCompleted(string prjguid)
{
Guid guid = new Guid(prjguid);
using (pm2Entities entities = new pm2Entities())
{
int num = (from m in entities.PT_Prj_Completed_Detail
where m.PrjGuid == guid
select m).Count <PT_Prj_Completed_Detail>();
List <string> list = (from n in entities.PT_Prj_Completed select n.ID).ToList <string>();
if (num == 0)
{
for (int i = 0; i < list.Count; i++)
{
PrjCompleted model = new PrjCompleted {
ID = Guid.NewGuid().ToString(),
PrjGuid = guid,
PrjCompletedId = list[i],
InputDate = DateTime.Now
};
model.Add(model);
}
}
}
}
public static List <CostDiary> GetAll(string prjId, string userName, int pageSize, int pageNo)
{
List <CostDiary> list = new List <CostDiary>();
if (string.IsNullOrEmpty(prjId))
{
return(list);
}
using (pm2Entities entities = new pm2Entities())
{
if (string.IsNullOrEmpty(userName))
{
return((from m in entities.Bud_IndirectDiaryCost
where m.ProjectId == prjId
select new CostDiary {
Id = m.InDiaryId, Code = m.IndireCode, Name = m.Name, Department = m.Department, FlowState = m.FlowState, IssuedBy = m.IssuedBy, InputDate = m.InputDate, InputUser = m.InputUser, PrjId = m.ProjectId
} into m
orderby m.InputDate descending
select m).Skip <CostDiary>(((pageNo - 1) * pageSize)).Take <CostDiary>(pageSize).ToList <CostDiary>());
}
return((from m in entities.Bud_IndirectDiaryCost
where (m.ProjectId == prjId) && (m.InputUser == userName)
select new CostDiary {
Id = m.InDiaryId, Code = m.IndireCode, Name = m.Name, Department = m.Department, FlowState = m.FlowState, IssuedBy = m.IssuedBy, InputDate = m.InputDate, InputUser = m.InputUser, PrjId = m.ProjectId
} into m
orderby m.InputDate descending
select m).Skip <CostDiary>(((pageNo - 1) * pageSize)).Take <CostDiary>(pageSize).ToList <CostDiary>());
}
}
public static IList <BudTemplateItem> GetAll()
{
IList <BudTemplateItem> list = new List <BudTemplateItem>();
using (pm2Entities entities = new pm2Entities())
{
foreach (var typed in (from bti in entities.Bud_TemplateItem select new { TemplateItemId = bti.TemplateItemId, ItemName = bti.ItemName, ItemCode = bti.ItemCode, Unit = bti.Unit, Note = bti.Note, OrderNumber = bti.OrderNumber, UnitPrice = bti.UnitPrice, Quantity = bti.Quantity, TemplateId = bti.Bud_Template.TemplateId, parentId = bti.ParentId }).ToList())
{
BudTemplateItem item = new BudTemplateItem {
Id = typed.TemplateItemId,
ParentId = typed.parentId,
BudTemplate = cn.justwin.Domain.BudTemplate.GetById(typed.TemplateId),
Code = typed.ItemCode,
Name = typed.ItemName,
OrderNumber = typed.OrderNumber,
Unit = typed.Unit,
Quantity = typed.Quantity,
Note = typed.Note
};
decimal total = 0M;
GetQuantityTotal(item.Id, item.BudTemplate.Id, ref total);
item.Total = new decimal?(decimal.Round(total, 3));
if (item.Quantity == 0M)
{
item.UnitPrice = new decimal?(decimal.Round(0M, 3));
}
else
{
item.UnitPrice = new decimal?(decimal.Round(total / item.Quantity, 3));
}
list.Add(item);
}
}
return(list);
}
private void UpdatePriceType()
{
try
{
if (!this.ValidateUpdatePriceType())
{
base.RegisterScript("top.ui.alert('此价格类型已经存在!');");
}
else
{
using (pm2Entities pm2Entities = new pm2Entities())
{
Res_PriceType res_PriceType = (
from pt in pm2Entities.Res_PriceType
where pt.PriceTypeId == this.priceTypeId
select pt).FirstOrDefault <Res_PriceType>();
if (res_PriceType != null)
{
res_PriceType.PriceTypeName = this.txtPriceTypeName.Text.Trim();
res_PriceType.Note = this.txtNote.Text.Trim();
pm2Entities.SaveChanges();
}
}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("top.ui.show( '修改成功'); \n");
stringBuilder.Append("top.ui.closeWin(); \n");
stringBuilder.Append("top.ui.reloadTab(); \n");
base.RegisterScript(stringBuilder.ToString());
}
}
catch
{
base.RegisterScript("top.ui.alert('修改失败')");
}
}
protected void TreeView_Populate(object sender, TreeNodeEventArgs e)
{
using (pm2Entities pm2Entities = new pm2Entities())
{
IQueryable <Res_ResourceType> queryable =
from m in pm2Entities.Res_ResourceType
where m.Res_ResourceType2.ResourceTypeId == e.Node.Value
select m;
foreach (Res_ResourceType current in queryable)
{
TreeNode treeNode = new TreeNode();
if (ResType.IsContainsChild(current.ResourceTypeId))
{
treeNode.PopulateOnDemand = true;
}
treeNode.Value = current.ResourceTypeId;
treeNode.Text = current.ResourceTypeName;
treeNode.NavigateUrl = "javascript:saveSelectedValue('" + treeNode.Value + "');";
if (base.Request["id"] == treeNode.Value)
{
treeNode.Select();
}
e.Node.ChildNodes.Add(treeNode);
}
}
}
public static void AddUser(string prjGuid, System.Collections.Generic.List <string> userCodes)
{
System.Guid guid = new System.Guid(prjGuid);
using (pm2Entities context = new pm2Entities())
{
PTPrjInfoZTBUserService prjUserSer = new PTPrjInfoZTBUserService();
prjUserSer.Delete(prjGuid);
if (userCodes != null)
{
foreach (string code in userCodes)
{
PT_yhmc yh = (
from m in context.PT_yhmc
where m.v_yhdm == code
select m).FirstOrDefault <PT_yhmc>();
if (yh != null)
{
PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User
{
Id = System.Guid.NewGuid().ToString(),
PrjGuid = guid,
UserCode = code
};
context.AddToPT_PrjInfo_ZTB_User(user);
}
}
}
context.SaveChanges();
}
}
protected void TreeView_Populate(object sender, TreeNodeEventArgs e)
{
using (pm2Entities pm2Entities = new pm2Entities())
{
IQueryable <Res_ResourceType> queryable =
from m in pm2Entities.Res_ResourceType
where m.Res_ResourceType2.ResourceTypeId == e.Node.Value
select m;
foreach (Res_ResourceType current in queryable)
{
TreeNode treeNode = new TreeNode();
if (ResType.IsContainsChild(current.ResourceTypeId))
{
treeNode.PopulateOnDemand = true;
}
treeNode.Value = current.ResourceTypeId;
treeNode.Text = current.ResourceTypeName;
e.Node.ChildNodes.Add(treeNode);
treeNode.NavigateUrl = string.Concat(new string[]
{
"ResourceEdit.aspx?parentId=",
treeNode.Value,
"&nodeId=",
this.pnode(treeNode)
});
treeNode.Target = "EditInfoList";
}
}
}
public int GetCount()
{
using (pm2Entities entities = new pm2Entities())
{
return(entities.ExecuteStoreQuery <T>(this.GenerateSQL(), new object[0]).Count <T>());
}
}
public static List <OrganizationDiary> GetAll(string orgId, string userName, int pageSize, int pageNo)
{
List <OrganizationDiary> list = new List <OrganizationDiary>();
if (string.IsNullOrEmpty(orgId))
{
return(list);
}
using (pm2Entities entities = new pm2Entities())
{
int orgIdInt = Convert.ToInt32(orgId);
if (string.IsNullOrEmpty(userName))
{
return((from m in entities.Bud_OrgDiaryCost
where m.OrgId == orgIdInt
select new OrganizationDiary {
Id = m.OrgDiaryId, Code = m.OrgdiaryCode, Name = m.Name, Department = m.Department, FlowState = m.FlowState, IssuedBy = m.IssuedBy, InputDate = m.InputDate, InputUser = m.InputUser
} into m
orderby m.InputDate descending
select m).Skip <OrganizationDiary>(((pageNo - 1) * pageSize)).Take <OrganizationDiary>(pageSize).ToList <OrganizationDiary>());
}
return((from m in entities.Bud_OrgDiaryCost
where (m.OrgId == orgIdInt) && (m.InputUser == userName)
select new OrganizationDiary {
Id = m.OrgDiaryId, Code = m.OrgdiaryCode, Name = m.Name, Department = m.Department, FlowState = m.FlowState, IssuedBy = m.IssuedBy, InputDate = m.InputDate, InputUser = m.InputUser
} into m
orderby m.InputDate descending
select m).Skip <OrganizationDiary>(((pageNo - 1) * pageSize)).Take <OrganizationDiary>(pageSize).ToList <OrganizationDiary>());
}
}
public static IList <BudTemplateItem> GetByCode(string code, string templateId)
{
IList <BudTemplateItem> list = new List <BudTemplateItem>();
using (pm2Entities entities = new pm2Entities())
{
foreach (var typee in (from bti in entities.Bud_TemplateItem
where (bti.ItemCode == code) && (bti.Bud_Template.TemplateId == templateId)
select new { id = bti.TemplateItemId, parentId = bti.ParentId, tempId = bti.Bud_Template.TemplateId, code = bti.ItemCode, name = bti.ItemName, orederNum = bti.OrderNumber, unit = bti.Unit, quntity = bti.Quantity, unitPrice = bti.UnitPrice, note = bti.Note }).ToList())
{
BudTemplateItem item = new BudTemplateItem {
Id = typee.id,
ParentId = typee.parentId,
BudTemplate = cn.justwin.Domain.BudTemplate.GetById(typee.tempId),
Code = typee.code,
Name = typee.name,
OrderNumber = typee.orederNum,
Unit = typee.unit,
Quantity = typee.quntity,
UnitPrice = typee.unitPrice,
Note = typee.note
};
list.Add(item);
}
}
return(list);
}
public static void AddResource(ConstructTask consTask)
{
using (pm2Entities entities = new pm2Entities())
{
IList <ConstructResource> resourceList = new List <ConstructResource>();
resourceList = consTask.ResourceList;
DelByConsTaskId(consTask.Id, entities);
using (IEnumerator <ConstructResource> enumerator = resourceList.GetEnumerator())
{
ConstructResource consResource;
while (enumerator.MoveNext())
{
consResource = enumerator.Current;
Bud_ConsTaskRes res = new Bud_ConsTaskRes {
ConsTaskResId = consResource.Id,
Bud_ConsTask = entities.Bud_ConsTask.FirstOrDefault <Bud_ConsTask>(c => c.ConsTaskId == consResource.ConsTaskId),
Res_Resource = entities.Res_Resource.FirstOrDefault <Res_Resource>(c => c.ResourceId == consResource.ResourceId),
Quantity = consResource.Quantity,
UnitPrice = consResource.UnitPrice,
AccountingQuantity = new decimal?(consResource.Quantity)
};
entities.AddToBud_ConsTaskRes(res);
}
}
entities.SaveChanges();
}
}
public static BudTemplateItem GetById(string id, string templateId)
{
BudTemplateItem item = new BudTemplateItem();
using (pm2Entities entities = new pm2Entities())
{
var typec = (from bti in entities.Bud_TemplateItem
where (bti.TemplateItemId == id) && (bti.Bud_Template.TemplateId == templateId)
select new { id = bti.TemplateItemId, parentId = bti.ParentId, tempId = bti.Bud_Template.TemplateId, code = bti.ItemCode, name = bti.ItemName, orederNum = bti.OrderNumber, unit = bti.Unit, quntity = bti.Quantity, unitPrice = bti.UnitPrice, note = bti.Note, featureDescription = bti.FeatureDescription }).FirstOrDefault();
if (typec != null)
{
item.Id = id;
item.ParentId = typec.parentId;
item.BudTemplate = cn.justwin.Domain.BudTemplate.GetById(typec.tempId);
item.Code = typec.code;
item.Name = typec.name;
item.OrderNumber = typec.orederNum;
item.Unit = typec.unit;
item.Quantity = typec.quntity;
item.UnitPrice = typec.unitPrice;
item.Note = typec.note;
item.FeatureDescription = typec.featureDescription;
return(item);
}
return(null);
}
}
public void Add(PrjCompleted model)
{
using (pm2Entities entities = new pm2Entities())
{
if (model != null)
{
PT_Prj_Completed_Detail detail = new PT_Prj_Completed_Detail {
ID = model.ID,
PrjGuid = new Guid?(model.PrjGuid),
PrepareStatus = model.PrepareStatus,
UncompletedTrans = model.UncompletedTrans,
Rectification = model.Rectification,
InputDate = model.InputDate
};
PT_Prj_Completed completed = (from pc in entities.PT_Prj_Completed
where pc.ID == model.PrjCompletedId
select pc).FirstOrDefault <PT_Prj_Completed>();
detail.PT_Prj_Completed = completed;
PT_yhmc _yhmc = (from m in entities.PT_yhmc
where m.userCode == model.InputUser
select m).FirstOrDefault <PT_yhmc>();
detail.PT_yhmc = _yhmc;
entities.AddToPT_Prj_Completed_Detail(detail);
entities.SaveChanges();
}
}
}
public static int GetCount(string tempItemId)
{
using (pm2Entities entities = new pm2Entities())
{
return(entities.Bud_TemplateResource.Count <Bud_TemplateResource>(c => (c.Bud_TemplateItem.TemplateItemId == tempItemId)));
}
}
public static IList <BudTemplate> Select(int pagesize, int pageIndex, string tempTypeId)
{
IList <BudTemplate> list = new List <BudTemplate>();
using (pm2Entities entities = new pm2Entities())
{
var queryable = (from temp in entities.Bud_Template
where temp.Bud_TemplateType.TypeId == tempTypeId
orderby temp.InputDate descending
select new { TemplateId = temp.TemplateId, TemplateName = temp.TemplateName, TypeId = temp.Bud_TemplateType.TypeId }).Skip((pageIndex * pagesize)).Take(pagesize);
if ((tempTypeId == "") || (tempTypeId == "0"))
{
queryable = (from temp in entities.Bud_Template
orderby temp.InputDate descending
select new { TemplateId = temp.TemplateId, TemplateName = temp.TemplateName, TypeId = temp.Bud_TemplateType.TypeId }).Skip((pageIndex * pagesize)).Take(pagesize);
}
foreach (var typeb in queryable)
{
BudTemplate item = new BudTemplate {
Id = typeb.TemplateId,
Name = typeb.TemplateName,
BudTempType = BudTemplateType.GetById(typeb.TypeId)
};
list.Add(item);
}
}
return(list);
}
public static List <string> GetOrderNumberById(List <string> lst)
{
List <string> list = new List <string>();
using (pm2Entities entities = new pm2Entities())
{
using (List <string> .Enumerator enumerator = lst.GetEnumerator())
{
string id;
while (enumerator.MoveNext())
{
id = enumerator.Current;
string str = (from m in entities.Bud_TemplateItem
where m.TemplateItemId == id
select m.OrderNumber).FirstOrDefault <string>();
if (string.IsNullOrEmpty(str))
{
throw new Exception("要保存为模板的任务节点已不存在，请重新选择!!!");
}
list.Add(str);
}
}
}
return(list);
}
public static IList <BudTemplate> GetAll(string templateTypeId)
{
var predicate = null;
IList <BudTemplate> list = new List <BudTemplate>();
using (pm2Entities entities = new pm2Entities())
{
var source = (from bt in entities.Bud_Template
orderby bt.InputDate descending
select new { TemplateId = bt.TemplateId, TemplateCode = bt.TemplateCode, TemplateName = bt.TemplateName, InputUser = bt.InputUser, InputDate = bt.InputDate, TypeId = bt.Bud_TemplateType.TypeId }).ToList();
if (!string.IsNullOrEmpty(templateTypeId))
{
if (predicate == null)
{
predicate = m => m.TypeId == templateTypeId;
}
source = source.Where(predicate).ToList();
}
foreach (var typea in source)
{
BudTemplate item = new BudTemplate {
Id = typea.TemplateId,
Code = typea.TemplateCode,
Name = typea.TemplateName,
InputUser = typea.InputUser,
InputDate = new DateTime?(typea.InputDate),
BudTempType = BudTemplateType.GetById(typea.TypeId)
};
list.Add(item);
}
}
return(list);
}
public static IList <TaskResource> GetResourcesByTempItemId(string tempId)
{
List <TaskResource> list = new List <TaskResource>();
using (pm2Entities entities = new pm2Entities())
{
var list2 = (from m in entities.Bud_TemplateResource
where m.Bud_TemplateItem.TemplateItemId == tempId
select new { ResourceQuantity = m.ResourceQuantity, ResourcePrice = m.ResourcePrice, ResourceId = m.Res_Resource.ResourceId }).ToList();
if (list2.Count <= 0)
{
return(list);
}
foreach (var type in list2)
{
TaskResource item = new TaskResource();
decimal? resourcePrice = type.ResourcePrice;
item.Price = resourcePrice.HasValue ? resourcePrice.GetValueOrDefault() : 0M;
decimal?resourceQuantity = type.ResourceQuantity;
item.Quantity = resourceQuantity.HasValue ? resourceQuantity.GetValueOrDefault() : 0M;
item.Resource = Resource.GetById(type.ResourceId);
list.Add(item);
}
}
return(list);
}
public static string GetTypeName(string typeCode, string type, string signCode)
{
int noteId;
int.TryParse(typeCode, out noteId);
using (pm2Entities entities = new pm2Entities())
{
if (type == "1")
{
int typeID = GetTypeID(signCode);
return((from m in entities.XPM_Basic_CodeList
where (m.CodeID == noteId) && (m.TypeID == typeID)
select m.CodeName).FirstOrDefault <string>());
}
if (type == "2")
{
return((from m in entities.Basic_CodeList
where (m.ItemCode == noteId) && (m.TypeCode == signCode)
select m.ItemName).FirstOrDefault <string>());
}
return((from m in entities.Basic_CodeType
where m.TypeCode == typeCode
select m.TypeName).FirstOrDefault <string>());
}
}
public static void Add(List <string> ids, List <string> codes)
{
using (pm2Entities entities = new pm2Entities())
{
if ((ids != null) && (codes != null))
{
PrjMember member = new PrjMember();
foreach (string str in ids)
{
Guid guid = new Guid(str);
List <string> list = (from m in entities.PT_PrjMember
where m.PrjGuid == guid
select m.PT_yhmc.v_yhdm).ToList <string>();
foreach (string str2 in codes)
{
if (!list.Contains(str2))
{
member.AddSign(guid, str2, entities);
}
}
}
entities.SaveChanges();
}
}
}
public static void UpdateLatest(string progressVersionId)
{
using (pm2Entities entities = new pm2Entities())
{
if (!string.IsNullOrEmpty(progressVersionId))
{
plus_progress progress = (from m in entities.plus_progress_version
where m.ProgressVersionId == progressVersionId
select m.plus_progress).FirstOrDefault <plus_progress>();
List <plus_progress_version> list = (from m in entities.plus_progress_version
where ((m.plus_progress.ProgressId == progress.ProgressId) && (m.IsLatest == true)) || (m.ProgressVersionId == progressVersionId)
select m).ToList <plus_progress_version>();
plus_progress_version _version = (from m in entities.plus_progress_version
where m.ProgressVersionId == progressVersionId
select m).FirstOrDefault <plus_progress_version>();
if ((list != null) && (_version != null))
{
foreach (plus_progress_version _version2 in list)
{
_version2.IsLatest = false;
}
_version.IsLatest = true;
}
AddWarn(progressVersionId, entities);
entities.SaveChanges();
}
}
}
public static void AddLimit(Guid guid)
{
using (pm2Entities entities = new pm2Entities())
{
List <string> codes = GetCodes(guid.ToString());
if (codes.Count > 0)
{
foreach (string str in TenderUser.GetUserCodes(guid))
{
if (codes.Contains(str))
{
codes.Remove(str);
}
}
foreach (string str2 in codes)
{
PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User {
Id = Guid.NewGuid().ToString(),
PrjGuid = new Guid?(guid),
UserCode = str2
};
entities.AddToPT_PrjInfo_ZTB_User(user);
}
entities.SaveChanges();
}
}
}
public static void AddUser(string prjGuid, List <string> userCodes)
{
Guid guid = new Guid(prjGuid);
using (pm2Entities entities = new pm2Entities())
{
new PTPrjInfoZTBUserService().Delete(prjGuid);
if (userCodes != null)
{
using (List <string> .Enumerator enumerator = userCodes.GetEnumerator())
{
string code;
while (enumerator.MoveNext())
{
code = enumerator.Current;
if ((from m in entities.PT_yhmc
where m.v_yhdm == code
select m).FirstOrDefault <PT_yhmc>() != null)
{
PT_PrjInfo_ZTB_User user = new PT_PrjInfo_ZTB_User {
Id = Guid.NewGuid().ToString(),
PrjGuid = new Guid?(guid),
UserCode = code
};
entities.AddToPT_PrjInfo_ZTB_User(user);
}
}
}
}
entities.SaveChanges();
}
}
private void AddAttribute()
{
if (this.IsExists())
{
base.RegisterScript("top.ui.alert('此名称已经存在')");
return;
}
try
{
using (pm2Entities pm2Entities = new pm2Entities())
{
Res_ResourceType res_ResourceType = (
from rt in pm2Entities.Res_ResourceType
where rt.ResourceTypeId == this.resourceTypeId
select rt).FirstOrDefault <Res_ResourceType>();
Res_Attribute res_Attribute = new Res_Attribute();
res_Attribute.AttributeId = System.Guid.NewGuid().ToString();
res_Attribute.AttributeName = this.txtAttributeName.Text.Trim();
if (res_ResourceType != null)
{
res_ResourceType.Res_Attribute.Add(res_Attribute);
}
pm2Entities.SaveChanges();
}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("top.ui.closeWin(); \n");
stringBuilder.Append("top.ui.reloadTab(); \n");
stringBuilder.Append("top.ui.alert('添加成功'); \n");
base.RegisterScript(stringBuilder.ToString());
}
catch
{
base.RegisterScript("top.ui.alert('添加失败')");
}
}
