/// <summary>
/// 得到一个对象实体
/// </summary>
public ROYcms.Sys.Model.ROYcms_product GetModel(int bh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from " + PubConstant.date_prefix + "product ");
strSql.Append(" where bh=@bh ");
SqlParameter[] parameters =
{
new SqlParameter("@bh", SqlDbType.Int, 4)
};
parameters[0].Value = bh;
ROYcms.Sys.Model.ROYcms_product model = new ROYcms.Sys.Model.ROYcms_product();
DataSet ds = ROYcms.DB.DbHelpers.GetDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["bh"].ToString() != "")
{
model.bh = int.Parse(ds.Tables[0].Rows[0]["bh"].ToString());
}
model.pic = ds.Tables[0].Rows[0]["pic"].ToString();
model.title = ds.Tables[0].Rows[0]["title"].ToString();
model.keyword = ds.Tables[0].Rows[0]["keyword"].ToString();
model.zhaiyao = ds.Tables[0].Rows[0]["zhaiyao"].ToString();
if (ds.Tables[0].Rows[0]["classname"].ToString() != "")
{
model.classname = int.Parse(ds.Tables[0].Rows[0]["classname"].ToString());
}
model.contents = ds.Tables[0].Rows[0]["contents"].ToString();
model.jumpurl = ds.Tables[0].Rows[0]["jumpurl"].ToString();
model.infor = ds.Tables[0].Rows[0]["infor"].ToString();
model.author = ds.Tables[0].Rows[0]["author"].ToString();
model.url = ds.Tables[0].Rows[0]["url"].ToString();
if (ds.Tables[0].Rows[0]["ding"].ToString() != "")
{
model.ding = int.Parse(ds.Tables[0].Rows[0]["ding"].ToString());
}
if (ds.Tables[0].Rows[0]["dig"].ToString() != "")
{
model.dig = int.Parse(ds.Tables[0].Rows[0]["dig"].ToString());
}
model.tag = ds.Tables[0].Rows[0]["tag"].ToString();
if (ds.Tables[0].Rows[0]["hits"].ToString() != "")
{
model.hits = int.Parse(ds.Tables[0].Rows[0]["hits"].ToString());
}
if (ds.Tables[0].Rows[0]["time"].ToString() != "")
{
model.time = DateTime.Parse(ds.Tables[0].Rows[0]["time"].ToString());
}
if (ds.Tables[0].Rows[0]["orders"].ToString() != "")
{
model.orders = int.Parse(ds.Tables[0].Rows[0]["orders"].ToString());
}
if (ds.Tables[0].Rows[0]["tuijian"].ToString() != "")
{
model.tuijian = int.Parse(ds.Tables[0].Rows[0]["tuijian"].ToString());
}
if (ds.Tables[0].Rows[0]["switchs"].ToString() != "")
{
model.switchs = int.Parse(ds.Tables[0].Rows[0]["switchs"].ToString());
}
if (ds.Tables[0].Rows[0]["link"].ToString() != "")
{
model.link = ds.Tables[0].Rows[0]["link"].ToString();
}
if (ds.Tables[0].Rows[0]["type"].ToString() != "")
{
model.type = ds.Tables[0].Rows[0]["type"].ToString();
}
if (ds.Tables[0].Rows[0]["GUID"].ToString() != "")
{
model.GUID = ds.Tables[0].Rows[0]["GUID"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">The model.</param>
/// <returns></returns>
public int Add(ROYcms.Sys.Model.ROYcms_product model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + PubConstant.date_prefix + "product(");
strSql.Append("pic,title,keyword,zhaiyao,classname,contents,jumpurl,infor,author,url,ding,dig,tag,hits,orders,tuijian,switchs,link,type,GUID)");
strSql.Append(" values (");
strSql.Append("@pic,@title,@keyword,@zhaiyao,@classname,@contents,@jumpurl,@infor,@author,@url,@ding,@dig,@tag,@hits,@orders,@tuijian,@switchs,@link,@type,@GUID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@pic", SqlDbType.VarChar, 500),
new SqlParameter("@title", SqlDbType.VarChar, 100),
new SqlParameter("@keyword", SqlDbType.VarChar, 100),
new SqlParameter("@zhaiyao", SqlDbType.VarChar, 1000),
new SqlParameter("@classname", SqlDbType.Int, 4),
new SqlParameter("@contents", SqlDbType.Text),
new SqlParameter("@jumpurl", SqlDbType.VarChar, 100),
new SqlParameter("@infor", SqlDbType.VarChar, 50),
new SqlParameter("@author", SqlDbType.VarChar, 50),
new SqlParameter("@url", SqlDbType.VarChar, 100),
new SqlParameter("@ding", SqlDbType.Int, 4),
new SqlParameter("@dig", SqlDbType.Int, 4),
new SqlParameter("@tag", SqlDbType.VarChar, 100),
new SqlParameter("@hits", SqlDbType.Int, 4),
new SqlParameter("@orders", SqlDbType.Int, 4),
new SqlParameter("@tuijian", SqlDbType.Int, 4),
new SqlParameter("@switchs", SqlDbType.Int, 4),
new SqlParameter("@link", SqlDbType.VarChar, 50),
new SqlParameter("@type", SqlDbType.VarChar, 50),
new SqlParameter("@GUID", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.pic;
parameters[1].Value = model.title;
parameters[2].Value = model.keyword;
parameters[3].Value = model.zhaiyao;
parameters[4].Value = model.classname;
parameters[5].Value = model.contents;
parameters[6].Value = model.jumpurl;
parameters[7].Value = model.infor;
parameters[8].Value = model.author;
parameters[9].Value = model.url;
parameters[10].Value = model.ding;
parameters[11].Value = model.dig;
parameters[12].Value = model.tag;
parameters[13].Value = model.hits;
parameters[14].Value = model.orders;
parameters[15].Value = model.tuijian;
parameters[16].Value = model.switchs;
parameters[17].Value = model.link;
parameters[18].Value = model.type;
parameters[19].Value = model.GUID;
object obj = ROYcms.DB.DbHelpers.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ROYcms.Sys.Model.ROYcms_product model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + PubConstant.date_prefix + "product set ");
strSql.Append("pic=@pic,");
strSql.Append("title=@title,");
strSql.Append("keyword=@keyword,");
strSql.Append("zhaiyao=@zhaiyao,");
strSql.Append("classname=@classname,");
strSql.Append("contents=@contents,");
strSql.Append("jumpurl=@jumpurl,");
strSql.Append("infor=@infor,");
strSql.Append("author=@author,");
strSql.Append("url=@url,");
strSql.Append("ding=@ding,");
strSql.Append("dig=@dig,");
strSql.Append("tag=@tag,");
strSql.Append("hits=@hits,");
strSql.Append("time=@time,");
strSql.Append("orders=@orders,");
strSql.Append("tuijian=@tuijian,");
strSql.Append("switchs=@switchs,");
strSql.Append("link=@link,");
strSql.Append("type=@type,");
strSql.Append("GUID=@GUID");
strSql.Append(" where bh=@bh ");
SqlParameter[] parameters =
{
new SqlParameter("@bh", SqlDbType.Int, 4),
new SqlParameter("@pic", SqlDbType.VarChar, 500),
new SqlParameter("@title", SqlDbType.VarChar, 100),
new SqlParameter("@keyword", SqlDbType.VarChar, 100),
new SqlParameter("@zhaiyao", SqlDbType.VarChar, 1000),
new SqlParameter("@classname", SqlDbType.Int, 4),
new SqlParameter("@contents", SqlDbType.Text),
new SqlParameter("@jumpurl", SqlDbType.VarChar, 100),
new SqlParameter("@infor", SqlDbType.VarChar, 50),
new SqlParameter("@author", SqlDbType.VarChar, 50),
new SqlParameter("@url", SqlDbType.VarChar, 100),
new SqlParameter("@ding", SqlDbType.Int, 4),
new SqlParameter("@dig", SqlDbType.Int, 4),
new SqlParameter("@tag", SqlDbType.VarChar, 100),
new SqlParameter("@hits", SqlDbType.Int, 4),
new SqlParameter("@time", SqlDbType.DateTime),
new SqlParameter("@orders", SqlDbType.Int, 4),
new SqlParameter("@tuijian", SqlDbType.Int, 4),
new SqlParameter("@switchs", SqlDbType.Int, 4),
new SqlParameter("@link", SqlDbType.VarChar, 50),
new SqlParameter("@type", SqlDbType.VarChar, 50),
new SqlParameter("@GUID", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.bh;
parameters[1].Value = model.pic;
parameters[2].Value = model.title;
parameters[3].Value = model.keyword;
parameters[4].Value = model.zhaiyao;
parameters[5].Value = model.classname;
parameters[6].Value = model.contents;
parameters[7].Value = model.jumpurl;
parameters[8].Value = model.infor;
parameters[9].Value = model.author;
parameters[10].Value = model.url;
parameters[11].Value = model.ding;
parameters[12].Value = model.dig;
parameters[13].Value = model.tag;
parameters[14].Value = model.hits;
parameters[15].Value = model.time;
parameters[16].Value = model.orders;
parameters[17].Value = model.tuijian;
parameters[18].Value = model.switchs;
parameters[19].Value = model.link;
parameters[20].Value = model.type;
parameters[21].Value = model.GUID;
ROYcms.DB.DbHelpers.NonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 获取一条信息 条件 Tops the product.
/// </summary>
/// <returns></returns>
public ROYcms.Sys.Model.ROYcms_product TopProduct(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * ");
strSql.Append(" FROM [" + PubConstant.date_prefix + "product] ");
if (where.Trim() != "")
{
strSql.Append(" where " + where);
}
ROYcms.Sys.Model.ROYcms_product model = new ROYcms.Sys.Model.ROYcms_product();
DataSet ds = ROYcms.DB.DbHelpers.GetDataSet(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["bh"].ToString() != "")
{
model.bh = int.Parse(ds.Tables[0].Rows[0]["bh"].ToString());
}
model.pic = ds.Tables[0].Rows[0]["pic"].ToString();
model.title = ds.Tables[0].Rows[0]["title"].ToString();
model.keyword = ds.Tables[0].Rows[0]["keyword"].ToString();
model.zhaiyao = ds.Tables[0].Rows[0]["zhaiyao"].ToString();
if (ds.Tables[0].Rows[0]["classname"].ToString() != "")
{
model.classname = int.Parse(ds.Tables[0].Rows[0]["classname"].ToString());
}
model.contents = ds.Tables[0].Rows[0]["contents"].ToString();
model.jumpurl = ds.Tables[0].Rows[0]["jumpurl"].ToString();
model.infor = ds.Tables[0].Rows[0]["infor"].ToString();
model.author = ds.Tables[0].Rows[0]["author"].ToString();
model.url = ds.Tables[0].Rows[0]["url"].ToString();
if (ds.Tables[0].Rows[0]["ding"].ToString() != "")
{
model.ding = int.Parse(ds.Tables[0].Rows[0]["ding"].ToString());
}
if (ds.Tables[0].Rows[0]["dig"].ToString() != "")
{
model.dig = int.Parse(ds.Tables[0].Rows[0]["dig"].ToString());
}
model.tag = ds.Tables[0].Rows[0]["tag"].ToString();
if (ds.Tables[0].Rows[0]["hits"].ToString() != "")
{
model.hits = int.Parse(ds.Tables[0].Rows[0]["hits"].ToString());
}
if (ds.Tables[0].Rows[0]["time"].ToString() != "")
{
model.time = DateTime.Parse(ds.Tables[0].Rows[0]["time"].ToString());
}
if (ds.Tables[0].Rows[0]["orders"].ToString() != "")
{
model.orders = int.Parse(ds.Tables[0].Rows[0]["orders"].ToString());
}
if (ds.Tables[0].Rows[0]["tuijian"].ToString() != "")
{
model.tuijian = int.Parse(ds.Tables[0].Rows[0]["tuijian"].ToString());
}
if (ds.Tables[0].Rows[0]["switchs"].ToString() != "")
{
model.switchs = int.Parse(ds.Tables[0].Rows[0]["switchs"].ToString());
}
if (ds.Tables[0].Rows[0]["link"].ToString() != "")
{
model.link = ds.Tables[0].Rows[0]["link"].ToString();
}
if (ds.Tables[0].Rows[0]["type"].ToString() != "")
{
model.type = ds.Tables[0].Rows[0]["type"].ToString();
}
if (ds.Tables[0].Rows[0]["GUID"].ToString() != "")
{
model.GUID = ds.Tables[0].Rows[0]["GUID"].ToString();
}
return(model);
}
else
{
return(null);
}
}
