/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ECommerce.CM.Model.CMColumn model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CMColumn(");
strSql.Append("ColName,ParentId,Level,Status,AddTime,SeoKey,SeoDes,ClickRate)");
strSql.Append(" values (");
strSql.Append("@ColName,@ParentId,@Level,@Status,@AddTime,@SeoKey,@SeoDes,@ClickRate)");
strSql.Append(";select @@IDENTITY");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ColName", DbType.String, model.ColName);
db.AddInParameter(dbCommand, "ParentId", DbType.Int32, model.ParentId);
db.AddInParameter(dbCommand, "Level", DbType.Int32, model.Level);
db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime);
db.AddInParameter(dbCommand, "SeoKey", DbType.String, model.SeoKey);
db.AddInParameter(dbCommand, "SeoDes", DbType.String, model.SeoDes);
db.AddInParameter(dbCommand, "ClickRate", DbType.Int32, model.ClickRate);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
ECommerce.CM.DAL.CMColumn cDAL = new ECommerce.CM.DAL.CMColumn(); //创建商品分类DAL对象
protected void Page_Load(object sender, EventArgs e)
{
//VerifyPage("", false);
if (!IsPostBack)
{
ColId = Request.QueryString["ColId"] == null ? "" : Request.QueryString["ColId"]; //获取商品分类Id
prParentId = Request.QueryString["PTColId"] == null ? "" : Request.QueryString["PTColId"]; //获取添加子商品分类Id
if (!string.IsNullOrEmpty(ColId)) //判断商品分类Id是否为空
{
//this.lblColName.Text = "修改栏目信息";
ECommerce.CM.Model.CMColumn cModel = cDAL.GetModel(Convert.ToInt32(ColId)); //通过商品分类Id查询商品分类信息
if (cModel != null) //判断商品分类对象是否为空
{
this.txtColName.Value = cModel.ColName; //给商品分类名称文本框赋值
}
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.CM.Model.CMColumn DataRowToModel(DataRow row)
{
ECommerce.CM.Model.CMColumn model=new ECommerce.CM.Model.CMColumn();
if (row != null)
{
if(row["ColId"]!=null && row["ColId"].ToString()!="")
{
model.ColId=Convert.ToInt32(row["ColId"].ToString());
}
if(row["ColName"]!=null)
{
model.ColName=row["ColName"].ToString();
}
if(row["ParentId"]!=null && row["ParentId"].ToString()!="")
{
model.ParentId=Convert.ToInt32(row["ParentId"].ToString());
}
if(row["Level"]!=null && row["Level"].ToString()!="")
{
model.Level=Convert.ToInt32(row["Level"].ToString());
}
if(row["Status"]!=null && row["Status"].ToString()!="")
{
model.Status=Convert.ToInt32(row["Status"].ToString());
}
if(row["AddTime"]!=null && row["AddTime"].ToString()!="")
{
model.AddTime=Convert.ToDateTime(row["AddTime"].ToString());
}
if(row["SeoKey"]!=null)
{
model.SeoKey=row["SeoKey"].ToString();
}
if(row["SeoDes"]!=null)
{
model.SeoDes=row["SeoDes"].ToString();
}
if(row["ClickRate"]!=null && row["ClickRate"].ToString()!="")
{
model.ClickRate=Convert.ToInt32(row["ClickRate"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.CM.Model.CMColumn DataRowToModel(DataRow row)
{
ECommerce.CM.Model.CMColumn model = new ECommerce.CM.Model.CMColumn();
if (row != null)
{
if (row["ColId"] != null && row["ColId"].ToString() != "")
{
model.ColId = Convert.ToInt32(row["ColId"].ToString());
}
if (row["ColName"] != null)
{
model.ColName = row["ColName"].ToString();
}
if (row["ParentId"] != null && row["ParentId"].ToString() != "")
{
model.ParentId = Convert.ToInt32(row["ParentId"].ToString());
}
if (row["Level"] != null && row["Level"].ToString() != "")
{
model.Level = Convert.ToInt32(row["Level"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = Convert.ToInt32(row["Status"].ToString());
}
if (row["AddTime"] != null && row["AddTime"].ToString() != "")
{
model.AddTime = Convert.ToDateTime(row["AddTime"].ToString());
}
if (row["SeoKey"] != null)
{
model.SeoKey = row["SeoKey"].ToString();
}
if (row["SeoDes"] != null)
{
model.SeoDes = row["SeoDes"].ToString();
}
if (row["ClickRate"] != null && row["ClickRate"].ToString() != "")
{
model.ClickRate = Convert.ToInt32(row["ClickRate"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.CM.Model.CMColumn GetModel(int ColId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ColId,ColName,ParentId,Level,Status,AddTime,SeoKey,SeoDes,ClickRate from CMColumn ");
strSql.Append(" where ColId=@ColId ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ColId", DbType.Int32, ColId);
ECommerce.CM.Model.CMColumn model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ECommerce.CM.Model.CMColumn ReaderBind(IDataReader dataReader)
{
ECommerce.CM.Model.CMColumn model = new ECommerce.CM.Model.CMColumn();
object ojb;
ojb = dataReader["ColId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ColId = Convert.ToInt32(ojb);
}
model.ColName = dataReader["ColName"].ToString();
ojb = dataReader["ParentId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ParentId = Convert.ToInt32(ojb);
}
ojb = dataReader["Level"];
if (ojb != null && ojb != DBNull.Value)
{
model.Level = Convert.ToInt32(ojb);
}
ojb = dataReader["Status"];
if (ojb != null && ojb != DBNull.Value)
{
model.Status = Convert.ToInt32(ojb);
}
ojb = dataReader["AddTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.AddTime = Convert.ToDateTime(ojb);
}
model.SeoKey = dataReader["SeoKey"].ToString();
model.SeoDes = dataReader["SeoDes"].ToString();
ojb = dataReader["ClickRate"];
if (ojb != null && ojb != DBNull.Value)
{
model.ClickRate = Convert.ToInt32(ojb);
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ECommerce.CM.Model.CMColumn model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CMColumn set ");
strSql.Append("ColName=@ColName,");
strSql.Append("ParentId=@ParentId,");
strSql.Append("Level=@Level,");
strSql.Append("Status=@Status,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("SeoKey=@SeoKey,");
strSql.Append("SeoDes=@SeoDes,");
strSql.Append("ClickRate=@ClickRate");
strSql.Append(" where ColId=@ColId ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ColId", DbType.Int32, model.ColId);
db.AddInParameter(dbCommand, "ColName", DbType.String, model.ColName);
db.AddInParameter(dbCommand, "ParentId", DbType.Int32, model.ParentId);
db.AddInParameter(dbCommand, "Level", DbType.Int32, model.Level);
db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime);
db.AddInParameter(dbCommand, "SeoKey", DbType.String, model.SeoKey);
db.AddInParameter(dbCommand, "SeoDes", DbType.String, model.SeoDes);
db.AddInParameter(dbCommand, "ClickRate", DbType.Int32, model.ClickRate);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ECommerce.CM.Model.CMColumn ReaderBind(IDataReader dataReader)
{
ECommerce.CM.Model.CMColumn model=new ECommerce.CM.Model.CMColumn();
object ojb;
ojb = dataReader["ColId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ColId=Convert.ToInt32(ojb);
}
model.ColName=dataReader["ColName"].ToString();
ojb = dataReader["ParentId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ParentId=Convert.ToInt32(ojb);
}
ojb = dataReader["Level"];
if(ojb != null && ojb != DBNull.Value)
{
model.Level=Convert.ToInt32(ojb);
}
ojb = dataReader["Status"];
if(ojb != null && ojb != DBNull.Value)
{
model.Status=Convert.ToInt32(ojb);
}
ojb = dataReader["AddTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.AddTime=Convert.ToDateTime(ojb);
}
model.SeoKey=dataReader["SeoKey"].ToString();
model.SeoDes=dataReader["SeoDes"].ToString();
ojb = dataReader["ClickRate"];
if(ojb != null && ojb != DBNull.Value)
{
model.ClickRate=Convert.ToInt32(ojb);
}
return model;
}
ECommerce.CM.DAL.CMColumn cDAL = new ECommerce.CM.DAL.CMColumn(); //创建商品分类DAL对象
#endregion Fields
#region Methods
protected void Page_Load(object sender, EventArgs e)
{
//VerifyPage("", false);
if (!IsPostBack)
{
var ColId = Request.QueryString["ColId"]; //编辑分类Id
var PTColId = Request.QueryString["PTColId"]; //添加商品子分类分类Id
var detColId = Request.QueryString["detColId"]; //删除商品分类Id
var ColName = HttpUtility.UrlDecode(Request.QueryString["ColName"]); //商品名称
#region 删除分类
if (!string.IsNullOrEmpty(detColId))
{
#region 查询分类是否有品牌关联
string sqlWhere = "";
List<SqlParameter> parameters = new List<SqlParameter>(); //创建查询参数集合
sqlWhere = " ColId=@detColId ";
var parameter = new SqlParameter("@detColId", DbType.AnsiString);
parameter.Value = detColId;
parameters.Add(parameter);
DataSet dts = aDAL.GetList(sqlWhere, parameters); //通过商品分类Id查找关系表数据
if (dts.Tables[0].Rows.Count > 0)
{
Response.Write("该栏目下有文章，不能删除");
Response.End();
}
#endregion
#region 判断分类是否存在子分类
else
{
string sqlWhere1 = "";
List<SqlParameter> parameters1 = new List<SqlParameter>(); //创建查询参数集合
sqlWhere1 = " ParentId=@ParentId ";
var parameter1 = new SqlParameter("@ParentId", DbType.AnsiString);
parameter1.Value = detColId;
parameters1.Add(parameter1);
DataSet dt = cDAL.GetList(sqlWhere1, parameters1); //通过商品分类Id查找子分类
if (dt.Tables[0].Rows.Count > 0)
{
Response.Write("存在子栏目，不能删除，请先删除子栏目");
Response.End();
}
else
{
Response.Write(cDAL.Delete(Convert.ToInt32(detColId)) ? "删除成功" : "删除失败");
Response.End();
}
}
#endregion
}
#endregion
#region 添加、修改、添加子分类
else
{
if (string.IsNullOrEmpty(ColName))
{
Response.Write("栏目名称不能为空");
Response.End();
}
#region 修改商品分类
ECommerce.CM.Model.CMColumn cMdoel = new ECommerce.CM.Model.CMColumn(); //商品分类实体
if (!string.IsNullOrEmpty(ColId))
{
try
{
cMdoel = cDAL.GetModel(Convert.ToInt32(ColId));
if (cMdoel != null)
{
string sqlWhere = "";
List<SqlParameter> parameters = new List<SqlParameter>(); //创建查询参数集合
sqlWhere = " ColName=@ColName and ColId!=@ColId and ParentId=@PID"; //查询条件
var parameter = new SqlParameter("@ColName", DbType.AnsiString);
parameter.Value = ColName;
parameters.Add(parameter);
var parameter1 = new SqlParameter("@ColId", DbType.AnsiString);
parameter1.Value = ColId;
parameters.Add(parameter1);
var parameter2 = new SqlParameter("@PID", DbType.AnsiString);
parameter2.Value = cMdoel.ParentId;
parameters.Add(parameter2);
var ds = cDAL.GetList(sqlWhere, parameters); //通过商品分类名称及商品Id查询商品分类名称是否存在
if (ds.Tables[0].Rows.Count > 0)
{
Response.Write("该栏目名称已存在");
Response.End();
}
cMdoel.ColName = ColName;
Response.Write(cDAL.Update(cMdoel) ? "保存成功" : "保存失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
throw ex;
}
catch
{
Response.Write("保存失败");
Response.End();
}
}
#endregion
#region 添加子分类、添加分类
else
{
try
{
string sqlWhere = "";
List<SqlParameter> parameters = new List<SqlParameter>(); //创建查询参数集合
sqlWhere = " ColName=@PTName and ParentId=@ColId ";
var parameter = new SqlParameter("@PTName", DbType.AnsiString);
parameter.Value = ColName;
parameters.Add(parameter);
var parameter1 = new SqlParameter("@ColId", DbType.AnsiString);
parameter1.Value = PTColId;
parameters.Add(parameter1);
var ds = cDAL.GetList(sqlWhere, parameters);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Write("该栏目名称已存在");
Response.End();
}
cMdoel.ColName = ColName; //商品分类名称
cMdoel.ClickRate = 0; //点击率
cMdoel.Status = 1; //状态
if (!string.IsNullOrEmpty(PTColId)) //判断是添加子商品分类还是父商品分类
{
cMdoel.ParentId = Convert.ToInt32(PTColId); //商品分类父节点字段
var proInfo = cDAL.GetModel(Convert.ToInt32(PTColId));
if (proInfo != null)
{
cMdoel.Level = proInfo.Level + 1; //分类级别
}
}
else
{
cMdoel.ParentId = 0; //分类父节点
cMdoel.Level = 1; //分类级别
}
cMdoel.AddTime = DateTime.Now; //添加时间
Response.Write(cDAL.Add(cMdoel) > 0 ? "保存成功" : "保存失败");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
throw ex;
}
catch
{
Response.Write("保存失败");
Response.End();
}
}
#endregion
}
#endregion
}
}
ECommerce.CM.DAL.CMArticle aDAL = new ECommerce.CM.DAL.CMArticle(); //创建商品品牌DAL对象
protected void Page_Load(object sender, EventArgs e)
{
//VerifyPage("", false);
if (!IsPostBack)
{
var ColId = Request.QueryString["ColId"]; //编辑分类Id
var PTColId = Request.QueryString["PTColId"]; //添加商品子分类分类Id
var detColId = Request.QueryString["detColId"]; //删除商品分类Id
var ColName = HttpUtility.UrlDecode(Request.QueryString["ColName"]); //商品名称
#region 除分类
if (!string.IsNullOrEmpty(detColId))
{
#region 查询分类是否有品牌关联
string sqlWhere = "";
List <SqlParameter> parameters = new List <SqlParameter>(); //创建查询参数集合
sqlWhere = " ColId=@detColId ";
var parameter = new SqlParameter("@detColId", DbType.AnsiString);
parameter.Value = detColId;
parameters.Add(parameter);
DataSet dts = aDAL.GetList(sqlWhere, parameters); //通过商品分类Id查找关系表数据
if (dts.Tables[0].Rows.Count > 0)
{
Response.Write("该栏目下有文章，不能删除");
Response.End();
}
#endregion
#region 判断分类是否存在子分类
else
{
string sqlWhere1 = "";
List <SqlParameter> parameters1 = new List <SqlParameter>(); //创建查询参数集合
sqlWhere1 = " ParentId=@ParentId ";
var parameter1 = new SqlParameter("@ParentId", DbType.AnsiString);
parameter1.Value = detColId;
parameters1.Add(parameter1);
DataSet dt = cDAL.GetList(sqlWhere1, parameters1); //通过商品分类Id查找子分类
if (dt.Tables[0].Rows.Count > 0)
{
Response.Write("存在子栏目，不能删除，请先删除子栏目");
Response.End();
}
else
{
Response.Write(cDAL.Delete(Convert.ToInt32(detColId)) ? "删除成功" : "删除失败");
Response.End();
}
}
#endregion
}
#endregion
#region 添加、修改、添加子分类
else
{
if (string.IsNullOrEmpty(ColName))
{
Response.Write("栏目名称不能为空");
Response.End();
}
#region 修改商品分类
ECommerce.CM.Model.CMColumn cMdoel = new ECommerce.CM.Model.CMColumn(); //商品分类实体
if (!string.IsNullOrEmpty(ColId))
{
try
{
cMdoel = cDAL.GetModel(Convert.ToInt32(ColId));
if (cMdoel != null)
{
string sqlWhere = "";
List <SqlParameter> parameters = new List <SqlParameter>(); //创建查询参数集合
sqlWhere = " ColName=@ColName and ColId!=@ColId and ParentId=@PID"; //查询条件
var parameter = new SqlParameter("@ColName", DbType.AnsiString);
parameter.Value = ColName;
parameters.Add(parameter);
var parameter1 = new SqlParameter("@ColId", DbType.AnsiString);
parameter1.Value = ColId;
parameters.Add(parameter1);
var parameter2 = new SqlParameter("@PID", DbType.AnsiString);
parameter2.Value = cMdoel.ParentId;
parameters.Add(parameter2);
var ds = cDAL.GetList(sqlWhere, parameters); //通过商品分类名称及商品Id查询商品分类名称是否存在
if (ds.Tables[0].Rows.Count > 0)
{
Response.Write("该栏目名称已存在");
Response.End();
}
cMdoel.ColName = ColName;
Response.Write(cDAL.Update(cMdoel) ? "保存成功" : "保存失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
throw ex;
}
catch
{
Response.Write("保存失败");
Response.End();
}
}
#endregion
#region 添加子分类、添加分类
else
{
try
{
string sqlWhere = "";
List <SqlParameter> parameters = new List <SqlParameter>(); //创建查询参数集合
sqlWhere = " ColName=@PTName and ParentId=@ColId ";
var parameter = new SqlParameter("@PTName", DbType.AnsiString);
parameter.Value = ColName;
parameters.Add(parameter);
var parameter1 = new SqlParameter("@ColId", DbType.AnsiString);
parameter1.Value = PTColId;
parameters.Add(parameter1);
var ds = cDAL.GetList(sqlWhere, parameters);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Write("该栏目名称已存在");
Response.End();
}
cMdoel.ColName = ColName; //商品分类名称
cMdoel.ClickRate = 0; //点击率
cMdoel.Status = 1; //状态
if (!string.IsNullOrEmpty(PTColId)) //判断是添加子商品分类还是父商品分类
{
cMdoel.ParentId = Convert.ToInt32(PTColId); //商品分类父节点字段
var proInfo = cDAL.GetModel(Convert.ToInt32(PTColId));
if (proInfo != null)
{
cMdoel.Level = proInfo.Level + 1; //分类级别
}
}
else
{
cMdoel.ParentId = 0; //分类父节点
cMdoel.Level = 1; //分类级别
}
cMdoel.AddTime = DateTime.Now; //添加时间
Response.Write(cDAL.Add(cMdoel) > 0 ? "保存成功" : "保存失败");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
throw ex;
}
catch
{
Response.Write("保存失败");
Response.End();
}
}
#endregion
}
#endregion
}
}
