/// <summary>
///
/// </summary>
/// <param name="stageModel"></param>
private void SaveStage(LPWeb.Model.Template_Stages stageModel)
{
try
{
if (stageModel.TemplStageId == 0)
{
this.iStageID = this.stageMgr.Add(stageModel);
}
else
{
this.stageMgr.Update(stageModel);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.Template_Stages model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Template_Stages(");
strSql.Append("Name,Enabled,SequenceNumber,WorkflowType,Custom,PointStageNameField,PointStageDateField,Alias,DaysFromEstClose,DaysFromCreation)");
strSql.Append(" values (");
strSql.Append("@Name,@Enabled,@SequenceNumber,@WorkflowType,@Custom,@PointStageNameField,@PointStageDateField,@Alias,@DaysFromEstClose,@DaysFromCreation)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Enabled", SqlDbType.Bit, 1),
new SqlParameter("@SequenceNumber", SqlDbType.SmallInt, 2),
new SqlParameter("@WorkflowType", SqlDbType.NVarChar, 50),
new SqlParameter("@Custom", SqlDbType.Bit, 1),
new SqlParameter("@PointStageNameField", SqlDbType.SmallInt, 2),
new SqlParameter("@PointStageDateField", SqlDbType.SmallInt, 2),
new SqlParameter("@Alias", SqlDbType.NVarChar, 50),
new SqlParameter("@DaysFromEstClose", SqlDbType.SmallInt, 2),
new SqlParameter("@DaysFromCreation", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Enabled;
if (model.SequenceNumber == null)
{
parameters[2].Value = DBNull.Value;
}
else
{
parameters[2].Value = model.SequenceNumber;
}
parameters[3].Value = model.WorkflowType;
parameters[4].Value = model.Custom;
if (model.PointStageNameField == null)
{
parameters[5].Value = DBNull.Value;
}
else
{
parameters[5].Value = model.PointStageNameField;
}
if (model.PointStageDateField == null)
{
parameters[6].Value = DBNull.Value;
}
else
{
parameters[6].Value = model.PointStageDateField;
}
parameters[7].Value = model.Alias;
if (model.DaysFromEstClose == null)
{
parameters[8].Value = DBNull.Value;
}
else
{
parameters[8].Value = model.DaysFromEstClose;
}
if (model.DaysFromCreation == null)
{
parameters[9].Value = DBNull.Value;
}
else
{
parameters[9].Value = model.DaysFromCreation;
}
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LPWeb.Model.Template_Stages GetModel(int TemplStageId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TemplStageId,Name,Enabled,SequenceNumber,WorkflowType,Custom,PointStageNameField,PointStageDateField,Alias,DaysFromEstClose,DaysFromCreation from Template_Stages ");
strSql.Append(" where TemplStageId=@TemplStageId ");
SqlParameter[] parameters =
{
new SqlParameter("@TemplStageId", SqlDbType.Int, 4)
};
parameters[0].Value = TemplStageId;
LPWeb.Model.Template_Stages model = new LPWeb.Model.Template_Stages();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["TemplStageId"].ToString() != "")
{
model.TemplStageId = int.Parse(ds.Tables[0].Rows[0]["TemplStageId"].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]["SequenceNumber"].ToString() != "")
{
model.SequenceNumber = int.Parse(ds.Tables[0].Rows[0]["SequenceNumber"].ToString());
}
model.WorkflowType = ds.Tables[0].Rows[0]["WorkflowType"].ToString();
if (ds.Tables[0].Rows[0]["Custom"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Custom"].ToString() == "1") || (ds.Tables[0].Rows[0]["Custom"].ToString().ToLower() == "true"))
{
model.Custom = true;
}
else
{
model.Custom = false;
}
}
if (ds.Tables[0].Rows[0]["PointStageNameField"].ToString() != "")
{
model.PointStageNameField = int.Parse(ds.Tables[0].Rows[0]["PointStageNameField"].ToString());
}
if (ds.Tables[0].Rows[0]["PointStageDateField"].ToString() != "")
{
model.PointStageDateField = int.Parse(ds.Tables[0].Rows[0]["PointStageDateField"].ToString());
}
model.Alias = ds.Tables[0].Rows[0]["Alias"].ToString();
if (ds.Tables[0].Rows[0]["DaysFromEstClose"].ToString() != "")
{
model.DaysFromEstClose = int.Parse(ds.Tables[0].Rows[0]["DaysFromEstClose"].ToString());
}
if (ds.Tables[0].Rows[0]["DaysFromCreation"].ToString() != "")
{
model.DaysFromCreation = int.Parse(ds.Tables[0].Rows[0]["DaysFromCreation"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.Template_Stages model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Template_Stages set ");
strSql.Append("Name=@Name,");
strSql.Append("Enabled=@Enabled,");
strSql.Append("SequenceNumber=@SequenceNumber,");
strSql.Append("WorkflowType=@WorkflowType,");
strSql.Append("Custom=@Custom,");
strSql.Append("PointStageNameField=@PointStageNameField,");
strSql.Append("PointStageDateField=@PointStageDateField,");
strSql.Append("Alias=@Alias,");
strSql.Append("DaysFromEstClose=@DaysFromEstClose,");
strSql.Append("DaysFromCreation=@DaysFromCreation");
strSql.Append(" where TemplStageId=@TemplStageId ");
SqlParameter[] parameters =
{
new SqlParameter("@TemplStageId", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Enabled", SqlDbType.Bit, 1),
new SqlParameter("@SequenceNumber", SqlDbType.SmallInt, 2),
new SqlParameter("@WorkflowType", SqlDbType.NVarChar, 50),
new SqlParameter("@Custom", SqlDbType.Bit, 1),
new SqlParameter("@PointStageNameField", SqlDbType.SmallInt, 2),
new SqlParameter("@PointStageDateField", SqlDbType.SmallInt, 2),
new SqlParameter("@Alias", SqlDbType.NVarChar, 50),
new SqlParameter("@DaysFromEstClose", SqlDbType.SmallInt, 2),
new SqlParameter("@DaysFromCreation", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.TemplStageId;
parameters[1].Value = model.Name;
parameters[2].Value = model.Enabled;
if (model.SequenceNumber == null)
{
parameters[3].Value = DBNull.Value;
}
else
{
parameters[3].Value = model.SequenceNumber;
}
parameters[4].Value = model.WorkflowType;
parameters[5].Value = model.Custom;
if (model.PointStageNameField == null)
{
parameters[6].Value = DBNull.Value;
}
else
{
parameters[6].Value = model.PointStageNameField;
}
if (model.PointStageDateField == null)
{
parameters[7].Value = DBNull.Value;
}
else
{
parameters[7].Value = model.PointStageDateField;
}
parameters[8].Value = model.Alias;
if (model.DaysFromEstClose == null)
{
parameters[9].Value = DBNull.Value;
}
else
{
parameters[9].Value = model.DaysFromEstClose;
}
if (model.DaysFromCreation == null)
{
parameters[10].Value = DBNull.Value;
}
else
{
parameters[10].Value = model.DaysFromCreation;
}
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// load stage data base on stage id
/// </summary>
private void LoadStageData()
{
this.tbxStageName.Text = "";
this.tbxAlias.Text = "";
this.chkEnabled.Checked = false;
this.ddlType.SelectedIndex = 0;
this.tbxSequence.Text = "";
this.tbxType.Text = "";
this.tbxDaysAfterCreationDate.Text = "";
this.tbxDaysFromEstClose.Text = "";
this.tbxPointStageDateField.Text = "";
this.tbxPointStageNameField.Text = "";
LPWeb.Model.Template_Stages model = null;
try
{
model = this.stageMgr.GetModel(this.iStageID);
if (this.iStageID == 0 || model == null)
{
this.tbxType.Text = "Custom";
this.bCustom = true;
this.chkEnabled.Checked = true;
this.tbxSequence.Text = "0";
this.hdnMaxIDType1.Value = Convert.ToString(this.stageMgr.GetMaxSequence("processing") + 1);
this.hdnMaxIDType2.Value = Convert.ToString(this.stageMgr.GetMaxSequence("prospect") + 1);
return;
}
this.tbxStageName.Text = model.Name;
this.tbxAlias.Text = model.Alias;
this.chkEnabled.Checked = model.Enabled;
if (model.WorkflowType.ToLower().Trim() == "processing")
{
this.ddlType.SelectedIndex = 1;
}
else if (model.WorkflowType.ToLower().Trim() == "prospect")
{
this.ddlType.SelectedIndex = 2;
}
else
{
this.ddlType.SelectedIndex = 1;
}
this.tbxSequence.Text = model.SequenceNumber.ToString();
this.bCustom = model.Custom;
if (model.Custom)
{
this.tbxType.Text = "Custom";
}
else
{
this.tbxType.Text = "Standard";
}
this.tbxDaysAfterCreationDate.Text = "";
this.tbxDaysFromEstClose.Text = "";
this.tbxPointStageDateField.Text = model.PointStageDateField.ToString();
this.tbxPointStageNameField.Text = model.PointStageNameField.ToString();
this.tbxDaysFromEstClose.Text = model.DaysFromEstClose.ToString();
this.tbxDaysAfterCreationDate.Text = model.DaysFromCreation.ToString();
this.hdnStageID.Value = this.iStageID.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
