/// <summary>
/// 得到一个对象实体
/// </summary>
public VipSoft.Model.CardLevel DataRowToModel(DataRow row)
{
VipSoft.Model.CardLevel model=new VipSoft.Model.CardLevel();
if (row != null)
{
if(row["ID"]!=null && row["ID"].ToString()!="")
{
model.ID=int.Parse(row["ID"].ToString());
}
if(row["LevelName"]!=null)
{
model.LevelName=row["LevelName"].ToString();
}
if(row["NeedPoint"]!=null && row["NeedPoint"].ToString()!="")
{
model.NeedPoint=int.Parse(row["NeedPoint"].ToString());
}
if(row["Point"]!=null && row["Point"].ToString()!="")
{
model.Point=int.Parse(row["Point"].ToString());
}
if(row["Percent"]!=null && row["Percent"].ToString()!="")
{
model.Percent=decimal.Parse(row["Percent"].ToString());
}
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(VipSoft.Model.CardLevel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CardLevel set ");
strSql.Append("LevelName=@LevelName,");
strSql.Append("NeedPoint=@NeedPoint,");
strSql.Append("Point=@Point,");
strSql.Append("Percent=@Percent,");
strSql.Append("ShopID=@ShopID,");
strSql.Append("ShopName=@ShopName");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@LevelName", SqlDbType.VarChar, 50),
new SqlParameter("@NeedPoint", SqlDbType.Int, 4),
new SqlParameter("@Point", SqlDbType.Int, 4),
new SqlParameter("@Percent", SqlDbType.Float, 8),
new SqlParameter("@ShopID", SqlDbType.Int, 4),
new SqlParameter("@ShopName", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.LevelName;
parameters[1].Value = model.NeedPoint;
parameters[2].Value = model.Point;
parameters[3].Value = model.Percent;
parameters[4].Value = model.ShopID;
parameters[5].Value = model.ShopName;
parameters[6].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VipSoft.Model.CardLevel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CardLevel(");
strSql.Append("LevelName,NeedPoint,Point,Percent,ShopID,ShopName)");
strSql.Append(" values (");
strSql.Append("@LevelName,@NeedPoint,@Point,@Percent,@ShopID,@ShopName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@LevelName", SqlDbType.VarChar, 50),
new SqlParameter("@NeedPoint", SqlDbType.Int, 4),
new SqlParameter("@Point", SqlDbType.Int, 4),
new SqlParameter("@Percent", SqlDbType.Float, 8),
new SqlParameter("@ShopID", SqlDbType.Int, 4),
new SqlParameter("@ShopName", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.LevelName;
parameters[1].Value = model.NeedPoint;
parameters[2].Value = model.Point;
parameters[3].Value = model.Percent;
parameters[4].Value = model.ShopID;
parameters[5].Value = model.ShopName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public VipSoft.Model.CardLevel DataRowToModel(DataRow row)
{
VipSoft.Model.CardLevel model = new VipSoft.Model.CardLevel();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["LevelName"] != null)
{
model.LevelName = row["LevelName"].ToString();
}
if (row["NeedPoint"] != null && row["NeedPoint"].ToString() != "")
{
model.NeedPoint = int.Parse(row["NeedPoint"].ToString());
}
if (row["Point"] != null && row["Point"].ToString() != "")
{
model.Point = int.Parse(row["Point"].ToString());
}
if (row["Percent"] != null && row["Percent"].ToString() != "")
{
model.Percent = decimal.Parse(row["Percent"].ToString());
}
if (row["ShopID"] != null && row["ShopID"].ToString() != "")
{
model.ShopID = int.Parse(row["ShopID"].ToString());
}
if (row["ShopName"] != null)
{
model.ShopName = row["ShopName"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public VipSoft.Model.CardLevel GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,LevelName,NeedPoint,Point,Percent,ShopID,ShopName from CardLevel ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
VipSoft.Model.CardLevel model = new VipSoft.Model.CardLevel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void button_Manage_Click(object sender, EventArgs e)
{
if (!CheckInput())
return;
VipSoft.BLL.CardLevel cardL = new VipSoft.BLL.CardLevel();
string needP = this.textBox_needpoint.Text;
VipSoft.Model.CardLevel level = new VipSoft.Model.CardLevel();
level.LevelName=this.textBox_LevelName.Text;
level.NeedPoint=int.Parse(needP);
level.Point=int.Parse(this.textBox_Point.Text);
level.Percent=decimal.Parse(this.textBox_Percent.Text);
if (this.label_Flag.Text == "add")
{
if (cardL.Exists(this.textBox_LevelName.Text))
{
MessageBox.Show("等级名称重复，请重新输入！");
this.textBox_LevelName.Text = "";
this.textBox_LevelName.Focus();
return;
}
cardL.Add(level);
// 记录日志
VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
log.Add(new VipSoft.Model.SysLog(PublicState.Master,"会员等级管理",
string.Format("新增会员等级（名称{0}：所需积分{1}：兑换比例{2}：折扣比例{3}：）", this.textBox_LevelName.Text, needP, this.textBox_Point.Text, this.textBox_Percent.Text), DateTime.Now));
// 提示
MessageBox.Show("新等级录入成功。");
// 文本框数据清空
this.textBox_LevelName.Text = "";
this.textBox_Percent.Text = "";
this.textBox_Point.Text = "";
this.textBox_needpoint.Text = "";
}
// 编辑
else
{
level.ID = int.Parse(this.label_Flag.Text);
cardL.Update(level);
// 记录日志
VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
log.Add(new VipSoft.Model.SysLog(PublicState.Master,"会员等级管理",
string.Format("编辑会员等级（ID：{0}名称：{1}所需积分：{2}兑换比例：{3}折扣比例：{4}）", this.label_Flag.Text, this.textBox_LevelName.Text, needP, this.textBox_Point.Text, this.textBox_Percent.Text),
DateTime.Now));
// 提示
MessageBox.Show("等级修改成功。");
}
// 绑定数据
BindList();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public VipSoft.Model.CardLevel GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,LevelName,NeedPoint,Point,Percent,ShopID,ShopName from CardLevel ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = ID;
VipSoft.Model.CardLevel model=new VipSoft.Model.CardLevel();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
