/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="service"></param>
/// <returns></returns>
public bool Add(ServiceInfo service)
{
StringBuilder sql = new StringBuilder();
sql.Append("inser into BigDog_Service (Service_Name,Father_Id,Description,Service_Url)");
sql.Append("values(@Service_Name,@Description,@Service_Url)");
SqlParameter[] parms = new SqlParameter[]{
new SqlParameter("@Service_Name",SqlDbType.NVarChar,50),
new SqlParameter("@Description",SqlDbType.Int),
new SqlParameter("@Service_Url",SqlDbType.NVarChar,200)
};
parms[0].Value = service.Service_Name;
parms[1].Value = service.Father_Id;
parms[2].Value = service.Description;
parms[3].Value = service.Service_Url;
return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
/// <summary>
/// 根据Id获取实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ServiceInfo GetById(int id)
{
StringBuilder sql = new StringBuilder();
sql.Append("select Id,Service_Name,Father_Id,Description,Service_Url from BigDog_Service where Id=@Id");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Id",SqlDbType.Int)
};
parms[0].Value = id;
ServiceInfo service = new ServiceInfo();
DataTable dt = SQLHelper.GetDs(sql.ToString(),parms).Tables[0];
if (dt.Rows.Count > 0)
{
service.Id = Convert.ToInt32( dt.Rows[0]["Id"]);
service.Service_Name = dt.Rows[0]["Service_Name"].ToString();
service.Service_Url = dt.Rows[0]["Service_Url"].ToString();
return service;
}
return null;
}
public static bool Update(ServiceInfo service)
{
return Dal.Update(service);
}
public static bool Add(ServiceInfo service)
{
return Dal.Add(service);
}
/// <summary>
/// 获取数据集
/// </summary>
/// <returns></returns>
public DataTable GetServiceList()
{
StringBuilder sql = new StringBuilder();
sql.Append("select Id,Service_Name,Father_Id,Description,Service_Url from BigDog_Service");
ServiceInfo service = new ServiceInfo();
DataTable dt = SQLHelper.GetDs(sql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
return dt;
}
return null;
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="service"></param>
/// <returns></returns>
public bool Update(ServiceInfo service)
{
StringBuilder sql = new StringBuilder();
sql.Append("update BigDog_Shop set Service_Name=@Service_Name,Description=@Description,Service_Url=@Service_Url where Id=@Id");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@Service_Name",SqlDbType.NVarChar,50),
new SqlParameter("@Description",SqlDbType.NVarChar,100),
new SqlParameter("@Service_Url",SqlDbType.NVarChar,200),
new SqlParameter("@Id",SqlDbType.Int)
};
parms[0].Value = service.Service_Name;
parms[1].Value = service.Description;
parms[2].Value = service.Service_Url;
parms[3].Value = service.Id;
return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
}
/// <summary>
/// 获取子数据集
/// </summary>
/// <returns></returns>
public DataTable GetServiceList(int father_id)
{
StringBuilder sql = new StringBuilder();
sql.Append("select Id,Service_Name,Father_Id,Description,Service_Url from BigDog_Service where Father_Id='"+father_id+"'");
//SqlParameter[] parms = new SqlParameter[] {
// new SqlParameter("@Father_Id",SqlDbType.Int)
//};
//parms[0].Value = father_id;
ServiceInfo service = new ServiceInfo();
DataTable dt = SQLHelper.GetDs(sql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
return dt;
}
return null;
}