public string GetOrderNumber(string prjId, string parentId) { string str = "001"; BudConModifyService source = new BudConModifyService(); if (string.IsNullOrEmpty(parentId)) { string aa = (from mts in this join ms in source.AsQueryable <BudConModify>() on mts.ModifyId equals ms.ModifyId where ms.PrjId == prjId && mts.TaskId == null select mts.OrderNumber).Max <string>(); int num; int.TryParse(aa, out num); string str2 = (num + 1).ToString(); if (str2.Length == 1) { str2 = "00" + str2; } if (str2.Length == 2) { str2 = "0" + str2; } return(str2); } IQueryable <string> queryable2 = from mts in this where mts.ParentId == parentId select mts.OrderNumber; if (queryable2.Count <string>() > 0) { string str3 = queryable2.Max <string>(); string str4 = str3.Substring(0, str3.Length - 3); string str6 = (Convert.ToInt32(str3.Substring(str3.Length - 3, 3)) + 1).ToString(); if (str6.Length == 1) { str6 = "00" + str6; } if (str6.Length == 2) { str6 = "0" + str6; } return(str4 + str6); } IQueryable <string> queryable3 = from mts in this where mts.ModifyTaskId == parentId select mts.OrderNumber; if (queryable3.Count <string>() > 0) { str = queryable3.First <string>() + "001"; } return(str); }
public BudContractTask GetTaskById(string id) { BudContractTask task = (from t in this where t.TaskId == id select t).FirstOrDefault <BudContractTask>(); if (task == null) { BudConModifyTaskService service = new BudConModifyTaskService(); BudConModifyTask task2 = (from r in service where r.TaskId == id select r).FirstOrDefault <BudConModifyTask>(); if (task2 != null) { BudConModify byId = new BudConModifyService().GetById(task2.ModifyId); task = new BudContractTask { TaskId = task2.TaskId, ParentId = task2.ParentId, OrderNumber = task2.OrderNumber, PrjId = byId.PrjId, TaskCode = task2.ModifyTaskCode, TaskName = task2.ModifyTaskContent, Unit = task2.Unit, Quantity = task2.Quantity, UnitPrice = new decimal?(task2.UnitPrice), Total = new decimal?(task2.Total), StartDate = task2.StartDate, EndDate = task2.EndDate, ConstructionPeriod = task2.ConstructionPeriod, Note = task2.Note, InputDate = DateTime.Now, InputUser = byId.InputUser, TaskType = string.Empty, IsValid = true }; } return(task); } BudConModifyTaskService service3 = new BudConModifyTaskService(); BudConModifyTask task3 = (from r in service3 where r.TaskId == id select r).FirstOrDefault <BudConModifyTask>(); if (task3 != null) { task.StartDate = task3.StartDate; task.EndDate = task3.EndDate; decimal?total = task.Total; decimal num = task3.Total; task.Total = total.HasValue ? new decimal?(total.GetValueOrDefault() + num) : null; task.Quantity += task3.Quantity; } return(task); }