/// <summary>
/// add or update task data
/// </summary>
/// <param name="taskModel"></param>
private void SaveWflTask(LPWeb.Model.Template_Wfl_Tasks taskModel)
{
try
{
if (taskModel.TemplTaskId == 0)
{
this.iTaskID = this.taskTmpMgr.Add(taskModel);
this.hdnTaskID.Value = this.iTaskID.ToString();
}
else
{
this.taskTmpMgr.Update(taskModel);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadTaskData()
{
this.tbxTemplateName.Text = "";
this.tbxTaskName.Text = "";
this.tbxDescription.Text = "";
this.ddlOwner.SelectedIndex = -1;
this.tbxDueDaysByDate.Text = "";
this.tbxDueDaysByTask.Text = "";
this.tbxDaysDueAfterCreationDate.Text = "";
this.ddlPrerequisiteTask.SelectedIndex = -1;
this.ddlWarningEmail.SelectedIndex = -1;
//this.ddlCompletionEmail.SelectedIndex = -1;
this.ddlOverdueEmail.SelectedIndex = -1;
this.ddlStage.SelectedIndex = -1;
LPWeb.Model.Template_Wfl_Tasks model = null;
try
{
Template_Workflow templateMgr = new Template_Workflow();
LPWeb.Model.Template_Workflow tempModel = new Model.Template_Workflow();
tempModel = templateMgr.GetModel(this.iTemplateID);
Template_Wfl_Stages wflStageMgr = new Template_Wfl_Stages();
LPWeb.Model.Template_Wfl_Stages stageModel = new Model.Template_Wfl_Stages();
this.iCalculationMethod = tempModel.CalculationMethod;
if (this.iStageID != 0)
{
stageModel = wflStageMgr.GetModel(this.iStageID);
if (stageModel.CalculationMethod.ToString() != "" && stageModel.CalculationMethod.ToString() != "0")
{
iCalculationMethod = int.Parse(stageModel.CalculationMethod.ToString());
}
}
this.tbxTemplateName.Text = tempModel.Name;
model = this.taskTmpMgr.GetModel(this.iTaskID);
if (this.iTaskID == 0 || model == null)
{
if (this.iTemplateID != 0)
{
if (this.iStageID != 0)
{
this.ddlStage.SelectedValue = this.iStageID.ToString();
}
}
this.chkEnable.Checked = true;
return;
}
//Get Template Name by taskid
this.ddlStage.SelectedValue = model.WflStageId.ToString();
this.tbxTaskName.Text = model.Name;
this.tbxDescription.Text = model.Description;
this.ddlOwner.SelectedValue = model.OwnerRoleId.ToString();
this.tbxDueDaysByDate.Text = model.DaysDueFromCoe.ToString();
this.tbxDueDaysByTask.Text = model.DaysDueAfterPrerequisite.ToString();
this.tbxDaysDueAfterCreationDate.Text = model.DaysFromCreation.ToString();
this.ddlPrerequisiteTask.SelectedValue = model.PrerequisiteTaskId.ToString();
if (this.ddlPrerequisiteTask.SelectedIndex > 0)
{
this.ddlStage.Enabled = false;
}
if (model.Enabled)
{
this.chkEnable.Checked = true;
}
else
{
this.chkEnable.Checked = false;
}
if (model.ExternalViewing)
{
this.chkExternalViewing.Checked = true;
}
else
{
this.chkExternalViewing.Checked = false;
}
//
if (iCalculationMethod == 1)
{
this.tbxDueDaysByDate.Enabled = true;
if (model.DaysFromCreation.ToString() == "" || model.DaysFromCreation.ToString() == "0")
{
this.tbxDaysDueAfterCreationDate.Enabled = false;
}
//this.tbxDaysDueAfterCreationDate.Text = "";
}
else if (iCalculationMethod == 2)
{
if (model.DaysDueFromCoe.ToString() == "" || model.DaysDueFromCoe.ToString() == "0")
{
this.tbxDueDaysByDate.Enabled = false;
}
//this.tbxDueDaysByDate.Text = "";
this.tbxDaysDueAfterCreationDate.Enabled = true;
}
this.ddlWarningEmail.SelectedValue = model.WarningEmailId.ToString();
//this.ddlCompletionEmail.SelectedValue = model.CompletionEmailId.ToString();
this.ddlOverdueEmail.SelectedValue = model.OverdueEmailId.ToString();
//Set prerequisitetask status base on taskid
DataTable dtTask = this.taskTmpMgr.GetList(" PrerequisiteTaskId=" + this.iTaskID.ToString()).Tables[0];
if (dtTask.Rows.Count > 0)
{
this.ddlPrerequisiteTask.SelectedIndex = -1;
this.tbxDueDaysByTask.Text = "";
this.tbxDueDaysByTask.ReadOnly = true;
this.tbxDaysDueAfterCreationDate.Text = "";
this.tbxDaysDueAfterCreationDate.ReadOnly = true;
this.ddlPrerequisiteTask.Enabled = false;
this.ddlStage.Enabled = false;
this.hdnIsDependTask.Value = "true";
}
//Check Referenced
LoanTasks loanTaskMgr = new LoanTasks();
if (loanTaskMgr.GetLoanTaskList(" AND a.TemplTaskId=" + this.iTaskID.ToString()).Rows.Count > 0)
{
this.hdnIsReferenced.Value = "true";
}
this.hdnTaskID.Value = this.iTaskID.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.Template_Wfl_Tasks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Template_Wfl_Tasks(");
strSql.Append("WflStageId,Name,Enabled,Type,DaysDueFromCoe,PrerequisiteTaskId,DaysDueAfterPrerequisite,OwnerRoleId,WarningEmailId,OverdueEmailId,CompletionEmailId,SequenceNumber,Description,DaysFromCreation,ExternalViewing)");
strSql.Append(" values (");
strSql.Append("@WflStageId,@Name,@Enabled,@Type,@DaysDueFromCoe,@PrerequisiteTaskId,@DaysDueAfterPrerequisite,@OwnerRoleId,@WarningEmailId,@OverdueEmailId,@CompletionEmailId,@SequenceNumber,@Description,@DaysFromCreation,@ExternalViewing)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@WflStageId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@Enabled", SqlDbType.Bit, 1),
new SqlParameter("@Type", SqlDbType.SmallInt, 2),
new SqlParameter("@DaysDueFromCoe", SqlDbType.SmallInt, 2),
new SqlParameter("@PrerequisiteTaskId", SqlDbType.Int, 4),
new SqlParameter("@DaysDueAfterPrerequisite", SqlDbType.SmallInt, 2),
new SqlParameter("@OwnerRoleId", SqlDbType.Int, 4),
new SqlParameter("@WarningEmailId", SqlDbType.Int, 4),
new SqlParameter("@OverdueEmailId", SqlDbType.Int, 4),
new SqlParameter("@CompletionEmailId", SqlDbType.Int, 4),
new SqlParameter("@SequenceNumber", SqlDbType.SmallInt, 2),
new SqlParameter("@Description", SqlDbType.NVarChar, 500),
new SqlParameter("@DaysFromCreation", SqlDbType.SmallInt, 2),
new SqlParameter("@ExternalViewing", SqlDbType.Bit, 1)
};
parameters[0].Value = model.WflStageId;
parameters[1].Value = model.Name;
parameters[2].Value = model.Enabled;
parameters[3].Value = model.Type;
if (model.DaysDueFromCoe == null)
{
parameters[4].Value = DBNull.Value;
}
else
{
parameters[4].Value = model.DaysDueFromCoe;
}
parameters[5].Value = model.PrerequisiteTaskId;
if (model.DaysDueAfterPrerequisite == null)
{
parameters[6].Value = DBNull.Value;
}
else
{
parameters[6].Value = model.DaysDueAfterPrerequisite;
}
parameters[7].Value = model.OwnerRoleId;
if (model.WarningEmailId == 0 || model.WarningEmailId == null)
{
parameters[8].Value = DBNull.Value;
}
else
{
parameters[8].Value = model.WarningEmailId;
}
if (model.OverdueEmailId == 0 || model.OverdueEmailId == null)
{
parameters[9].Value = DBNull.Value;
}
else
{
parameters[9].Value = model.OverdueEmailId;
}
if (model.CompletionEmailId == 0 || model.CompletionEmailId == null)
{
parameters[10].Value = DBNull.Value;
}
else
{
parameters[10].Value = model.CompletionEmailId;
}
parameters[11].Value = model.SequenceNumber;
parameters[12].Value = model.Description;
if (model.DaysFromCreation == null)
{
parameters[13].Value = DBNull.Value;
}
else
{
parameters[13].Value = model.DaysFromCreation;
}
parameters[14].Value = model.ExternalViewing;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Template_Wfl_Tasks GetModel(int TemplTaskId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TemplTaskId,WflStageId,Name,Enabled,Type,DaysDueFromCoe,PrerequisiteTaskId,DaysDueAfterPrerequisite,OwnerRoleId,WarningEmailId,OverdueEmailId,CompletionEmailId,SequenceNumber,Description,DaysFromCreation,ExternalViewing from Template_Wfl_Tasks ");
strSql.Append(" where TemplTaskId=@TemplTaskId ");
SqlParameter[] parameters =
{
new SqlParameter("@TemplTaskId", SqlDbType.Int, 4)
};
parameters[0].Value = TemplTaskId;
LPWeb.Model.Template_Wfl_Tasks model = new LPWeb.Model.Template_Wfl_Tasks();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["TemplTaskId"].ToString() != "")
{
model.TemplTaskId = int.Parse(ds.Tables[0].Rows[0]["TemplTaskId"].ToString());
}
if (ds.Tables[0].Rows[0]["WflStageId"].ToString() != "")
{
model.WflStageId = int.Parse(ds.Tables[0].Rows[0]["WflStageId"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
if (ds.Tables[0].Rows[0]["Enabled"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Enabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["Enabled"].ToString().ToLower() == "true"))
{
model.Enabled = true;
}
else
{
model.Enabled = false;
}
}
if (ds.Tables[0].Rows[0]["Type"].ToString() != "")
{
model.Type = int.Parse(ds.Tables[0].Rows[0]["Type"].ToString());
}
if (ds.Tables[0].Rows[0]["DaysDueFromCoe"].ToString() != "")
{
model.DaysDueFromCoe = int.Parse(ds.Tables[0].Rows[0]["DaysDueFromCoe"].ToString());
}
if (ds.Tables[0].Rows[0]["PrerequisiteTaskId"].ToString() != "")
{
model.PrerequisiteTaskId = int.Parse(ds.Tables[0].Rows[0]["PrerequisiteTaskId"].ToString());
}
if (ds.Tables[0].Rows[0]["DaysDueAfterPrerequisite"].ToString() != "")
{
model.DaysDueAfterPrerequisite = int.Parse(ds.Tables[0].Rows[0]["DaysDueAfterPrerequisite"].ToString());
}
if (ds.Tables[0].Rows[0]["OwnerRoleId"].ToString() != "")
{
model.OwnerRoleId = int.Parse(ds.Tables[0].Rows[0]["OwnerRoleId"].ToString());
}
if (ds.Tables[0].Rows[0]["WarningEmailId"].ToString() != "")
{
model.WarningEmailId = int.Parse(ds.Tables[0].Rows[0]["WarningEmailId"].ToString());
}
if (ds.Tables[0].Rows[0]["OverdueEmailId"].ToString() != "")
{
model.OverdueEmailId = int.Parse(ds.Tables[0].Rows[0]["OverdueEmailId"].ToString());
}
if (ds.Tables[0].Rows[0]["CompletionEmailId"].ToString() != "")
{
model.CompletionEmailId = int.Parse(ds.Tables[0].Rows[0]["CompletionEmailId"].ToString());
}
if (ds.Tables[0].Rows[0]["SequenceNumber"].ToString() != "")
{
model.SequenceNumber = int.Parse(ds.Tables[0].Rows[0]["SequenceNumber"].ToString());
}
model.Description = ds.Tables[0].Rows[0]["Description"].ToString();
if (ds.Tables[0].Rows[0]["DaysFromCreation"].ToString() != "")
{
model.DaysFromCreation = int.Parse(ds.Tables[0].Rows[0]["DaysFromCreation"].ToString());
}
if (ds.Tables[0].Rows[0]["ExternalViewing"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["ExternalViewing"].ToString() == "1") || (ds.Tables[0].Rows[0]["ExternalViewing"].ToString().ToLower() == "true"))
{
model.ExternalViewing = true;
}
else
{
model.ExternalViewing = false;
}
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Template_Wfl_Tasks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Template_Wfl_Tasks set ");
strSql.Append("WflStageId=@WflStageId,");
strSql.Append("Name=@Name,");
strSql.Append("Enabled=@Enabled,");
strSql.Append("Type=@Type,");
strSql.Append("DaysDueFromCoe=@DaysDueFromCoe,");
strSql.Append("PrerequisiteTaskId=@PrerequisiteTaskId,");
strSql.Append("DaysDueAfterPrerequisite=@DaysDueAfterPrerequisite,");
strSql.Append("OwnerRoleId=@OwnerRoleId,");
strSql.Append("WarningEmailId=@WarningEmailId,");
strSql.Append("OverdueEmailId=@OverdueEmailId,");
strSql.Append("CompletionEmailId=@CompletionEmailId,");
strSql.Append("SequenceNumber=@SequenceNumber,");
strSql.Append("Description=@Description,");
strSql.Append("DaysFromCreation=@DaysFromCreation,");
strSql.Append("ExternalViewing=@ExternalViewing");
strSql.Append(" where TemplTaskId=@TemplTaskId ");
SqlParameter[] parameters =
{
new SqlParameter("@TemplTaskId", SqlDbType.Int, 4),
new SqlParameter("@WflStageId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 255),
new SqlParameter("@Enabled", SqlDbType.Bit, 1),
new SqlParameter("@Type", SqlDbType.SmallInt, 2),
new SqlParameter("@DaysDueFromCoe", SqlDbType.SmallInt, 2),
new SqlParameter("@PrerequisiteTaskId", SqlDbType.Int, 4),
new SqlParameter("@DaysDueAfterPrerequisite", SqlDbType.SmallInt, 2),
new SqlParameter("@OwnerRoleId", SqlDbType.Int, 4),
new SqlParameter("@WarningEmailId", SqlDbType.Int, 4),
new SqlParameter("@OverdueEmailId", SqlDbType.Int, 4),
new SqlParameter("@CompletionEmailId", SqlDbType.Int, 4),
new SqlParameter("@SequenceNumber", SqlDbType.SmallInt, 2),
new SqlParameter("@Description", SqlDbType.NVarChar, 500),
new SqlParameter("@DaysFromCreation", SqlDbType.SmallInt, 2),
new SqlParameter("@ExternalViewing", SqlDbType.Bit, 1)
};
parameters[0].Value = model.TemplTaskId;
parameters[1].Value = model.WflStageId;
parameters[2].Value = model.Name;
parameters[3].Value = model.Enabled;
parameters[4].Value = model.Type;
if (model.DaysDueFromCoe == null)
{
parameters[5].Value = DBNull.Value;
}
else
{
parameters[5].Value = model.DaysDueFromCoe;
}
parameters[6].Value = model.PrerequisiteTaskId;
if (model.DaysDueAfterPrerequisite == null)
{
parameters[7].Value = DBNull.Value;
}
else
{
parameters[7].Value = model.DaysDueAfterPrerequisite;
}
parameters[8].Value = model.OwnerRoleId;
if (model.WarningEmailId == 0 || model.WarningEmailId == null)
{
parameters[9].Value = DBNull.Value;
}
else
{
parameters[9].Value = model.WarningEmailId;
}
if (model.OverdueEmailId == 0 || model.OverdueEmailId == null)
{
parameters[10].Value = DBNull.Value;
}
else
{
parameters[10].Value = model.OverdueEmailId;
}
if (model.CompletionEmailId == 0 || model.CompletionEmailId == null)
{
parameters[11].Value = DBNull.Value;
}
else
{
parameters[11].Value = model.CompletionEmailId;
}
parameters[12].Value = model.SequenceNumber;
parameters[13].Value = model.Description;
if (model.DaysFromCreation == null)
{
parameters[14].Value = DBNull.Value;
}
else
{
parameters[14].Value = model.DaysFromCreation;
}
parameters[15].Value = model.ExternalViewing;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
