/// <summary>
/// 获得数据列表
/// </summary>
public List <Model.article_goods_spec> GetList(int channel_id, int article_id, string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * FROM " + databaseprefix + "article_goods_spec");
strSql.Append(" where channel_id=" + channel_id + " and article_id=" + article_id);
if (strWhere.Trim() != "")
{
strSql.Append(" and " + strWhere);
}
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
List <Model.article_goods_spec> modelList = new List <Model.article_goods_spec>();
if (dt.Rows.Count > 0)
{
for (int n = 0; n < dt.Rows.Count; n++)
{
Model.article_goods_spec model = new Model.article_goods_spec();
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < dt.Rows[n].Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(dt.Rows[n].Table.Columns[i].ColumnName);
if (proInfo != null && dt.Rows[n][i] != DBNull.Value)
{
proInfo.SetValue(model, dt.Rows[n][i], null);//用索引值设置属性值
}
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 得到一个商品规格列表
/// </summary>
public List <Model.article_goods_spec> GetSpecList(int article_id, int parent_id)
{
List <Model.article_goods_spec> modelList = new List <Model.article_goods_spec>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select article_id,spec_id,parent_id,title,img_url");
strSql.Append(" FROM " + databaseprefix + "article_goods_spec");
strSql.Append(" where article_id=" + article_id + " and parent_id=" + parent_id);
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.article_goods_spec model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.article_goods_spec();
if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "")
{
model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString());
}
if (dt.Rows[n]["spec_id"] != null && dt.Rows[n]["spec_id"].ToString() != "")
{
model.spec_id = int.Parse(dt.Rows[n]["spec_id"].ToString());
}
if (dt.Rows[n]["parent_id"] != null && dt.Rows[n]["parent_id"].ToString() != "")
{
model.parent_id = int.Parse(dt.Rows[n]["parent_id"].ToString());
}
if (dt.Rows[n]["title"] != null)
{
model.title = dt.Rows[n]["title"].ToString();
}
if (dt.Rows[n]["img_url"] != null)
{
model.img_url = dt.Rows[n]["img_url"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Model.article_goods_spec> GetList(int article_id, string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select article_id,spec_id,parent_id,title,img_url");
strSql.Append(" FROM " + databaseprefix + "article_goods_spec ");
strSql.Append(" where article_id=" + article_id);
if (strWhere.Trim() != "")
{
strSql.Append(" and " + strWhere);
}
DataTable dt = DbHelperOleDb.Query(strSql.ToString()).Tables[0];
List <Model.article_goods_spec> modelList = new List <Model.article_goods_spec>();
if (dt.Rows.Count > 0)
{
for (int n = 0; n < dt.Rows.Count; n++)
{
Model.article_goods_spec model = new Model.article_goods_spec();
if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "")
{
model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString());
}
if (dt.Rows[n]["spec_id"] != null && dt.Rows[n]["spec_id"].ToString() != "")
{
model.spec_id = int.Parse(dt.Rows[n]["spec_id"].ToString());
}
if (dt.Rows[n]["parent_id"] != null && dt.Rows[n]["parent_id"].ToString() != "")
{
model.parent_id = int.Parse(dt.Rows[n]["parent_id"].ToString());
}
if (dt.Rows[n]["title"] != null && dt.Rows[n]["title"].ToString() != "")
{
model.title = dt.Rows[n]["title"].ToString();
}
if (dt.Rows[n]["img_url"] != null && dt.Rows[n]["img_url"].ToString() != "")
{
model.img_url = dt.Rows[n]["img_url"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据，带事务
/// </summary>
public int Add(SqlConnection conn, SqlTransaction trans, Model.article_goods_spec model, int channel_id, int article_id)
{
StringBuilder strSql = new StringBuilder();
StringBuilder str1 = new StringBuilder(); //数据字段
StringBuilder str2 = new StringBuilder(); //数据参数
//利用反射获得属性的所有公共属性
PropertyInfo[] pros = model.GetType().GetProperties();
List <SqlParameter> paras = new List <SqlParameter>();
strSql.Append("insert into " + databaseprefix + "article_goods_spec(");
foreach (PropertyInfo pi in pros)
{
//判断属性值是否为空
if (pi.GetValue(model, null) != null)
{
str1.Append(pi.Name + ","); //拼接字段
str2.Append("@" + pi.Name + ","); //声明参数
switch (pi.Name)
{
case "channel_id":
paras.Add(new SqlParameter("@" + pi.Name, channel_id));
break;
case "article_id":
paras.Add(new SqlParameter("@" + pi.Name, article_id));
break;
default:
paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值
break;
}
}
}
strSql.Append(str1.ToString().Trim(','));
strSql.Append(") values (");
strSql.Append(str2.ToString().Trim(','));
strSql.Append(") ");
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), paras.ToArray());
return(Convert.ToInt32(obj));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Model.article_goods_spec> GetList(int article_id, string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select article_id,spec_id,parent_id,title,img_url");
strSql.Append(" FROM " + databaseprefix + "article_goods_spec ");
strSql.Append(" where article_id=" + article_id);
if (strWhere.Trim() != "")
{
strSql.Append(" and " + strWhere);
}
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
List<Model.article_goods_spec> modelList = new List<Model.article_goods_spec>();
if (dt.Rows.Count > 0)
{
for (int n = 0; n < dt.Rows.Count; n++)
{
Model.article_goods_spec model = new Model.article_goods_spec();
if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "")
{
model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString());
}
if (dt.Rows[n]["spec_id"] != null && dt.Rows[n]["spec_id"].ToString() != "")
{
model.spec_id = int.Parse(dt.Rows[n]["spec_id"].ToString());
}
if (dt.Rows[n]["parent_id"] != null && dt.Rows[n]["parent_id"].ToString() != "")
{
model.parent_id = int.Parse(dt.Rows[n]["parent_id"].ToString());
}
if (dt.Rows[n]["title"] != null && dt.Rows[n]["title"].ToString() != "")
{
model.title = dt.Rows[n]["title"].ToString();
}
if (dt.Rows[n]["img_url"] != null && dt.Rows[n]["img_url"].ToString() != "")
{
model.img_url = dt.Rows[n]["img_url"].ToString();
}
modelList.Add(model);
}
}
return modelList;
}
