/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XTaskInfo info = modelInfo as XTaskInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.TaskTypeId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "TaskTypeId")); //任务类型ID
info.TaskName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "TaskName")); //任务名称
info.TaskNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "TaskNo")); //任务编号
info.StartPeople = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StartPeople")); //发起人
info.DispatchDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "DispatchDate")); //发派日期
info.AssignPeople = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "AssignPeople")); //负责人
info.StartDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "StartDate")); //起始日期
info.PreEndDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "PreEndDate")); //预计完成日期
info.ShortDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ShortDesc")); //任务简介
info.Require = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Require")); //任务要求
info.Content = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Content")); //工作内容
info.Remark = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Remark")); //备注信息
info.InputUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputUserId")); //录入人
info.InputTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputTime")); //录入时间
info.UpdateUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateUserId")); //修改人
info.UpdateTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateTime")); //修改时间
info.ParentId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ParentId")); //
info.TaskStatus = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "TaskStatus")); //
}
private void AddFiles()
{
TreeNode selectedNode = this.tvTask.SelectedNode;
if (!this.IsChildTaskNode(selectedNode))
{
XMessageBox.ShowError("请选择要提交文档的子任务！");
return;
}
IList <XModelBase> gridList = this.grdFiles.DataSource as IList <XModelBase>;
XTaskInfo taskInfo = selectedNode.Tag as XTaskInfo;
if (taskInfo.AssignPeople != XCommon.LoginUsersInfo.RID)
{
XMessageBox.ShowError("当前登录人不是任务负责人，不能提交文档！");
return;
}
frmTaskFilesEdit frm = new frmTaskFilesEdit(gridList, selectedNode);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.grdFiles.DataSource = null;
this.grdFiles.DataSource = frm.ModelList;
this.grdFiles.Refresh();
}
}
/// <summary>
/// 获取删除时插入日志表sql
/// </summary>
/// <param name="modelInfo"></param>
/// <param name="userId"></param>
/// <returns></returns>
protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId)
{
XTaskInfo info = modelInfo as XTaskInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,TaskTypeId,TaskName,TaskNo,StartPeople,DispatchDate,AssignPeople,StartDate,PreEndDate,ShortDesc,Require,Content,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,ParentId,TaskStatus,OperateUserId,Operate,OperateTime,NewID) SELECT RID,TaskTypeId,TaskName,TaskNo,StartPeople,DispatchDate,AssignPeople,StartDate,PreEndDate,ShortDesc,Require,Content,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,ParentId,TaskStatus,'" + userId + "','删除',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'";
return(sql);
}
protected override void SavedAfterOperate()
{
XTaskInfo taskInfo = this.m_CurrentModel as XTaskInfo;
TreeNode treeNode = null;
if (this.m_EditStatus == XEditStatus.AddNew)
{
treeNode = new TreeNode();
treeNode.Text = taskInfo.TaskName;
if (this.m_TreeView != null)
{
this.m_TreeView.Nodes.Add(treeNode);
}
else
{
this.m_TreeNode.Nodes.Add(treeNode);
}
}
else
{
treeNode = this.m_TreeNode;
this.m_TreeNode.Text = taskInfo.TaskName;
}
treeNode.Tag = taskInfo;
}
void cmdFinishTask_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
TreeNode selectedNode = this.tvTask.SelectedNode;
if (selectedNode == null)
{
XMessageBox.ShowError("请选择要结束的任务！");
return;
}
XTaskInfo taskInfo = selectedNode.Tag as XTaskInfo;
if (taskInfo == null)
{
XMessageBox.ShowError("请选择要结束的任务！");
return;
}
if (XMessageBox.ShowQuestion("确定要结束选中的任务吗？") == System.Windows.Forms.DialogResult.No)
{
return;
}
if (this.m_TaskBusiness.UpdateTaskStatus("结束", taskInfo.ID))
{
XMessageBox.ShowRemindMessage("结束任务成功！");
}
else
{
XMessageBox.ShowError("结束任务失败！");
}
}
/// <summary>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetInsertSql(XModelBase modelInfo)
{
XTaskInfo info = modelInfo as XTaskInfo;
string sql = "Insert Into " + this.TableName + "(RID,TaskTypeId,TaskName,TaskNo,StartPeople,DispatchDate,AssignPeople,StartDate,PreEndDate,ShortDesc,Require,Content,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,ParentId,TaskStatus)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',{14},'{15}',{16},'{17}','{18}')";
sql = String.Format(sql, info.RID, info.TaskTypeId, info.TaskName, info.TaskNo, info.StartPeople, info.DispatchDate, info.AssignPeople, info.StartDate, info.PreEndDate, info.ShortDesc, info.Require, info.Content, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.ParentId, info.TaskStatus);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XTaskInfo task = modelInfo as XTaskInfo;
if (task == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XTaskInfo info = modelInfo as XTaskInfo;
sql = "Update " + this.TableName + " Set TaskTypeId='{0}',TaskName='{1}',TaskNo='{2}',StartPeople='{3}',DispatchDate='{4}',AssignPeople='{5}',StartDate='{6}',PreEndDate='{7}',ShortDesc='{8}',Require='{9}',Content='{10}',Remark='{11}',UpdateUserId='{12}',UpdateTime={13},ParentId='{14}',TaskStatus='{15}' Where RID='{16}'";
sql = string.Format(sql, info.TaskTypeId, info.TaskName, info.TaskNo, info.StartPeople, info.DispatchDate, info.AssignPeople, info.StartDate, info.PreEndDate, info.ShortDesc, info.Require, info.Content, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.ParentId, info.TaskStatus, info.RID);
return(sql);
}
private void InitParentTask()
{
if (this.m_TreeNode != null)
{
XTaskInfo parentTask = this.m_TreeNode.Tag as XTaskInfo;
this.txtParentTask.Text = parentTask.TaskName;
this.txtParentTask.Tag = parentTask.RID;
this.txtParentNo.Text = parentTask.TaskNo;
this.dtParentStartDate.Value = XHelper.GetDateTime(parentTask.StartDate);
this.dtParentPreEndDate.Value = XHelper.GetDateTime(parentTask.PreEndDate);
}
}
/// <summary>
/// 设置修改时的默认值
/// </summary>
protected override void SetDefaultValue()
{
XVTaskInfo info = this.m_CurrentModel as XVTaskInfo;
if (info == null)
{
return;
}
if (info.TaskTypeId != string.Empty)
{
this.txtTaskTypeId.Text = info.TaskType;
this.txtTaskTypeId.ValueMember = info.TaskTypeId;
this.txtTaskTypeId.DisplayMember = info.TaskName;
}
this.txtTaskName.Text = info.TaskName;
this.txtTaskNo.Text = info.TaskNo;
this.txtStartPeople.Text = info.StartPeople;
this.dtDispatchDate.Value = XHelper.GetDateTime(info.DispatchDate);
if (info.AssignPeople != string.Empty)
{
this.txtAssignPeople.Text = info.AssignPeopleName;
this.txtAssignPeople.ValueMember = info.AssignPeople;
this.txtAssignPeople.DisplayMember = info.AssignPeopleName;
}
this.dtStartDate.Value = XHelper.GetDateTime(info.StartDate);
this.dtPreEndDate.Value = XHelper.GetDateTime(info.PreEndDate);
this.txtShortDesc.Text = info.ShortDesc;
this.txtRequire.Text = info.Require;
this.txtContent.Text = info.Content;
this.txtRemark.Text = info.Remark;
this.txtTaskStatus.Text = info.TaskStatus;
if (this.m_TreeNode.Parent != null)
{
XTaskInfo parentTaskInfo = this.m_TreeNode.Parent.Tag as XTaskInfo;
this.txtParentTask.Text = parentTaskInfo.TaskName;
this.txtParentTask.Tag = parentTaskInfo;
}
}
/// <summary>
/// 填充实体信息
/// </summary>
protected override void FillModelInfo()
{
XVTaskInfo info = this.m_CurrentModel as XVTaskInfo;
if (this.m_EditStatus == XEditStatus.AddNew || this.m_EditStatus == XEditStatus.AddContinue)
{
info.RID = this.GetNewId();
info.ID = info.RID;
if (this.m_TreeNode != null)
{
XTaskInfo parentTaskInfo = this.m_TreeNode.Tag as XTaskInfo;
info.ParentId = parentTaskInfo.RID;
}
}
info.TaskTypeId = this.txtTaskTypeId.ValueMember;
info.TaskType = this.txtTaskTypeId.DisplayMember;
info.TaskName = this.txtTaskName.Text;
info.TaskNo = this.txtTaskNo.Text;
info.StartPeople = this.txtStartPeople.Text;
info.DispatchDate = XHelper.GetFormatedDate(this.dtDispatchDate.Value);
info.AssignPeople = this.txtAssignPeople.ValueMember;
info.AssignPeopleName = this.txtAssignPeople.DisplayMember;
info.StartDate = XHelper.GetFormatedDate(this.dtStartDate.Value);
info.PreEndDate = XHelper.GetFormatedDate(this.dtPreEndDate.Value);
info.ShortDesc = this.txtShortDesc.Text;
info.Require = this.txtRequire.Text;
info.Content = this.txtContent.Text;
info.Remark = this.txtRemark.Text;
info.TaskStatus = this.txtTaskStatus.Text.Trim();
this.FillSaveDetailList();
if (this.m_EditStatus == XEditStatus.Edit)
{
this.FillDeleteList();//填充删除的明细字典
}
base.FillModelInfo();
}
protected virtual bool IsEndModel(XModelBase model)
{
if (model is XTaskInfo)
{
XTaskInfo taskInfo = model as XTaskInfo;
string parentId = taskInfo.ParentId;
if (parentId == string.Empty)
{
string where = this.GetIsEndModelWhere();
//如果是根任务
return(this.m_TaskBusiness.IsEndModel(model, where));
}
else
{
return(this.m_TaskFilesBusiness.GetCountByMainId(taskInfo.ID) == 0);
}
}
else
{
return(true);
}
}
private void tvTask_AfterSelect(object sender, TreeViewEventArgs e)
{
TreeNode selectedNode = e.Node;
XVTaskInfo info = selectedNode.Tag as XVTaskInfo;
if (m_LastSelctedNode != null)
{
m_LastSelctedNode.BackColor = Color.White;
}
selectedNode.BackColor = Color.LightBlue;
m_LastSelctedNode = selectedNode;
if (info != null)
{
//如果选中的是任务节点
this.tabTask.SelectedIndex = 0;
this.txtTaskTypeId.Text = info.TaskType;
this.txtTaskName.Text = info.TaskName;
this.txtTaskNo.Text = info.TaskNo;
this.txtStartPeople.Text = info.StartPeople;
this.dtDispatchDate.Value = XHelper.GetDateTime(info.DispatchDate);
this.txtAssignPeople.Text = info.AssignPeopleName;
this.dtStartDate.Value = XHelper.GetDateTime(info.StartDate);
this.dtPreEndDate.Value = XHelper.GetDateTime(info.PreEndDate);
this.txtShortDesc.Text = info.ShortDesc;
this.txtRequire.Text = info.Require;
this.txtContent.Text = info.Content;
this.txtRemark.Text = info.Remark;
if (selectedNode.Parent != null)
{
XTaskInfo parentTaskInfo = selectedNode.Parent.Tag as XTaskInfo;
this.txtParentTask.Text = parentTaskInfo.TaskName;
this.txtParentTaskNo.Text = parentTaskInfo.TaskNo;
this.dtParentStartDate.Value = XHelper.GetDateTime(parentTaskInfo.StartDate);
this.dtParentPreEndDate.Value = XHelper.GetDateTime(parentTaskInfo.PreEndDate);
}
else
{
this.txtParentTask.Text = string.Empty;
this.txtParentTaskNo.Text = string.Empty;
//this.dtParentStartDate.Value =
//this.dtParentPreEndDate.Value = XHelper.GetDateTime(parentTaskInfo.PreEndDate);
}
if (this.IsChildTaskNode(selectedNode))
{
//如果选择的是子任务
this.FillFilesGrid(info.RID);
}
else
{
//如果是根级节点
this.grdFiles.DataSource = this.m_TaskFilesBusiness.GetViewListByRootTaskId(info.RID);
this.grdFiles.AutoSizeColumns();
}
this.FillTaskAttachGrid(info.RID);
}
else
{
this.tabTask.SelectedIndex = 1;
//文件节点
XVTaskFilesInfo taskFileInfo = selectedNode.Tag as XVTaskFilesInfo;
this.txtFileName.Text = taskFileInfo.FileName;
this.txtFileDesc.Text = taskFileInfo.FileDesc;
this.txtFileRemark.Text = taskFileInfo.Remark;
}
}
