public static bool ModifyWorkListDetail(WorkListDetail model) { string sql = string.Format(@"update {0} set [WorkId]=@WorkId,[Infos]=@Infos,[RoleCode]=@RoleCode,[IsDeleted]=@IsDeleted,[ModifyDate]=getdate(),[ModifyBy]=@ModifyBy where Id=@Id", TableName); return(DBAccess.ExecuteSqlWithEntity(sql, model)); }
public static bool ModifyDetail(List <WorkListDetail> list, string userId) { var insertList = new List <WorkListDetail>(); var updateList = new List <WorkListDetail>(); //var i = 0; foreach (var item in list) { //if (item.IsDeleted == 0) { i++; } var newModel = new WorkListDetail() { WorkId = item.WorkId, Index = item.Index, Infos = item.Infos, IsDeleted = item.IsDeleted, RoleCode = item.RoleCode, CreateBy = userId, ModifyBy = userId }; if (item.Id != 0) { newModel.Id = item.Id; updateList.Add(newModel); } else { insertList.Add(newModel); } } return(WorkListDBOperate.ModifyDetail(updateList, insertList)); }
public static bool WorkListInfoEdit(List <WorkListEdit> list, WorkList work) { var operate = CookieOperate.MemberCookie; var workDetail = new List <WorkListDetail>(); var workItem = new List <WorkListItems>(); var index = 1; foreach (var item in list) { var workDetailModel = new WorkListDetail() { WorkId = work.Guid, Index = index++, Infos = item.Name, RoleCode = item.Role, IsDeleted = 0, CreateBy = operate.UserName, Guid = Guid.NewGuid().ToString() }; workDetail.Add(workDetailModel); var infos = item.Infos.Split('\n'); foreach (var item1 in infos) { var workItemModel = new WorkListItems() { CompanyId = operate.CompanyId, CompanyName = operate.CompanyName, ProjectId = work.ProjectId, WorkId = work.Id, Name = item.Name, Level = 999, Status = ItemStatus.HasPei.ToString(), UserId = string.Format("{0},", operate.UserName), UserName = string.Format("{0},", operate.Name), DayCount = 0, Infos = item1, DetailGuid = workDetailModel.Guid, CreateBy = operate.UserName, Type = ItemType.HouDuan.ToString() }; workItem.Add(workItemModel); } } return(WorkListItemsDBOperate.AddWorkListItems(workDetail, workItem)); }
public static bool AddWorkList(WorkList workList, List <WorkListEdit> list) { var detailList = new List <WorkListDetail>(); var itemList = new List <WorkListItems>(); var index = 1; foreach (var item in list) { var detail = new WorkListDetail() { WorkId = workList.Guid, Index = index, Infos = item.Name, RoleCode = item.Role, Guid = Guid.NewGuid().ToString(), CreateBy = workList.CreateBy, }; var infos = item.Infos.Split('\n'); foreach (var item1 in infos) { if (string.IsNullOrEmpty(item1)) { continue; } var itemDetail = new WorkListItems() { CompanyId = workList.CompanyId, CompanyName = workList.CompanyName, ProjectId = workList.ProjectId, WorkId = workList.Id, Name = item.Name, Level = 999, Status = ItemStatus.XuQiu.ToString(), Infos = item1, DetailGuid = detail.Guid, CreateBy = workList.CreateBy, }; itemList.Add(itemDetail); } detailList.Add(detail); index++; } return(WorkListDBOperate.InsertWorkList(workList, detailList, itemList)); }
public static bool AddWorkListDetail(WorkListDetail model) { string sql = string.Format("insert into {0}([WorkId],[Infos],[RoleCode],[IsDeleted],[CreateDate],[CreateBy]) values(@WorkId,@Infos,@RoleCode,0,getdate(),@CreateBy)", TableName); return(DBAccess.ExecuteSqlWithEntity(sql, model)); }
public static bool ImportExcel(DataTable dt, CompanyUser user, int projectId, string status, out string message) { message = string.Empty; try { //工单名称 var workName = dt.Columns[1].ColumnName.Trim(); var project = ProjectManageDBOperate.GetModelById(projectId); if (project == null) { message = "项目编号有误,请核实"; return(false); } var guid = Guid.NewGuid().ToString(); if (WorkListDBOperate.GetCountByName(workName) > 0) { message = "工单名称已存在,请重新编辑"; return(false); } WorkList work = new WorkList() { Name = workName, CreateBy = user.UserName, CreateDate = DateTime.Now, Length = 0, Status = status, CompanyId = user.CompanyId, CompanyName = user.CompanyName, ProjectId = projectId, ProjectName = project.Name, CusCompanyId = project.CusCompanyId, CusMemberId = project.CusMemberId, Guid = guid, }; var list = new List <WorkListDetail>(); for (int i = 1; i < dt.Rows.Count; i++) { var dr = dt.Rows[i]; var detail = new WorkListDetail() { Infos = dr[1].ToString().Trim(), RoleCode = dr[0].ToString(), //== "消费者" ? DetailRole.Customer.ToString() : DetailRole.Admin.ToString(), CreateBy = user.UserName, WorkId = guid, Index = i, Guid = Guid.NewGuid().ToString() }; if (string.IsNullOrEmpty(detail.Infos)) { continue; } else if (detail.Infos.Length > 100) { message += (i + 2).ToString() + ","; } list.Add(detail); } if (!string.IsNullOrEmpty(message)) { message = "数据第[" + message.Substring(0, message.Length - 1) + "]条内容字数超过100字"; return(false); } return(WorkListDBOperate.Import(work, list, out message)); } catch (Exception ex) { message = ex.Message; } return(false); }