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