< 返回新闻公共列表
修正了添加频道约束错误
发布时间:2019-11-19 17:11:44
修正了添加频道约束错误
原因是表改名。
修正方法:DAL\channel.cs
- StringBuilder strSql = new StringBuilder();
- strSql.Append("insert into " + databaseprefix + "channel(");
- strSql.Append("category_id,site_id,name,title,is_albums,is_attach,is_group_price,page_size,sort_id)");
- strSql.Append(" values (");
- strSql.Append("@category_id,@site_id,@name,@title,@is_albums,@is_attach,@is_group_price,@page_size,@sort_id)");
- strSql.Append(";select @@IDENTITY");
- SqlParameter[] parameters = {
- new SqlParameter("@category_id", SqlDbType.Int,4),
- new SqlParameter("@site_id", SqlDbType.Int,4),
- new SqlParameter("@name", SqlDbType.VarChar,50),
- new SqlParameter("@title", SqlDbType.VarChar,100),
- new SqlParameter("@is_albums", SqlDbType.TinyInt,1),
- new SqlParameter("@is_attach", SqlDbType.TinyInt,1),
- new SqlParameter("@is_group_price", SqlDbType.TinyInt,1),
- new SqlParameter("@page_size", SqlDbType.Int,4),
- new SqlParameter("@sort_id", SqlDbType.Int,4),
- new SqlParameter("@ReturnValue",SqlDbType.Int)};
- parameters[0].Value = model.category_id;
- parameters[1].Value = model.category_id;
- parameters[2].Value = model.name;
- parameters[3].Value = model.title;
- parameters[4].Value = model.is_albums;
- parameters[5].Value = model.is_attach;
- parameters[6].Value = model.is_group_price;
- parameters[7].Value = model.page_size;
- parameters[8].Value = model.sort_id;
-
- string aa = strSql.ToString();//
- object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务
- model.id = Convert.ToInt32(obj);