public async Task <TData <string> > SaveForm(TaskTypeEntity entity)
{
TData <string> obj = new TData <string>();
await taskTypeService.SaveForm(entity);
obj.Result = entity.Id.ParseToString();
obj.Tag = 1;
return(obj);
}
public async Task <ActionResult> SaveFormJson(TaskTypeEntity entity)
{
//对任务单进行自动编号
if (entity.BillNo == "")
{
entity.BillNo = "";
}
TData <string> obj = await taskTypeBLL.SaveForm(entity);
return(Json(obj));
}
public async Task SaveForm(TaskTypeEntity entity)
{
if (entity.Id.IsNullOrZero())
{
entity.Create();
await this.BaseRepository().Insert(entity);
}
else
{
await this.BaseRepository().Update(entity);
}
}
public TaskTypeEntity Update(TaskTypeEntity entity)
{
try
{
_tasktypeRepository.Update(entity);
return(entity);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(null);
}
}
public bool Delete(TaskTypeEntity entity)
{
try
{
_tasktypeRepository.Delete(entity);
return(true);
}
catch (Exception e)
{
_log.Error(e, "数据库操作出错");
return(false);
}
}
public bool UpdateTaskType(TaskTypeEntity taskTypeEntity)
{
bool result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_TaskTypeUpdate");
db.AddInParameter(dbCommand, "@TaskTypeId", DbType.Guid, taskTypeEntity.TaskTypeId);
db.AddInParameter(dbCommand, "@TaskDescription", DbType.String, taskTypeEntity.TaskDescription);
db.AddInParameter(dbCommand, "@TaskCode", DbType.String, taskTypeEntity.TaskCode);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, taskTypeEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return(result);
}
public Guid InsertTaskType(TaskTypeEntity taskTypeEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_TaskTypeInsert");
db.AddInParameter(dbCommand, "@TaskDescription", DbType.String, taskTypeEntity.TaskDescription);
db.AddInParameter(dbCommand, "@TaskCode", DbType.String, taskTypeEntity.TaskCode);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, taskTypeEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@TaskTypeId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@TaskTypeId").ToString());
return(result);
}
public HttpResponseMessage AddTaskTpye([FromBody] TaskTypeModel taskTypeModel)
{
if (!string.IsNullOrWhiteSpace(taskTypeModel.Name))
{
Regex reg = new Regex(@"^[^ %@#!*~&',;=?$\x22]+$");
var m = reg.IsMatch(taskTypeModel.Name);
if (!m)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "类型名称存在非法字符！")));
}
if (taskTypeModel.Describe != "")
{
var m1 = reg.IsMatch(taskTypeModel.Describe);
if (!m1)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "描述存在非法字符！")));
}
}
var model = new TaskTypeEntity
{
Id = taskTypeModel.Id,
Name = taskTypeModel.Name,
Describe = taskTypeModel.Describe
};
var mo1 = new TaskTypeSearchCondition
{
NameRe = taskTypeModel.Name
};
if (taskTypeModel.Type == "add")
{
int taskTypeCount = _taskTypeService.GetTaskTypeCount(mo1);
if (taskTypeCount > 0)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "名称重复，请更换")));
}
else
{
try
{
if (_taskTypeService.Create(model) != null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(true, "添加成功")));
}
}
catch (Exception)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "添加失败")));
}
}
}
if (taskTypeModel.Type == "edit")
{
try
{
_taskTypeService.Update(_taskTypeService.GetTaskTypeById(taskTypeModel.Id));
return(PageHelper.toJson(PageHelper.ReturnValue(true, "修改成功")));
}
catch (Exception)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "修改失败")));
}
}
}
return(PageHelper.toJson(PageHelper.ReturnValue(false, "类型名称不能为空！")));
}
public bool UpdateTaskType(TaskTypeEntity taskTypeEntity)
{
return(taskDao.UpdateTaskType(taskTypeEntity));
}
public Guid InsertTaskType(TaskTypeEntity taskTypeEntity)
{
return(taskDao.InsertTaskType(taskTypeEntity));
}
void Seed(ModelBuilder modelBuilder)
{
modelBuilder.Entity <ProjectTypeEntity>().HasData(
new ProjectTypeEntity()
{
Id = 1, Value = ProjectType.Default
},
new ProjectTypeEntity()
{
Id = 2, Value = ProjectType.Private
},
new ProjectTypeEntity()
{
Id = 3, Value = ProjectType.Work
},
new ProjectTypeEntity()
{
Id = 4, Value = ProjectType.Sport
},
new ProjectTypeEntity()
{
Id = 5, Value = ProjectType.Travel
},
new ProjectTypeEntity()
{
Id = 6, Value = ProjectType.Others
}
);
modelBuilder.Entity <TaskTypeEntity>().HasData(
new TaskTypeEntity()
{
Id = 1, Value = TaskType.ToDo
},
new TaskTypeEntity()
{
Id = 2, Value = TaskType.CallTo
},
new TaskTypeEntity()
{
Id = 3, Value = TaskType.EmailTo
},
new TaskTypeEntity()
{
Id = 4, Value = TaskType.Holidays
},
new TaskTypeEntity()
{
Id = 5, Value = TaskType.LinkTo
},
new TaskTypeEntity()
{
Id = 6, Value = TaskType.LunchWith
},
new TaskTypeEntity()
{
Id = 7, Value = TaskType.Read
},
new TaskTypeEntity()
{
Id = 8, Value = TaskType.Sport
},
new TaskTypeEntity()
{
Id = 9, Value = TaskType.TalkTo
},
new TaskTypeEntity()
{
Id = 10, Value = TaskType.Travel
},
new TaskTypeEntity()
{
Id = 11, Value = TaskType.Others
}
);
var defaultProjectType = new ProjectTypeEntity()
{
Id = 1, Value = ProjectType.Default
};
// Use Anonymous type to relate with ProjectId.
modelBuilder.Entity <ProjectEntity>().HasData(
new { Id = 1, Title = "Project 1", Detail = "Detail for Project 1", ProjectTypeId = 1 },
new { Id = 2, Title = "Project 2", Detail = "Detail for Project 2", ProjectTypeId = 1 },
new { Id = 3, Title = "Project 3", Detail = "Detail for Project 3", ProjectTypeId = 1 }
);
var defaultTaskType = new TaskTypeEntity()
{
Id = 1, Value = TaskType.ToDo
};
// Use Anonymous type to relate with ProjectId.
modelBuilder.Entity <TaskEntity>().HasData(
new { Id = 1, ProjectId = 1, Detail = "Task 1", Priority = TaskPriority.Normal, TaskTypeId = 1, Effort = 0 },
new { Id = 2, ProjectId = 1, Detail = "Task 2", Priority = TaskPriority.Low, TaskTypeId = 1, Effort = 1 },
new { Id = 3, ProjectId = 1, Detail = "Task 3", Priority = TaskPriority.Hight, TaskTypeId = 1, Effort = 3 },
new { Id = 4, ProjectId = 2, Detail = "Task 4", Priority = TaskPriority.Normal, TaskTypeId = 1, Effort = 0 },
new { Id = 5, ProjectId = 2, Detail = "Task 5", Priority = TaskPriority.Low, TaskTypeId = 1, Effort = 1 },
new { Id = 6, ProjectId = 2, Detail = "Task 6", Priority = TaskPriority.Hight, TaskTypeId = 1, Effort = 3 }
);
// SaveChanges();
}
