/// <summary> /// 获得数据列表 /// </summary> public List <LPWeb.Model.AutoCampaigns> DataTableToList(DataTable dt) { List <LPWeb.Model.AutoCampaigns> modelList = new List <LPWeb.Model.AutoCampaigns>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { LPWeb.Model.AutoCampaigns model; for (int n = 0; n < rowsCount; n++) { model = new LPWeb.Model.AutoCampaigns(); if (dt.Rows[n]["CampaignId"].ToString() != "") { model.CampaignId = int.Parse(dt.Rows[n]["CampaignId"].ToString()); } if (dt.Rows[n]["PaidBy"].ToString() != "") { model.PaidBy = int.Parse(dt.Rows[n]["PaidBy"].ToString()); } if (dt.Rows[n]["Enabled"].ToString() != "") { if ((dt.Rows[n]["Enabled"].ToString() == "1") || (dt.Rows[n]["Enabled"].ToString().ToLower() == "true")) { model.Enabled = true; } else { model.Enabled = false; } } if (dt.Rows[n]["SelectedBy"].ToString() != "") { model.SelectedBy = int.Parse(dt.Rows[n]["SelectedBy"].ToString()); } if (dt.Rows[n]["Started"].ToString() != "") { model.Started = DateTime.Parse(dt.Rows[n]["Started"].ToString()); } model.LoanType = dt.Rows[n]["LoanType"].ToString(); if (dt.Rows[n]["TemplStageId"].ToString() != "") { model.TemplStageId = int.Parse(dt.Rows[n]["TemplStageId"].ToString()); } modelList.Add(model); } } return(modelList); }
protected void btnSave_Click(object sender, EventArgs e) { #region get rule data string sRuleName = this.txtRuleName.Text.Trim(); string sDesc = this.txtDesc.Text.Trim(); if (string.IsNullOrEmpty(sDesc)) { sDesc = txtRuleName.Text.Trim(); this.txtDesc.Text = sDesc; } string sRecomEmailTemplateID = this.ddlRecomActionTemplate.SelectedValue; int isRecomEmailTemplateID = Convert.ToInt32(sRecomEmailTemplateID); string sAlertEmailTemplateID = this.ddlAlertEmailTemplate.SelectedValue; int iAlertEmailTemplateID = Convert.ToInt32(sAlertEmailTemplateID); bool bReqAck = this.chkReqAck.Checked; string sAdvFormula = this.txtFormula.Text.Trim(); string sScope = this.ddlScope.SelectedValue; Int16 iScope = Convert.ToInt16(sScope); #region get loan target //string sTarget = this.ddlTarget.SelectedValue; //Int16 iTarget = Convert.ToInt16(sTarget); LPWeb.Model.Template_Rules_LoanTarget modelLoanTarget = new LPWeb.Model.Template_Rules_LoanTarget(); modelLoanTarget.ActiveLoans = this.chkTargetActiveLoans.Checked; modelLoanTarget.ActiveLeads = this.chkTargetActiveLeads.Checked; modelLoanTarget.ArchivedLoans = this.chkTargetArchivedLoans.Checked; modelLoanTarget.ArchivedLeads = this.chkTargetArchivedLeads.Checked; Int16 iTarget = modelLoanTarget.LoanTargetValue; if (iTarget == 0) { this.ClientScript.RegisterClientScriptBlock(this.GetType(), "_NoLoanTarget", "$('#divContainer').hide();alert('No target for rule selected. Please select a rule target.');$('#divContainer').show();", true); return; } #endregion #endregion Template_Rules RuleManager = new Template_Rules(); #region 检查Rule Name是否重复 bool bIsExist = RuleManager.IsExist_Create(sRuleName); if (bIsExist == true) { this.ClientScript.RegisterClientScriptBlock(this.GetType(), "_Duplicate", "$('#divContainer').hide();alert('The rule name has been taken. Please use a different name.');$('#divContainer').show();", true); return; } #endregion #region get condition data string sSequences = this.hdnSequences.Text; string sPointFieldIDs = this.hdnPointFieldIDs.Text; string sConditions = this.hdnConditions.Text; string sTolerances = this.hdnTolerances.Text; // [$xxx$],[$yyy$],[$zzz$] string sToleranceTypes = this.hdnToleranceTypes.Text; // $,%,#null# #endregion #region build conditiion list DataTable ConditionList = RuleManager.GetConditionList(" and 1=0"); string[] SequenceArray = sSequences.Split(','); string[] PointFieldIDArray = sPointFieldIDs.Split(','); string[] ConditionArray = sConditions.Split(','); string[] ToleranceArray = sTolerances.Split(','); string[] ToleranceTypeArray = sToleranceTypes.Split(','); for (int i = 0; i < PointFieldIDArray.Length; i++) { string sSequence = SequenceArray[i]; string sPointFieldID = PointFieldIDArray[i]; string sConditionID = ConditionArray[i]; string sToleranceBlock = ToleranceArray[i]; string sToleranceType = ToleranceTypeArray[i]; #region format Tolerance string sTelerance = sToleranceBlock.Replace("[$", string.Empty); sTelerance = sTelerance.Replace("$]", string.Empty); #endregion #region add rows DataRow ConditionRow = ConditionList.NewRow(); ConditionRow["RuleCondId"] = 0; ConditionRow["RuleId"] = 0; ConditionRow["PointFieldId"] = Convert.ToInt32(sPointFieldID); ConditionRow["Condition"] = Convert.ToInt32(sConditionID); ConditionRow["Tolerance"] = sTelerance; if (sToleranceType == "#null#") { ConditionRow["ToleranceType"] = DBNull.Value; } else if (sToleranceType == "#empty#") { ConditionRow["ToleranceType"] = string.Empty; } else { ConditionRow["ToleranceType"] = sToleranceType; } ConditionRow["Sequence"] = Convert.ToInt32(sSequence); ConditionList.Rows.Add(ConditionRow); #endregion } #endregion // insert if (sAdvFormula.Trim() == string.Empty) { sAdvFormula = sSequences.Replace(",", " AND "); } int iSelCampaignID = 0; if (hfSelCampaigns.Value != "") { iSelCampaignID = Convert.ToInt32(hfSelCampaigns.Value); AutoCampaigns _bAutoCampaigns = new AutoCampaigns(); int iCount = _bAutoCampaigns.GetMarketingCount(" AND CampaignId=" + iSelCampaignID); if (iCount == 0) { LPWeb.Model.AutoCampaigns _mAutoCampaigns = new LPWeb.Model.AutoCampaigns(); _mAutoCampaigns.CampaignId = iSelCampaignID; _mAutoCampaigns.PaidBy = 0; _mAutoCampaigns.Enabled = true; _mAutoCampaigns.SelectedBy = CurrUser.iUserID; _bAutoCampaigns.Add(_mAutoCampaigns); } } int nNewId = RuleManager.InsertRule(sRuleName, sDesc, iAlertEmailTemplateID, bReqAck, isRecomEmailTemplateID, sAdvFormula, iScope, iTarget, ConditionList, iSelCampaignID); DataTable dtNewRuleWithEmailTpltInfo = RuleManager.GetRuleWithAlertEmailTpltInfo(nNewId); string strReturn = "<table></table>"; if (dtNewRuleWithEmailTpltInfo.Rows.Count > 0) { strReturn = "<table><Rule RuleId=\"{0}\" Name=\"{1}\" AlertEmailTemplId=\"{2}\" AlertEmailTpltName=\"{3}\"></Rule></table>"; strReturn = string.Format(strReturn, dtNewRuleWithEmailTpltInfo.Rows[0]["RuleId"], string.Format("{0}", dtNewRuleWithEmailTpltInfo.Rows[0]["Name"]).Replace("<", "&lt;"), dtNewRuleWithEmailTpltInfo.Rows[0]["AlertEmailTemplId"], string.Format("{0}", dtNewRuleWithEmailTpltInfo.Rows[0]["AlertEmailTpltName"]).Replace("<", "&lt;")); } strReturn = strReturn.Replace('<', '\u0001').Replace("'", "'"); // success //this.ClientScript.RegisterClientScriptBlock(this.GetType(), "_Success", "$('#divContainer').hide();alert('Create rule successfully.');window.parent.location.href=window.parent.location.href;", true); this.ClientScript.RegisterClientScriptBlock(this.GetType(), "_Success", string.Format("addSuccessfully('{0}');", strReturn), true); // changed by peter 20110116 }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LPWeb.Model.AutoCampaigns model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(LPWeb.Model.AutoCampaigns model) { dal.Add(model); }