/// <summary>
/// 表:BSCategory (添加数据
/// </summary>
/// <param name="bSCategory">添加的数据</param>
/// <returns>执行成功的行数</returns>
public static int Insert(BSCategory bSCategory)
{
return(DBHelp.ExecuteNonQuery(
"insert into BSCategory values(@BLID,@BLName)",
new SqlParameter[] {
new SqlParameter("@BLID", bSCategory.BLID),
new SqlParameter("@BLName", bSCategory.BLName),
}));
}
/// <summary>
/// 表:BSCategory (修改数据
/// </summary>
/// <param name="bSCategory">修改的数据</param>
/// <returns>执行成功的行数</returns>
public static int Update(BSCategory bSCategory)
{
return(DBHelp.ExecuteNonQuery(
"update BSCategory set BLName=@BLName,BLID=@BLID where BSID=@BSID",
new SqlParameter[] {
new SqlParameter("@BLName", bSCategory.BLName),
new SqlParameter("@BSID", bSCategory.BSID),
new SqlParameter("@BLID", bSCategory.BLID)
}));
}
public static List <BSCategory> SelectBSIDAll(int BSID)
{
string sql = string.Format("SELECT BSID,BLID,BLName FROM BSCategory where BLID='{0}' ", BSID);
SqlDataReader dr = DBHelper.MyExecuteReader(sql);
List <BSCategory> list = new List <BSCategory>();
while (dr.Read())
{
BSCategory bs = new BSCategory();
bs.BSID = Convert.ToInt32(dr["BSID"]);
bs.BLID = Convert.ToInt32(dr["BLID"]);
bs.BLName = dr["BLName"].ToString();
list.Add(bs);
}
dr.Close();
return(list);
}
/// <summary>
/// 查询大，小类节点
/// </summary>
/// <returns></returns>
public static List <BSCategory> getBSCategoryList()
{
List <BSCategory> list = new List <BSCategory>();
String sql = string.Format("select * from dbo.BLCategory l inner join dbo.BSCategory s on l.BLID=s.BLID");
using (SqlDataReader sdr = DBHelp.MyExecuteReader(sql, null))
{
while (sdr.Read())
{
BSCategory bs = new BSCategory();
bs.BLID = Convert.ToInt32(sdr["BLID"]);
bs.BSID = Convert.ToInt32(sdr["BSID"]);
bs.BLName = sdr["BLName"].ToString();
bs.BSName = sdr[4].ToString();
list.Add(bs);
}
}
return(list);
}
/// <summary>
/// 查询小类节点
/// </summary>
/// <returns></returns>
public static List <BSCategory> getBSCategoryList(int BLID)
{
List <BSCategory> list = new List <BSCategory>();
String sql = string.Format("select * from BSCategory where BLID=@BLID");
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@BLID", BLID)
};
using (SqlDataReader sdr = DBHelp.MyExecuteReader(sql, sp))
{
while (sdr.Read())
{
BSCategory bs = new BSCategory();
bs.BLID = Convert.ToInt32(sdr["BLID"]);
bs.BSID = Convert.ToInt32(sdr["BSID"]);
bs.BSName = sdr["BSName"].ToString();
list.Add(bs);
}
}
return(list);
}
/// <summary>
/// 表:BSCategory (添加数据
/// </summary>
/// <param name="bSCategory">添加的数据</param>
/// <returns>执行成功的行数</returns>
public static int Insert(BSCategory bSCategory)
{
return(Dal_BSCategory.Insert(bSCategory));
}
/// <summary>
/// 表:BSCategory (修改数据
/// </summary>
/// <param name="bSCategory">修改的数据</param>
/// <returns>执行成功的行数</returns>
public static int Update(BSCategory bSCategory)
{
return(Dal_BSCategory.Update(bSCategory));
}
