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