public static bool Update(Model.MemberBonus model)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update MemberBonus set ");
strSql.Append(" MID = @MID , ");
strSql.Append(" TotalPoints = @TotalPoints , ");
strSql.Append(" ValidPoints = @ValidPoints , ");
strSql.Append(" TotalBonus = @TotalBonus , ");
strSql.Append(" ValidBonus = @ValidBonus ");
strSql.Append(" where MID=@MID ");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@TotalPoints", SqlDbType.Int, 4),
new SqlParameter("@ValidPoints", SqlDbType.Int, 4),
new SqlParameter("@TotalBonus", SqlDbType.Int, 4),
new SqlParameter("@ValidBonus", SqlDbType.Int, 4)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.TotalPoints;
parameters[2].Value = model.ValidPoints;
parameters[3].Value = model.TotalBonus;
parameters[4].Value = model.ValidBonus;
System.Collections.Hashtable MyHs = new System.Collections.Hashtable();
MyHs.Add(strSql.ToString(), parameters);
return(DAL.CommonBase.RunHashtable(MyHs));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Insert(Model.MemberBonus model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberBonus(");
strSql.Append("MID,TotalPoints,ValidPoints,TotalBonus,ValidBonus");
strSql.Append(") values (");
strSql.Append("@MID,@TotalPoints,@ValidPoints,@TotalBonus,@ValidBonus");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@TotalPoints", SqlDbType.Int, 4),
new SqlParameter("@ValidPoints", SqlDbType.Int, 4),
new SqlParameter("@TotalBonus", SqlDbType.Int, 4),
new SqlParameter("@ValidBonus", SqlDbType.Int, 4)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.TotalPoints;
parameters[2].Value = model.ValidPoints;
parameters[3].Value = model.TotalBonus;
parameters[4].Value = model.ValidBonus;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
private static Model.MemberBonus DataRowToModel(DataRow row)
{
if (row != null)
{
Model.MemberBonus model = new Model.MemberBonus();
model.MID = row["MID"].ToString();
if (row["TotalPoints"].ToString() != "")
{
model.TotalPoints = int.Parse(row["TotalPoints"].ToString());
}
if (row["ValidPoints"].ToString() != "")
{
model.ValidPoints = int.Parse(row["ValidPoints"].ToString());
}
if (row["TotalBonus"].ToString() != "")
{
model.TotalBonus = int.Parse(row["TotalBonus"].ToString());
}
if (row["ValidBonus"].ToString() != "")
{
model.ValidBonus = int.Parse(row["ValidBonus"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public static bool Update(Model.MemberBonus model)
{
return(DAL.MemberBonus.Update(model));
}
public static bool Insert(Model.MemberBonus model)
{
return(DAL.MemberBonus.Insert(model));
}
public static System.Collections.Hashtable Insert(Model.MemberBonus model, System.Collections.Hashtable MyHs)
{
return(DAL.MemberBonus.Insert(model, MyHs));
}
public static bool Insert(Model.MemberBonus model)
{
return(DAL.CommonBase.RunHashtable(Insert(model, new System.Collections.Hashtable())));
}
