/// <summary>
/// 得到一个附件对象实体
/// </summary>
public Model.download_attach GetAttachModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,down_id,title,file_path,file_ext,file_size,down_num from dt_download_attach ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
DTcms.Model.download_attach model = new DTcms.Model.download_attach();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["down_id"].ToString() != "")
{
model.down_id = int.Parse(ds.Tables[0].Rows[0]["down_id"].ToString());
}
model.title = ds.Tables[0].Rows[0]["title"].ToString();
model.file_path = ds.Tables[0].Rows[0]["file_path"].ToString();
model.file_ext = ds.Tables[0].Rows[0]["file_ext"].ToString();
if (ds.Tables[0].Rows[0]["file_size"].ToString() != "")
{
model.file_size = int.Parse(ds.Tables[0].Rows[0]["file_size"].ToString());
}
if (ds.Tables[0].Rows[0]["down_num"].ToString() != "")
{
model.down_num = int.Parse(ds.Tables[0].Rows[0]["down_num"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public DTcms.Model.download GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,channel_id,title,category_id,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,digg_good,digg_act,is_msg,is_red,is_lock,add_time from dt_download ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
Model.download model = new Model.download();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region ������Ϣ
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]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString());
}
if (ds.Tables[0].Rows[0]["click"] != null && ds.Tables[0].Rows[0]["click"].ToString() != "")
{
model.click = int.Parse(ds.Tables[0].Rows[0]["click"].ToString());
}
if (ds.Tables[0].Rows[0]["digg_good"] != null && ds.Tables[0].Rows[0]["digg_good"].ToString() != "")
{
model.digg_good = int.Parse(ds.Tables[0].Rows[0]["digg_good"].ToString());
}
if (ds.Tables[0].Rows[0]["digg_act"] != null && ds.Tables[0].Rows[0]["digg_act"].ToString() != "")
{
model.digg_act = int.Parse(ds.Tables[0].Rows[0]["digg_act"].ToString());
}
if (ds.Tables[0].Rows[0]["is_msg"] != null && ds.Tables[0].Rows[0]["is_msg"].ToString() != "")
{
model.is_msg = int.Parse(ds.Tables[0].Rows[0]["is_msg"].ToString());
}
if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "")
{
model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString());
}
if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "")
{
model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString());
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
if (ds.Tables[0].Rows[0]["channel_id"] != null && ds.Tables[0].Rows[0]["channel_id"].ToString() != "")
{
model.channel_id = int.Parse(ds.Tables[0].Rows[0]["channel_id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["category_id"] != null && ds.Tables[0].Rows[0]["category_id"].ToString() != "")
{
model.category_id = int.Parse(ds.Tables[0].Rows[0]["category_id"].ToString());
}
if (ds.Tables[0].Rows[0]["link_url"] != null && ds.Tables[0].Rows[0]["link_url"].ToString() != "")
{
model.link_url = ds.Tables[0].Rows[0]["link_url"].ToString();
}
if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "")
{
model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString();
}
if (ds.Tables[0].Rows[0]["seo_title"] != null && ds.Tables[0].Rows[0]["seo_title"].ToString() != "")
{
model.seo_title = ds.Tables[0].Rows[0]["seo_title"].ToString();
}
if (ds.Tables[0].Rows[0]["seo_keywords"] != null && ds.Tables[0].Rows[0]["seo_keywords"].ToString() != "")
{
model.seo_keywords = ds.Tables[0].Rows[0]["seo_keywords"].ToString();
}
if (ds.Tables[0].Rows[0]["seo_description"] != null && ds.Tables[0].Rows[0]["seo_description"].ToString() != "")
{
model.seo_description = ds.Tables[0].Rows[0]["seo_description"].ToString();
}
if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "")
{
model.content = ds.Tables[0].Rows[0]["content"].ToString();
}
#endregion ������Ϣend
#region �ӱ���Ϣ
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select id,down_id,title,file_path,file_ext,file_size,down_num from dt_download_attach ");
strSql2.Append(" where down_id=@down_id ");
SqlParameter[] parameters2 = {
new SqlParameter("@down_id", SqlDbType.Int,4)};
parameters2[0].Value = id;
DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2);
if (ds2.Tables[0].Rows.Count > 0)
{
#region �ӱ��ֶ���Ϣ
int i = ds2.Tables[0].Rows.Count;
List<DTcms.Model.download_attach> models = new List<DTcms.Model.download_attach>();
DTcms.Model.download_attach modelt;
for (int n = 0; n < i; n++)
{
modelt = new DTcms.Model.download_attach();
if (ds2.Tables[0].Rows[n]["id"] != null && ds2.Tables[0].Rows[n]["id"].ToString() != "")
{
modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString());
}
if (ds2.Tables[0].Rows[n]["down_id"] != null && ds2.Tables[0].Rows[n]["down_id"].ToString() != "")
{
modelt.down_id = int.Parse(ds2.Tables[0].Rows[n]["down_id"].ToString());
}
if (ds2.Tables[0].Rows[n]["title"] != null && ds2.Tables[0].Rows[n]["title"].ToString() != "")
{
modelt.title = ds2.Tables[0].Rows[n]["title"].ToString();
}
if (ds2.Tables[0].Rows[n]["file_path"] != null && ds2.Tables[0].Rows[n]["file_path"].ToString() != "")
{
modelt.file_path = ds2.Tables[0].Rows[n]["file_path"].ToString();
}
if (ds2.Tables[0].Rows[n]["file_ext"] != null && ds2.Tables[0].Rows[n]["file_ext"].ToString() != "")
{
modelt.file_ext = ds2.Tables[0].Rows[n]["file_ext"].ToString();
}
if (ds2.Tables[0].Rows[n]["file_size"] != null && ds2.Tables[0].Rows[n]["file_size"].ToString() != "")
{
modelt.file_size = int.Parse(ds2.Tables[0].Rows[n]["file_size"].ToString());
}
if (ds2.Tables[0].Rows[n]["down_num"] != null && ds2.Tables[0].Rows[n]["down_num"].ToString() != "")
{
modelt.down_num = int.Parse(ds2.Tables[0].Rows[n]["down_num"].ToString());
}
models.Add(modelt);
}
model.download_attachs = models;
#endregion �ӱ��ֶ���Ϣend
}
#endregion �ӱ���Ϣend
return model;
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.download GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,channel_id,title,category_id,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,digg_good,digg_act,is_msg,is_red,is_lock,add_time from dt_download ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.download model = new Model.download();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region 父表信息
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]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString());
}
if (ds.Tables[0].Rows[0]["click"] != null && ds.Tables[0].Rows[0]["click"].ToString() != "")
{
model.click = int.Parse(ds.Tables[0].Rows[0]["click"].ToString());
}
if (ds.Tables[0].Rows[0]["digg_good"] != null && ds.Tables[0].Rows[0]["digg_good"].ToString() != "")
{
model.digg_good = int.Parse(ds.Tables[0].Rows[0]["digg_good"].ToString());
}
if (ds.Tables[0].Rows[0]["digg_act"] != null && ds.Tables[0].Rows[0]["digg_act"].ToString() != "")
{
model.digg_act = int.Parse(ds.Tables[0].Rows[0]["digg_act"].ToString());
}
if (ds.Tables[0].Rows[0]["is_msg"] != null && ds.Tables[0].Rows[0]["is_msg"].ToString() != "")
{
model.is_msg = int.Parse(ds.Tables[0].Rows[0]["is_msg"].ToString());
}
if (ds.Tables[0].Rows[0]["is_red"] != null && ds.Tables[0].Rows[0]["is_red"].ToString() != "")
{
model.is_red = int.Parse(ds.Tables[0].Rows[0]["is_red"].ToString());
}
if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "")
{
model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString());
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
if (ds.Tables[0].Rows[0]["channel_id"] != null && ds.Tables[0].Rows[0]["channel_id"].ToString() != "")
{
model.channel_id = int.Parse(ds.Tables[0].Rows[0]["channel_id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["category_id"] != null && ds.Tables[0].Rows[0]["category_id"].ToString() != "")
{
model.category_id = int.Parse(ds.Tables[0].Rows[0]["category_id"].ToString());
}
if (ds.Tables[0].Rows[0]["link_url"] != null && ds.Tables[0].Rows[0]["link_url"].ToString() != "")
{
model.link_url = ds.Tables[0].Rows[0]["link_url"].ToString();
}
if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "")
{
model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString();
}
if (ds.Tables[0].Rows[0]["seo_title"] != null && ds.Tables[0].Rows[0]["seo_title"].ToString() != "")
{
model.seo_title = ds.Tables[0].Rows[0]["seo_title"].ToString();
}
if (ds.Tables[0].Rows[0]["seo_keywords"] != null && ds.Tables[0].Rows[0]["seo_keywords"].ToString() != "")
{
model.seo_keywords = ds.Tables[0].Rows[0]["seo_keywords"].ToString();
}
if (ds.Tables[0].Rows[0]["seo_description"] != null && ds.Tables[0].Rows[0]["seo_description"].ToString() != "")
{
model.seo_description = ds.Tables[0].Rows[0]["seo_description"].ToString();
}
if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "")
{
model.content = ds.Tables[0].Rows[0]["content"].ToString();
}
#endregion 父表信息end
#region 子表信息
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select id,down_id,title,file_path,file_ext,file_size,down_num from dt_download_attach ");
strSql2.Append(" where down_id=@down_id ");
SqlParameter[] parameters2 =
{
new SqlParameter("@down_id", SqlDbType.Int, 4)
};
parameters2[0].Value = id;
DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2);
if (ds2.Tables[0].Rows.Count > 0)
{
#region 子表字段信息
int i = ds2.Tables[0].Rows.Count;
List <DTcms.Model.download_attach> models = new List <DTcms.Model.download_attach>();
DTcms.Model.download_attach modelt;
for (int n = 0; n < i; n++)
{
modelt = new DTcms.Model.download_attach();
if (ds2.Tables[0].Rows[n]["id"] != null && ds2.Tables[0].Rows[n]["id"].ToString() != "")
{
modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString());
}
if (ds2.Tables[0].Rows[n]["down_id"] != null && ds2.Tables[0].Rows[n]["down_id"].ToString() != "")
{
modelt.down_id = int.Parse(ds2.Tables[0].Rows[n]["down_id"].ToString());
}
if (ds2.Tables[0].Rows[n]["title"] != null && ds2.Tables[0].Rows[n]["title"].ToString() != "")
{
modelt.title = ds2.Tables[0].Rows[n]["title"].ToString();
}
if (ds2.Tables[0].Rows[n]["file_path"] != null && ds2.Tables[0].Rows[n]["file_path"].ToString() != "")
{
modelt.file_path = ds2.Tables[0].Rows[n]["file_path"].ToString();
}
if (ds2.Tables[0].Rows[n]["file_ext"] != null && ds2.Tables[0].Rows[n]["file_ext"].ToString() != "")
{
modelt.file_ext = ds2.Tables[0].Rows[n]["file_ext"].ToString();
}
if (ds2.Tables[0].Rows[n]["file_size"] != null && ds2.Tables[0].Rows[n]["file_size"].ToString() != "")
{
modelt.file_size = int.Parse(ds2.Tables[0].Rows[n]["file_size"].ToString());
}
if (ds2.Tables[0].Rows[n]["down_num"] != null && ds2.Tables[0].Rows[n]["down_num"].ToString() != "")
{
modelt.down_num = int.Parse(ds2.Tables[0].Rows[n]["down_num"].ToString());
}
models.Add(modelt);
}
model.download_attachs = models;
#endregion 子表字段信息end
}
#endregion 子表信息end
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// �õ�һ����������ʵ��
/// </summary>
public Model.download_attach GetAttachModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,down_id,title,file_path,file_ext,file_size,down_num from dt_download_attach ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
DTcms.Model.download_attach model = new DTcms.Model.download_attach();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["down_id"].ToString() != "")
{
model.down_id = int.Parse(ds.Tables[0].Rows[0]["down_id"].ToString());
}
model.title = ds.Tables[0].Rows[0]["title"].ToString();
model.file_path = ds.Tables[0].Rows[0]["file_path"].ToString();
model.file_ext = ds.Tables[0].Rows[0]["file_ext"].ToString();
if (ds.Tables[0].Rows[0]["file_size"].ToString() != "")
{
model.file_size = int.Parse(ds.Tables[0].Rows[0]["file_size"].ToString());
}
if (ds.Tables[0].Rows[0]["down_num"].ToString() != "")
{
model.down_num = int.Parse(ds.Tables[0].Rows[0]["down_num"].ToString());
}
return model;
}
else
{
return null;
}
}
