/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_produceType GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ParentID,TypeName,Type01,Type02,Type03,Type04,Type05,Type06 from tb_produceType ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
lgk.Model.tb_produceType model = new lgk.Model.tb_produceType();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentID"] != null && ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
}
if (ds.Tables[0].Rows[0]["TypeName"] != null && ds.Tables[0].Rows[0]["TypeName"].ToString() != "")
{
model.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString();
}
if (ds.Tables[0].Rows[0]["Type01"] != null && ds.Tables[0].Rows[0]["Type01"].ToString() != "")
{
model.Type01 = int.Parse(ds.Tables[0].Rows[0]["Type01"].ToString());
}
if (ds.Tables[0].Rows[0]["Type02"] != null && ds.Tables[0].Rows[0]["Type02"].ToString() != "")
{
model.Type02 = int.Parse(ds.Tables[0].Rows[0]["Type02"].ToString());
}
if (ds.Tables[0].Rows[0]["Type03"] != null && ds.Tables[0].Rows[0]["Type03"].ToString() != "")
{
model.Type03 = decimal.Parse(ds.Tables[0].Rows[0]["Type03"].ToString());
}
if (ds.Tables[0].Rows[0]["Type04"] != null && ds.Tables[0].Rows[0]["Type04"].ToString() != "")
{
model.Type04 = decimal.Parse(ds.Tables[0].Rows[0]["Type04"].ToString());
}
if (ds.Tables[0].Rows[0]["Type05"] != null && ds.Tables[0].Rows[0]["Type05"].ToString() != "")
{
model.Type05 = ds.Tables[0].Rows[0]["Type05"].ToString();
}
if (ds.Tables[0].Rows[0]["Type06"] != null && ds.Tables[0].Rows[0]["Type06"].ToString() != "")
{
model.Type06 = ds.Tables[0].Rows[0]["Type06"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_produceType GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ParentID,TypeName,Type01,Type02,Type03,Type04,Type05,Type06 from tb_produceType ");
if (where != "")
{
strSql.Append(" where " + where);
}
lgk.Model.tb_produceType model = new lgk.Model.tb_produceType();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["ParentID"] != null && ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
}
if (ds.Tables[0].Rows[0]["TypeName"] != null && ds.Tables[0].Rows[0]["TypeName"].ToString() != "")
{
model.TypeName = ds.Tables[0].Rows[0]["TypeName"].ToString();
}
if (ds.Tables[0].Rows[0]["Type01"] != null && ds.Tables[0].Rows[0]["Type01"].ToString() != "")
{
model.Type01 = int.Parse(ds.Tables[0].Rows[0]["Type01"].ToString());
}
if (ds.Tables[0].Rows[0]["Type02"] != null && ds.Tables[0].Rows[0]["Type02"].ToString() != "")
{
model.Type02 = int.Parse(ds.Tables[0].Rows[0]["Type02"].ToString());
}
if (ds.Tables[0].Rows[0]["Type03"] != null && ds.Tables[0].Rows[0]["Type03"].ToString() != "")
{
model.Type03 = decimal.Parse(ds.Tables[0].Rows[0]["Type03"].ToString());
}
if (ds.Tables[0].Rows[0]["Type04"] != null && ds.Tables[0].Rows[0]["Type04"].ToString() != "")
{
model.Type04 = decimal.Parse(ds.Tables[0].Rows[0]["Type04"].ToString());
}
if (ds.Tables[0].Rows[0]["Type05"] != null && ds.Tables[0].Rows[0]["Type05"].ToString() != "")
{
model.Type05 = ds.Tables[0].Rows[0]["Type05"].ToString();
}
if (ds.Tables[0].Rows[0]["Type06"] != null && ds.Tables[0].Rows[0]["Type06"].ToString() != "")
{
model.Type06 = ds.Tables[0].Rows[0]["Type06"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string name = e.CommandName.ToString();
int id = Convert.ToInt32(e.CommandArgument);
//string[] ids = id.Split(',');
//int cid = int.Parse( ids[0]);
//int pid = int.Parse(ids[1]);
lgk.Model.tb_produceType model = produceTypeBLL.GetModel(id);
if (name == "del")//删除
{
int online = goodsBLL.GetModelList(" Goods001=1 and GoodsType=" + id).Count;
int d = tb_SalesroomBll.GetModelList(" SaTargetPoint=" + id).Count;
if (online > 0)// || tb_SalesroomBll.GetModelList(" SaTargetPoint=" + id).Count > 0)
{
MessageBox.Show(this, "请先下架此类别下的所有商品，再删除！");
return;
}
else
{
if (id <= 77 || id == 78 || id == 79)
{
MessageBox.Show(this, "该类别不能删除！");
return;
}
else
{
if (produceTypeBLL.DeleteForHide(id))
{
MessageBox.Show(this, "删除成功！");
}
}
}
}
if (name == "Update") //修改
{
TextBox txt_des = (TextBox)e.Item.FindControl("txtTypeName"); //二级分类
if (string.IsNullOrEmpty(txt_des.Text))
{
MessageBox.Show(this, "请输入三级分类名");
return;
}
else
{
model.TypeName = txt_des.Text.Trim();
if (produceTypeBLL.Update(model))
{
MessageBox.Show(this, "编辑成功！");
}
}
}
BindData();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_produceType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_produceType set ");
strSql.Append("ParentID=@ParentID,");
strSql.Append("TypeName=@TypeName,");
strSql.Append("Type01=@Type01,");
strSql.Append("Type02=@Type02,");
strSql.Append("Type03=@Type03,");
strSql.Append("Type04=@Type04,");
strSql.Append("Type05=@Type05,");
strSql.Append("Type06=@Type06");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@TypeName", SqlDbType.VarChar, 50),
new SqlParameter("@Type01", SqlDbType.Int, 4),
new SqlParameter("@Type02", SqlDbType.Int, 4),
new SqlParameter("@Type03", SqlDbType.Decimal, 9),
new SqlParameter("@Type04", SqlDbType.Decimal, 9),
new SqlParameter("@Type05", SqlDbType.VarChar, 100),
new SqlParameter("@Type06", SqlDbType.VarChar, 100),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.TypeName;
parameters[2].Value = model.Type01;
parameters[3].Value = model.Type02;
parameters[4].Value = model.Type03;
parameters[5].Value = model.Type04;
parameters[6].Value = model.Type05;
parameters[7].Value = model.Type06;
parameters[8].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_produceType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_produceType(");
strSql.Append("ParentID,TypeName,Type01,Type02,Type03,Type04,Type05,Type06)");
strSql.Append(" values (");
strSql.Append("@ParentID,@TypeName,@Type01,@Type02,@Type03,@Type04,@Type05,@Type06)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@TypeName", SqlDbType.VarChar, 50),
new SqlParameter("@Type01", SqlDbType.Int, 4),
new SqlParameter("@Type02", SqlDbType.Int, 4),
new SqlParameter("@Type03", SqlDbType.Decimal, 9),
new SqlParameter("@Type04", SqlDbType.Decimal, 9),
new SqlParameter("@Type05", SqlDbType.VarChar, 100),
new SqlParameter("@Type06", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.TypeName;
parameters[2].Value = model.Type01;
parameters[3].Value = model.Type02;
parameters[4].Value = model.Type03;
parameters[5].Value = model.Type04;
parameters[6].Value = model.Type05;
parameters[7].Value = model.Type06;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加父栏目
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtPriduceType.Text))
{
MessageBox.Show(this, "请输入一级分类名");
return;
}
else
{
string Name = this.txtPriduceType.Text;
int ParentID = 0;
lgk.Model.tb_produceType model = new lgk.Model.tb_produceType();
model.TypeName = Name;
model.ParentID = ParentID;
if (produceTypeBLL.Add(model) > 0)
{
MessageBox.Show(this, "添加成功！");
BindData();
this.txtPriduceType.Text = "";
}
}
}
/// <summary>
/// 绑定父类别名称
/// </summary>
/// <param name="ParentID"></param>
/// <returns></returns>
public string GetParentName(object ParentID)
{
lgk.Model.tb_produceType model = produceTypeBLL.GetModel(ConvertToInt(ParentID));
return(model.TypeName);
}
