/// <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; } }