public void btnSave_Click(object sender, EventArgs e) { if (this.RuleBll.Exists(this.tType.Text.Trim())) { MessageBox.ShowSuccessTip(this, "已存在该规则码,请重新填写"); } else { Maticsoft.Model.Members.PointsRule model = new Maticsoft.Model.Members.PointsRule { RuleAction = this.tType.Text.Trim(), Name = this.tName.Text.Trim(), PointsLimitID = Convert.ToInt32(this.DropLimitName.SelectedValue), Description = this.tDesc.Text.Trim() }; if (PageValidate.IsNumber(this.tScore.Text.Trim())) { model.Score = Globals.SafeInt(this.tScore.Text.Trim(), 0); } if (this.RuleBll.Add(model)) { base.Response.Redirect("PointsRule.aspx"); } else { this.lblMsg.ForeColor = Color.Red; this.lblMsg.Text = "添加规则出错!"; } } }
public List<Maticsoft.Model.Members.PointsRule> DataTableToList(DataTable dt) { List<Maticsoft.Model.Members.PointsRule> list = new List<Maticsoft.Model.Members.PointsRule>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Members.PointsRule item = new Maticsoft.Model.Members.PointsRule(); if ((dt.Rows[i]["RuleAction"] != null) && (dt.Rows[i]["RuleAction"].ToString() != "")) { item.RuleAction = dt.Rows[i]["RuleAction"].ToString(); } if ((dt.Rows[i]["PointsLimitID"] != null) && (dt.Rows[i]["PointsLimitID"].ToString() != "")) { item.PointsLimitID = int.Parse(dt.Rows[i]["PointsLimitID"].ToString()); } if ((dt.Rows[i]["Name"] != null) && (dt.Rows[i]["Name"].ToString() != "")) { item.Name = dt.Rows[i]["Name"].ToString(); } if ((dt.Rows[i]["Score"] != null) && (dt.Rows[i]["Score"].ToString() != "")) { item.Score = int.Parse(dt.Rows[i]["Score"].ToString()); } if ((dt.Rows[i]["Description"] != null) && (dt.Rows[i]["Description"].ToString() != "")) { item.Description = dt.Rows[i]["Description"].ToString(); } list.Add(item); } } return list; }
public Maticsoft.Model.Members.PointsRule GetModel(string RuleAction) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 RuleAction,PointsLimitID,Name,Score,Description from Accounts_PointsRule "); builder.Append(" where RuleAction=@RuleAction "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@RuleAction", SqlDbType.NVarChar, 200) }; cmdParms[0].Value = RuleAction; Maticsoft.Model.Members.PointsRule rule = new Maticsoft.Model.Members.PointsRule(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["RuleAction"] != null) && (set.Tables[0].Rows[0]["RuleAction"].ToString() != "")) { rule.RuleAction = set.Tables[0].Rows[0]["RuleAction"].ToString(); } if ((set.Tables[0].Rows[0]["PointsLimitID"] != null) && (set.Tables[0].Rows[0]["PointsLimitID"].ToString() != "")) { rule.PointsLimitID = int.Parse(set.Tables[0].Rows[0]["PointsLimitID"].ToString()); } if ((set.Tables[0].Rows[0]["Name"] != null) && (set.Tables[0].Rows[0]["Name"].ToString() != "")) { rule.Name = set.Tables[0].Rows[0]["Name"].ToString(); } if ((set.Tables[0].Rows[0]["Score"] != null) && (set.Tables[0].Rows[0]["Score"].ToString() != "")) { rule.Score = int.Parse(set.Tables[0].Rows[0]["Score"].ToString()); } if ((set.Tables[0].Rows[0]["Description"] != null) && (set.Tables[0].Rows[0]["Description"].ToString() != "")) { rule.Description = set.Tables[0].Rows[0]["Description"].ToString(); } return rule; }