public ActionResult ImportTable(string projectGuid)
{
return(ActionUtils.Json(() =>
{
var project = m_dbAdapter.Project.GetProjectByGuid(projectGuid);
CheckHandleContactPermission(project);
var file = Request.Files[0];
byte[] bytes = new byte[file.InputStream.Length];
file.InputStream.Read(bytes, 0, bytes.Length);
file.InputStream.Seek(0, SeekOrigin.Begin);
Stream newStream = new MemoryStream(bytes);
var tableHeaderRowsCount = ExcelUtils.GetTableHeaderRowsCount(newStream, 0, 0, tableHeader);
var table = ExcelUtils.ParseExcel(file.InputStream, 0, tableHeaderRowsCount, 0, 6);
var validation = new ExcelValidation();
validation.Add(CellRange.Column(0), new CellTextValidation(1, 50));
Func <string, string> checkEDutyType = (cellText) =>
{
try
{
CommUtils.ParseEnum <EDutyType>(cellText);
}
catch
{
return "无法将[" + cellText + "]解析为[职责]";
}
return string.Empty;
};
validation.Add(CellRange.Column(1), new CellCustomValidation(checkEDutyType, false));
validation.Add(CellRange.Column(2), new CellTextValidation(0, 30));
validation.Add(CellRange.Column(3), new CellTextValidation(0, 38));
validation.Add(CellRange.Column(3), new CellEmailValidation());
validation.Add(CellRange.Column(4), new CellTelValidation());
validation.Check(table, tableHeaderRowsCount);
Func <List <object>, int, int, Contact> ParseRow = (objs, index, projectId) =>
{
return this.ParseRow(objs, index, projectId);
};
List <Contact> contacts = ExcelUtils.ParseTable <Contact>(table, project.ProjectId, ParseRow).ToList();
contacts.ForEach(x => m_dbAdapter.Contact.AddContact(x));
var logicModel = Platform.GetProject(project.ProjectGuid);
contacts.ForEach(x =>
logicModel.Activity.Add(project.ProjectId, ActivityObjectType.Contact, x.Guid, "增加机构：" + x.OrganizationName));
return ActionUtils.Success(contacts.Count);
}));
}
public void TestValidation()
{
var table = new List <List <object> >();
table.Add(new List <object> {
7657, 1, 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, 1, 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, 1, 2, 3, "2016/09/12"
});
table.Add(new List <object> {
0, "123.5", 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, "123.5", 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, "23.5", 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, "23.5", 2, 3, "2016-09-12"
});
var validation = new ExcelValidation();
validation.Add(CellRange.Cell(0, 0), new CellTextValidation(0, 10));
validation.Add(CellRange.Column(4), new CellTextValidation(0, 10));
validation.Add(CellRange.Column(1), new CellNumberValidation());
validation.Add(CellRange.Column(4), new CellDateValidation());
validation.Add(CellRange.Row(6), new CellNumberValidation());
var tableHeaderRowsCount = 1;
validation.Check(table, tableHeaderRowsCount);
}
public ActionResult ImportTable(string projectSeriesGuid)
{
return(ActionUtils.Json(() =>
{
var projectSeriesLogicModel = new ProjectSeriesLogicModel(CurrentUserName, projectSeriesGuid);
var project = projectSeriesLogicModel.CurrentProject.Instance;
CheckPermission(PermissionObjectType.Project, project.ProjectGuid, PermissionType.Write);
var file = Request.Files[0];
byte[] bytes = new byte[file.InputStream.Length];
file.InputStream.Read(bytes, 0, bytes.Length);
file.InputStream.Seek(0, SeekOrigin.Begin);
Stream newStream = new MemoryStream(bytes);
var tableHeaderRowsCount = ExcelUtils.GetTableHeaderRowsCount(newStream, 0, 0, tableHeader);
var table = ExcelUtils.ParseExcel(file.InputStream, 0, tableHeaderRowsCount, 0, 9);
var validation = new ExcelValidation();
validation.Add(CellRange.Column(0), new CellTextValidation(1, 30));
validation.Add(CellRange.Column(1), new CellTextValidation(1, 500));
validation.Add(CellRange.Column(2), new CellTextValidation(1, 30));
validation.Add(CellRange.Column(3), new CellDateValidation());
validation.Add(CellRange.Column(4), new CellDateValidation(false));
//检查工作状态
Func <string, string> checkTaskStatus = (cellText) =>
{
if (!string.IsNullOrWhiteSpace(cellText) && cellText != "-" && cellText != TranslateUtils.ToCnString(TaskStatus.Waitting) &&
cellText != TranslateUtils.ToCnString(TaskStatus.Overdue))
{
return "导入工作的工作状态只能为空、[等待]或[逾期]";
}
return string.Empty;
};
validation.Add(CellRange.Column(5), new CellCustomValidation(checkTaskStatus));
//检查负责人
int projectId = project.ProjectId;
var personInCharges = GetPersonInCharges(projectSeriesLogicModel, projectId);
Func <List <string>, string, string> checkPersonInCharge = (personInChargeList, cellText) =>
{
var userName = GetPersonInCharge(cellText);
if (!personInChargeList.Contains(userName))
{
return "负责人[" + cellText + "]不存在";
}
return string.Empty;
};
validation.Add(CellRange.Column(6), new CellCustomValidation(checkPersonInCharge, personInCharges));
//不检查只有taskGroup列，其他列均为空的行
var columns = new List <CellRange>()
{
CellRange.Column(2), CellRange.Column(3), CellRange.Column(4),
CellRange.Column(5), CellRange.Column(6), CellRange.Column(7), CellRange.Column(8)
};
Func <string, bool> ExceptCondition = (x) =>
{
return x != string.Empty;
};
validation.JudgeColumn = new ColumnJudge(columns, ExceptCondition);
//检查开始时间是否大于截止时间
Func <object, object, string> lessThanOrEqualTo = (left, right) =>
{
var leftText = left.ToString();
var rightText = right.ToString();
if (!string.IsNullOrWhiteSpace(leftText) && leftText != "-")
{
var startTime = DateTime.Parse(leftText);
var endTime = DateTime.Parse(rightText);
if (startTime > endTime)
{
return "开始时间[" + leftText + "]不能大于结束时间[" + rightText + "]";
}
}
return string.Empty;
};
validation.CompareColumn = new ColumnComparison(CellRange.Column(3), CellRange.Column(4), lessThanOrEqualTo);
validation.Check(table, tableHeaderRowsCount);
//创建taskGroups
List <TaskGroup> newTaskGroups = new List <TaskGroup>();
for (int iRow = 0; iRow < table.Count; iRow++)
{
var row = table[iRow];
var taskGroup = ParseTaskGroups(newTaskGroups, row, iRow, projectId);
if (taskGroup != null)
{
newTaskGroups.Add(taskGroup);
}
}
var projectLogicModel = new ProjectLogicModel(CurrentUserName, project);
var permissionLogicModel = new PermissionLogicModel(projectLogicModel);
var projectSeries = projectSeriesLogicModel.Instance;
newTaskGroups.ForEach(x => {
var taskGroup = m_dbAdapter.TaskGroup.NewTaskGroup(x.ProjectId, x.Name, x.Description);
permissionLogicModel.SetPermission(projectSeries, project, taskGroup.Guid, PermissionObjectType.TaskGroup);
projectLogicModel.Activity.Add(x.ProjectId, ActivityObjectType.TaskGroup, taskGroup.Guid, "新建工作组：" + taskGroup.Name);
});
//创建tasks
var taskGroups = m_dbAdapter.TaskGroup.GetByProjectId(projectId);
var dicTaskGroups = taskGroups.ToDictionary(x => x.Name);
List <Task> tasks = new List <Task>();
for (int iRow = 0; iRow < table.Count; iRow++)
{
var row = table[iRow].ToList();
if (row.Count > 2 && (!string.IsNullOrWhiteSpace(row[2].ToString())) && row[2].ToString() != "-")
{
var taskGroup = dicTaskGroups[row[0].ToString()];
tasks.Add(ParseTasks(row, iRow, taskGroup.Id, project));
}
}
tasks.ForEach(x => m_dbAdapter.Task.NewTask(x));
Dictionary <string, string> msgDic = new Dictionary <string, string>();
foreach (var task in tasks)
{
var msg = string.Format("创建task:shortCode={0};name={1};startTime={2};endTime={3};personInCharge={4};"
+ "taskStatus={5};taskTarget={6};taskDetail={7};projectId={8};projectName={9};taskGroupId={10}",
task.ShortCode, task.Description, task.StartTime, task.EndTime, task.PersonInCharge, task.TaskStatus,
task.TaskTarget, task.TaskDetail, task.ProjectId, task.ProjectName, task.TaskGroupId);
msgDic[task.ShortCode] = msg;
}
tasks.ForEach(x => {
permissionLogicModel.SetPermission(projectSeries, project, x.ShortCode, PermissionObjectType.Task);
projectLogicModel.Activity.Add(projectId, ActivityObjectType.Task, x.ShortCode, "创建工作：" + x.Description);
m_dbAdapter.Project.NewEditProductLog(EditProductType.CreateTask, x.ProjectId, msgDic[x.ShortCode], "");
});
var result = new {
taskGroupCount = newTaskGroups.Count,
taskCount = tasks.Count
};
return ActionUtils.Success(result);
}));
}
public ActionResult ExportTable(string projectSeriesGuid)
{
return(ActionUtils.Json(() =>
{
var projectSeries = new ProjectSeriesLogicModel(CurrentUserName, projectSeriesGuid);
var project = projectSeries.CurrentProject.Instance;
CheckPermission(PermissionObjectType.Project, project.ProjectGuid, PermissionType.Read);
var taskGroups = projectSeries.CurrentProject.TaskGroups;
var allPermissionTaskGroupUid = m_dbAdapter.Permission.GetObjectUids(CurrentUserName, PermissionObjectType.TaskGroup, PermissionType.Read).ToDictionary(x => x);
var hasPermissionTaskGroups = taskGroups.Where(x => allPermissionTaskGroupUid.ContainsKey(x.Instance.Guid)).ToList();
var tableDic = new Dictionary <TaskGroup, List <Task> >();
var tasks = new List <Task>();
var projectLogicModel = new ProjectLogicModel(CurrentUserName, project);
hasPermissionTaskGroups.ForEach(x => {
var taskGroupLogicModel = projectLogicModel.TaskGroups.Single(y => y.Instance.Guid == x.Instance.Guid);
var allPermissionTaskUid = m_dbAdapter.Permission.GetObjectUids(CurrentUserName, PermissionObjectType.Task, PermissionType.Read).ToDictionary(y => y);
var hasPermissionTasks = taskGroupLogicModel.Tasks.Where(y => allPermissionTaskUid.ContainsKey(y.ShortCode)).ToList();
tableDic.Add(x.Instance, hasPermissionTasks);
tasks.AddRange(hasPermissionTasks);
});
var personInCharges = tasks.Where(x => !string.IsNullOrWhiteSpace(x.PersonInCharge)).Select(x => x.PersonInCharge);
Platform.UserProfile.Precache(personInCharges);
var table = new DataTable();
table.Columns.Add("工作组名称", typeof(System.String));
table.Columns.Add("工作组描述", typeof(System.String));
table.Columns.Add("工作名称", typeof(System.String));
table.Columns.Add("开始时间", typeof(System.String));
table.Columns.Add("截止时间", typeof(System.String));
table.Columns.Add("工作状态", typeof(System.String));
table.Columns.Add("负责人", typeof(System.String));
table.Columns.Add("工作目标", typeof(System.String));
table.Columns.Add("工作描述", typeof(System.String));
foreach (var taskGroupName in tableDic.Keys)
{
if (tableDic[taskGroupName].Count == 0)
{
var row = table.NewRow();
row["工作组名称"] = taskGroupName.Name;
row["工作组描述"] = taskGroupName.Description;
row["工作名称"] = string.Empty;
row["开始时间"] = string.Empty;
row["截止时间"] = string.Empty;
row["工作状态"] = string.Empty;
row["负责人"] = string.Empty;
row["工作目标"] = string.Empty;
row["工作描述"] = string.Empty;
table.Rows.Add(row);
}
else
{
foreach (var task in tableDic[taskGroupName])
{
var row = table.NewRow();
row["工作组名称"] = taskGroupName.Name;
row["工作组描述"] = taskGroupName.Description;
row["工作名称"] = task.Description;
row["开始时间"] = Toolkit.DateToString(task.StartTime);
row["截止时间"] = Toolkit.DateToString(task.EndTime);
row["工作状态"] = string.IsNullOrWhiteSpace(task.TaskStatus.ToString()) || task.TaskStatus.ToString() == "-"? task.TaskStatus.ToString()
: TranslateUtils.ToCnString(CommUtils.ParseEnum <TaskStatus>(task.TaskStatus.ToString()));
row["负责人"] = string.IsNullOrWhiteSpace(task.PersonInCharge) ? string.Empty :
Platform.UserProfile.Get(task.PersonInCharge).RealName + "(" + Platform.UserProfile.Get(task.PersonInCharge).UserName + ")";
row["工作目标"] = task.TaskTarget;
row["工作描述"] = task.TaskDetail;
table.Rows.Add(row);
}
}
}
var taskStatusIndex = table.Columns.IndexOf("工作状态");
var sheet = new Sheet("TaskGroupTable", table);
sheet.SheetStyle.Add(new CellRangeStyle()
{
Range = CellRange.Column(taskStatusIndex), Style = new CellRangeStyleTaskStatus(), Rule = CellRangeRule.IgnoreEmptyCell
});
var workbook = new Workbook("TaskGroupTable", sheet);
var resource = workbook.ToExcel(CurrentUserName);
return ActionUtils.Success(resource.Guid);
}));
}