/// <summary> /// ����һ������ /// </summary> public int Add(Model.article_attribute_field model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "article_attribute_field("); strSql.Append("name,title,control_type,data_type,data_length,data_place,item_option,default_value,is_required,is_password,is_html,editor_type,valid_tip_msg,valid_error_msg,valid_pattern,sort_id,is_sys)"); strSql.Append(" values ("); strSql.Append("@name,@title,@control_type,@data_type,@data_length,@data_place,@item_option,@default_value,@is_required,@is_password,@is_html,@editor_type,@valid_tip_msg,@valid_error_msg,@valid_pattern,@sort_id,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar,100), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@control_type", SqlDbType.NVarChar,50), new SqlParameter("@data_type", SqlDbType.NVarChar,50), new SqlParameter("@data_length", SqlDbType.Int,4), new SqlParameter("@data_place", SqlDbType.TinyInt,1), new SqlParameter("@item_option", SqlDbType.NText), new SqlParameter("@default_value", SqlDbType.NText), new SqlParameter("@is_required", SqlDbType.TinyInt,1), new SqlParameter("@is_password", SqlDbType.TinyInt,1), new SqlParameter("@is_html", SqlDbType.TinyInt,1), new SqlParameter("@editor_type", SqlDbType.TinyInt,1), new SqlParameter("@valid_tip_msg", SqlDbType.NVarChar,255), new SqlParameter("@valid_error_msg", SqlDbType.NVarChar,255), new SqlParameter("@valid_pattern", SqlDbType.NVarChar,500), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@is_sys", SqlDbType.TinyInt,1), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.name; parameters[1].Value = model.title; parameters[2].Value = model.control_type; parameters[3].Value = model.data_type; parameters[4].Value = model.data_length; parameters[5].Value = model.data_place; parameters[6].Value = model.item_option; parameters[7].Value = model.default_value; parameters[8].Value = model.is_required; parameters[9].Value = model.is_password; parameters[10].Value = model.is_html; parameters[11].Value = model.editor_type; parameters[12].Value = model.valid_tip_msg; parameters[13].Value = model.valid_error_msg; parameters[14].Value = model.valid_pattern; parameters[15].Value = model.sort_id; parameters[16].Value = model.is_sys; parameters[17].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //������չ�ֶα���һ�� StringBuilder strSql2 = new StringBuilder(); strSql2.Append("alter table " + databaseprefix + "article_attribute_value add " + model.name + " " + model.data_type); SqlParameter[] parameters2 = { }; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[17].Value; }
/// <summary> /// ɾ��һ������ /// </summary> public bool Delete(int id) { List<CommandInfo> sqllist = new List<CommandInfo>(); StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_photo_attribute_value "); strSql.Append(" where attribute_id=@attribute_id"); SqlParameter[] parameters = { new SqlParameter("@attribute_id", SqlDbType.Int,4)}; parameters[0].Value = id; CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_photo_attribute "); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public int Add(Model.sys_model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_sys_model("); strSql.Append("title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys)"); strSql.Append(" values ("); strSql.Append("@title,@sort_id,@inherit_index,@inherit_list,@inherit_detail,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@inherit_index", SqlDbType.NVarChar,255), new SqlParameter("@inherit_list", SqlDbType.NVarChar,255), new SqlParameter("@inherit_detail", SqlDbType.NVarChar,255), new SqlParameter("@is_sys", SqlDbType.TinyInt,1), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.title; parameters[1].Value = model.sort_id; parameters[2].Value = model.inherit_index; parameters[3].Value = model.inherit_list; parameters[4].Value = model.inherit_detail; parameters[5].Value = model.is_sys; parameters[6].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //模型菜单 if (model.sys_model_navs != null) { StringBuilder strSql2; foreach (Model.sys_model_nav models in model.sys_model_navs) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_sys_model_nav("); strSql2.Append("model_id,title,nav_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@model_id,@title,@nav_url,@sort_id)"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@nav_url", SqlDbType.NVarChar,255), new SqlParameter("@sort_id", SqlDbType.Int,4)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[6].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_amount_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_amount_log("); strSql.Append("user_id,user_name,type,order_no,trade_no,payment_id,value,remark,status,add_time,complete_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@type,@order_no,@trade_no,@payment_id,@value,@remark,@status,@add_time,@complete_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@type", SqlDbType.NVarChar,50), new SqlParameter("@order_no", SqlDbType.NVarChar,100), new SqlParameter("@trade_no", SqlDbType.NVarChar,100), new SqlParameter("@payment_id", SqlDbType.Int,4), new SqlParameter("@value", SqlDbType.Decimal,5), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@status", SqlDbType.TinyInt,1), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@complete_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.type; parameters[3].Value = model.order_no; parameters[4].Value = model.trade_no; parameters[5].Value = model.payment_id; parameters[6].Value = model.value; parameters[7].Value = model.remark; parameters[8].Value = model.status; parameters[9].Value = model.add_time; parameters[10].Value = model.complete_time; parameters[11].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); if (model.status > 0) { StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.value); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = model.user_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[11].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.property model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into td_property("); strSql.Append("category_id,title,add_time"); strSql.Append(") values ("); strSql.Append("@category_id,@title,@add_time"); strSql.Append(") "); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@category_id", SqlDbType.Int,4) , new SqlParameter("@title", SqlDbType.NVarChar,100) , new SqlParameter("@add_time", SqlDbType.DateTime) , new SqlParameter("@ReturnValue",SqlDbType.Int) }; parameters[0].Value = model.category_id; parameters[1].Value = model.title; parameters[2].Value = model.add_time; parameters[3].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql1; if (model.property_values != null && model.property_values.Count > 0) { foreach (Model.property_value model_value in model.property_values) { strSql1 = new StringBuilder(); strSql1.Append("insert into td_property_value(property_id,value,add_time) values"); strSql1.Append("(@property_id,@value,@add_time)"); SqlParameter[] parameters1 = { new SqlParameter("@property_id",SqlDbType.Int,4), new SqlParameter("@value",SqlDbType.NVarChar,100), new SqlParameter("@add_time",SqlDbType.DateTime) }; parameters1[0].Direction = ParameterDirection.InputOutput; parameters1[1].Value = model_value.value; parameters1[2].Value = model_value.add_time; cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[3].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.article_spec model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into " + databaseprefix + "article_spec("); strSql.Append("parent_id,title,remark,sort_id)"); strSql.Append(" values ("); strSql.Append("@parent_id,@title,@remark,@sort_id)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@parent_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@remark", SqlDbType.NVarChar,255), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.parent_id; parameters[1].Value = model.title; parameters[2].Value = model.remark; parameters[3].Value = model.sort_id; parameters[4].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //规格值列表 if (model.values != null) { StringBuilder strSql2; foreach (Model.article_spec_value modelt in model.values) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "article_spec("); strSql2.Append("parent_id,title,img_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@parent_id,@title,@img_url,@sort_id)"); SqlParameter[] parameters2 = { new SqlParameter("@parent_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@img_url", SqlDbType.NVarChar,255), new SqlParameter("@sort_id", SqlDbType.Int,4)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = modelt.title; parameters2[2].Value = modelt.img_url; parameters2[3].Value = modelt.sort_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[4].Value; }
/// <summary> /// ����һ������ /// </summary> public int Add(Model.manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "manager_role("); strSql.Append("role_name,role_type,is_sys)"); strSql.Append(" values ("); strSql.Append("@role_name,@role_type,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@role_name", SqlDbType.NVarChar,100), new SqlParameter("@role_type", SqlDbType.TinyInt,1), new SqlParameter("@is_sys", SqlDbType.TinyInt,1), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Value = model.is_sys; parameters[3].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2; if (model.manager_role_values != null) { foreach (Model.manager_role_value modelt in model.manager_role_values) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "manager_role_value("); strSql2.Append("role_id,nav_name,action_type)"); strSql2.Append(" values ("); strSql2.Append("@role_id,@nav_name,@action_type)"); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int,4), new SqlParameter("@nav_name", SqlDbType.NVarChar,100), new SqlParameter("@action_type", SqlDbType.NVarChar,50)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = modelt.nav_name; parameters2[2].Value = modelt.action_type; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[3].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_point_log model, bool is_upgrade) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_point_log("); strSql.Append("user_id,user_name,value,remark,add_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@value,@remark,@add_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@value", SqlDbType.Int,4), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.value; parameters[3].Value = model.remark; parameters[4].Value = model.add_time; parameters[5].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set point=point+" + model.value); if (model.value > 0 && is_upgrade) { strSql2.Append(",exp=exp+" + model.value); } strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = model.user_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[5].Value; }
/// <summary> /// ����һ������,�����ӱ����� /// </summary> public int Add(Model.manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_manager_role("); strSql.Append("role_name,role_type)"); strSql.Append(" values ("); strSql.Append("@role_name,@role_type)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@role_name", SqlDbType.NVarChar,100), new SqlParameter("@role_type", SqlDbType.TinyInt,1), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2; foreach (Model.manager_role_value models in model.manager_role_values) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_manager_role_value("); strSql2.Append("role_id,channel_name,channel_id,action_type)"); strSql2.Append(" values ("); strSql2.Append("@role_id,@channel_name,@channel_id,@action_type)"); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int,4), new SqlParameter("@channel_name", SqlDbType.NVarChar,255), new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@action_type", SqlDbType.NVarChar,100)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.channel_name; parameters2[2].Value = models.channel_id; parameters2[3].Value = models.action_type; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[2].Value; }
/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public int Add(Model.article_download model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_article("); strSql.Append("channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@category_id,@title,@link_url,@img_url,@seo_title,@seo_keywords,@seo_description,@content,@sort_id,@click,@is_lock,@user_id,@add_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@category_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@link_url", SqlDbType.NVarChar,255), new SqlParameter("@img_url", SqlDbType.NVarChar,255), new SqlParameter("@seo_title", SqlDbType.NVarChar,255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar,255), new SqlParameter("@seo_description", SqlDbType.NVarChar,255), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@click", SqlDbType.Int,4), new SqlParameter("@is_lock", SqlDbType.TinyInt,1), new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.category_id; parameters[2].Value = model.title; parameters[3].Value = model.link_url; parameters[4].Value = model.img_url; parameters[5].Value = model.seo_title; parameters[6].Value = model.seo_keywords; parameters[7].Value = model.seo_description; parameters[8].Value = model.content; parameters[9].Value = model.sort_id; parameters[10].Value = model.click; parameters[11].Value = model.is_lock; parameters[12].Value = model.user_id; parameters[13].Value = model.add_time; parameters[14].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //附表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("insert into dt_article_download("); strSql2.Append("id,is_msg,is_red)"); strSql2.Append(" values ("); strSql2.Append("@id,@is_msg,@is_red)"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@is_msg", SqlDbType.TinyInt,1), new SqlParameter("@is_red", SqlDbType.TinyInt,1)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = model.is_msg; parameters2[2].Value = model.is_red; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //顶和踩 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into dt_article_diggs("); strSql3.Append("id,digg_good,digg_bad)"); strSql3.Append(" values ("); strSql3.Append("@id,@digg_good,@digg_bad)"); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@digg_good", SqlDbType.Int,4), new SqlParameter("@digg_bad", SqlDbType.Int,4)}; parameters3[0].Direction = ParameterDirection.InputOutput; parameters3[1].Value = model.digg_good; parameters3[2].Value = model.digg_bad; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //下载附件 if (model.download_attachs != null) { StringBuilder strSql4; foreach (Model.download_attach models in model.download_attachs) { strSql4 = new StringBuilder(); strSql4.Append("insert into dt_download_attach("); strSql4.Append("article_id,title,file_path,file_ext,file_size,down_num,point)"); strSql4.Append(" values ("); strSql4.Append("@article_id,@title,@file_path,@file_ext,@file_size,@down_num,@point)"); SqlParameter[] parameters4 = { new SqlParameter("@article_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,255), new SqlParameter("@file_path", SqlDbType.NVarChar,255), new SqlParameter("@file_ext", SqlDbType.NVarChar,100), new SqlParameter("@file_size", SqlDbType.Int,4), new SqlParameter("@down_num", SqlDbType.Int,4), new SqlParameter("@point", SqlDbType.Int,4)}; parameters4[0].Direction = ParameterDirection.InputOutput; parameters4[1].Value = models.title; parameters4[2].Value = models.file_path; parameters4[3].Value = models.file_ext; parameters4[4].Value = models.file_size; parameters4[5].Value = models.down_num; parameters4[6].Value = models.point; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[14].Value; }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { List<CommandInfo> sqllist = new List<CommandInfo>(); StringBuilder strSql7 = new StringBuilder(); strSql7.Append("delete " + databaseprefix + "weixin_request_content "); strSql7.Append(" where account_id=@raccount_id"); SqlParameter[] parameters7 = { new SqlParameter("@account_id", SqlDbType.Int,4)}; parameters7[0].Value = id; CommandInfo cmd = new CommandInfo(strSql7.ToString(), parameters7); sqllist.Add(cmd); StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete " + databaseprefix + "weixin_request_rule "); strSql6.Append(" where account_id=@raccount_id"); SqlParameter[] parameters6 = { new SqlParameter("@account_id", SqlDbType.Int,4)}; parameters6[0].Value = id; cmd = new CommandInfo(strSql6.ToString(), parameters6); sqllist.Add(cmd); StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "weixin_response_content"); strSql5.Append(" where account_id=@account_id"); SqlParameter[] parameters5 = { new SqlParameter("@account_id", SqlDbType.Int,4)}; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "weixin_lbs_shop"); strSql4.Append(" where account_id=@account_id"); SqlParameter[] parameters4 = { new SqlParameter("@account_id", SqlDbType.Int,4)}; parameters4[0].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "weixin_lbs_setting"); strSql3.Append(" where account_id=@account_id"); SqlParameter[] parameters3 = { new SqlParameter("@account_id", SqlDbType.Int,4)}; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "weixin_access_token"); strSql2.Append(" where account_id=@account_id"); SqlParameter[] parameters2 = { new SqlParameter("@account_id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); StringBuilder strSql=new StringBuilder(); strSql.Append("delete from " + databaseprefix + "weixin_account"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.article_content model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_article("); strSql.Append("channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@category_id,@title,@link_url,@img_url,@seo_title,@seo_keywords,@seo_description,@content,@sort_id,@click,@is_lock,@user_id,@add_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@category_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@link_url", SqlDbType.NVarChar,255), new SqlParameter("@img_url", SqlDbType.NVarChar,255), new SqlParameter("@seo_title", SqlDbType.NVarChar,255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar,255), new SqlParameter("@seo_description", SqlDbType.NVarChar,255), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@click", SqlDbType.Int,4), new SqlParameter("@is_lock", SqlDbType.TinyInt,1), new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.category_id; parameters[2].Value = model.title; parameters[3].Value = model.link_url; parameters[4].Value = model.img_url; parameters[5].Value = model.seo_title; parameters[6].Value = model.seo_keywords; parameters[7].Value = model.seo_description; parameters[8].Value = model.content; parameters[9].Value = model.sort_id; parameters[10].Value = model.click; parameters[11].Value = model.is_lock; parameters[12].Value = model.user_id; parameters[13].Value = model.add_time; parameters[14].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //副表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("insert into dt_article_content("); strSql2.Append("id,call_index,is_msg,is_red)"); strSql2.Append(" values ("); strSql2.Append("@id,@call_index,@is_msg,@is_red)"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@call_index", SqlDbType.NVarChar,50), new SqlParameter("@is_msg", SqlDbType.TinyInt,1), new SqlParameter("@is_red", SqlDbType.TinyInt,1)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = model.call_index; parameters2[2].Value = model.is_msg; parameters2[3].Value = model.is_red; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //顶和踩 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into dt_article_diggs("); strSql3.Append("id,digg_good,digg_bad)"); strSql3.Append(" values ("); strSql3.Append("@id,@digg_good,@digg_bad)"); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@digg_good", SqlDbType.Int,4), new SqlParameter("@digg_bad", SqlDbType.Int,4)}; parameters3[0].Direction = ParameterDirection.InputOutput; parameters3[1].Value = model.digg_good; parameters3[2].Value = model.digg_bad; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[14].Value; }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { List<CommandInfo> sqllist = new List<CommandInfo>(); StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_manager_log "); strSql.Append(" where user_id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from dt_manager "); strSql1.Append(" where id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters1[0].Value = id; cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// ɾ��һ������ /// </summary> public bool Delete(int channel_id, int id) { List<CommandInfo> sqllist = new List<CommandInfo>(); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_comment "); strSql2.Append(" where channel_id=@channel_id and content_id=@content_id"); SqlParameter[] parameters2 = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@content_id", SqlDbType.Int,4)}; parameters2[0].Value = channel_id; parameters2[1].Value = id; CommandInfo cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_article "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public int Add(Model.article_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_article("); strSql.Append("channel_id,category_id,title,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_lock,user_id,add_time)"); strSql.Append(" values ("); strSql.Append("@channel_id,@category_id,@title,@link_url,@img_url,@seo_title,@seo_keywords,@seo_description,@content,@sort_id,@click,@is_lock,@user_id,@add_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@category_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@link_url", SqlDbType.NVarChar,255), new SqlParameter("@img_url", SqlDbType.NVarChar,255), new SqlParameter("@seo_title", SqlDbType.NVarChar,255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar,255), new SqlParameter("@seo_description", SqlDbType.NVarChar,255), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@click", SqlDbType.Int,4), new SqlParameter("@is_lock", SqlDbType.TinyInt,1), new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.category_id; parameters[2].Value = model.title; parameters[3].Value = model.link_url; parameters[4].Value = model.img_url; parameters[5].Value = model.seo_title; parameters[6].Value = model.seo_keywords; parameters[7].Value = model.seo_description; parameters[8].Value = model.content; parameters[9].Value = model.sort_id; parameters[10].Value = model.click; parameters[11].Value = model.is_lock; parameters[12].Value = model.user_id; parameters[13].Value = model.add_time; parameters[14].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //副表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("insert into dt_article_goods("); strSql2.Append("id,goods_no,stock_quantity,market_price,sell_price,point,is_msg,is_top,is_red,is_hot,is_slide)"); strSql2.Append(" values ("); strSql2.Append("@id,@goods_no,@stock_quantity,@market_price,@sell_price,@point,@is_msg,@is_top,@is_red,@is_hot,@is_slide)"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@goods_no", SqlDbType.NVarChar,100), new SqlParameter("@stock_quantity", SqlDbType.Int,4), new SqlParameter("@market_price", SqlDbType.Decimal,5), new SqlParameter("@sell_price", SqlDbType.Decimal,5), new SqlParameter("@point", SqlDbType.Int,4), new SqlParameter("@is_msg", SqlDbType.TinyInt,1), new SqlParameter("@is_top", SqlDbType.TinyInt,1), new SqlParameter("@is_red", SqlDbType.TinyInt,1), new SqlParameter("@is_hot", SqlDbType.TinyInt,1), new SqlParameter("@is_slide", SqlDbType.TinyInt,1)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = model.goods_no; parameters2[2].Value = model.stock_quantity; parameters2[3].Value = model.market_price; parameters2[4].Value = model.sell_price; parameters2[5].Value = model.point; parameters2[6].Value = model.is_msg; parameters2[7].Value = model.is_top; parameters2[8].Value = model.is_red; parameters2[9].Value = model.is_hot; parameters2[10].Value = model.is_slide; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //顶和踩 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into dt_article_diggs("); strSql3.Append("id,digg_good,digg_bad)"); strSql3.Append(" values ("); strSql3.Append("@id,@digg_good,@digg_bad)"); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@digg_good", SqlDbType.Int,4), new SqlParameter("@digg_bad", SqlDbType.Int,4)}; parameters3[0].Direction = ParameterDirection.InputOutput; parameters3[1].Value = model.digg_good; parameters3[2].Value = model.digg_bad; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //图片相册 if (model.albums != null) { StringBuilder strSql4; foreach (Model.article_albums models in model.albums) { strSql4 = new StringBuilder(); strSql4.Append("insert into dt_article_albums("); strSql4.Append("article_id,big_img,small_img,remark)"); strSql4.Append(" values ("); strSql4.Append("@article_id,@big_img,@small_img,@remark)"); SqlParameter[] parameters4 = { new SqlParameter("@article_id", SqlDbType.Int,4), new SqlParameter("@big_img", SqlDbType.NVarChar,255), new SqlParameter("@small_img", SqlDbType.NVarChar,255), new SqlParameter("@remark", SqlDbType.NVarChar,500)}; parameters4[0].Direction = ParameterDirection.InputOutput; parameters4[1].Value = models.big_img; parameters4[2].Value = models.small_img; parameters4[3].Value = models.remark; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); } } //扩展属性 if (model.attribute_values != null) { StringBuilder strSql5; foreach (Model.attribute_value models in model.attribute_values) { strSql5 = new StringBuilder(); strSql5.Append("insert into dt_attribute_value("); strSql5.Append("article_id,attribute_id,title,content)"); strSql5.Append(" values ("); strSql5.Append("@article_id,@attribute_id,@title,@content)"); SqlParameter[] parameters5 = { new SqlParameter("@article_id", SqlDbType.Int,4), new SqlParameter("@attribute_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@content", SqlDbType.NText)}; parameters5[0].Direction = ParameterDirection.InputOutput; parameters5[1].Value = models.attribute_id; parameters5[2].Value = models.title; parameters5[3].Value = models.content; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); } } //用户组价格 if (model.goods_group_prices != null) { StringBuilder strSql6; foreach (Model.goods_group_price models in model.goods_group_prices) { strSql6 = new StringBuilder(); strSql6.Append("insert into dt_goods_group_price("); strSql6.Append("article_id,group_id,price)"); strSql6.Append(" values ("); strSql6.Append("@article_id,@group_id,@price)"); SqlParameter[] parameters6 = { new SqlParameter("@article_id", SqlDbType.Int,4), new SqlParameter("@group_id", SqlDbType.Int,4), new SqlParameter("@price", SqlDbType.Decimal,5)}; parameters6[0].Direction = ParameterDirection.InputOutput; parameters6[1].Value = models.group_id; parameters6[2].Value = models.price; cmd = new CommandInfo(strSql6.ToString(), parameters6); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[14].Value; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.article_content model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_article set "); strSql.Append("channel_id=@channel_id,"); strSql.Append("category_id=@category_id,"); strSql.Append("title=@title,"); strSql.Append("link_url=@link_url,"); strSql.Append("img_url=@img_url,"); strSql.Append("seo_title=@seo_title,"); strSql.Append("seo_keywords=@seo_keywords,"); strSql.Append("seo_description=@seo_description,"); strSql.Append("content=@content,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("click=@click,"); strSql.Append("is_lock=@is_lock,"); strSql.Append("user_id=@user_id,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@category_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@link_url", SqlDbType.NVarChar,255), new SqlParameter("@img_url", SqlDbType.NVarChar,255), new SqlParameter("@seo_title", SqlDbType.NVarChar,255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar,255), new SqlParameter("@seo_description", SqlDbType.NVarChar,255), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@click", SqlDbType.Int,4), new SqlParameter("@is_lock", SqlDbType.TinyInt,1), new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.category_id; parameters[2].Value = model.title; parameters[3].Value = model.link_url; parameters[4].Value = model.img_url; parameters[5].Value = model.seo_title; parameters[6].Value = model.seo_keywords; parameters[7].Value = model.seo_description; parameters[8].Value = model.content; parameters[9].Value = model.sort_id; parameters[10].Value = model.click; parameters[11].Value = model.is_lock; parameters[12].Value = model.user_id; parameters[13].Value = model.add_time; parameters[14].Value = model.id; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //修改副表 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update dt_article_content set "); strSql2.Append("id=@id,"); strSql2.Append("call_index=@call_index,"); strSql2.Append("is_msg=@is_msg,"); strSql2.Append("is_red=@is_red"); strSql2.Append(" where id=@id "); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@call_index", SqlDbType.NVarChar,50), new SqlParameter("@is_msg", SqlDbType.TinyInt,1), new SqlParameter("@is_red", SqlDbType.TinyInt,1)}; parameters2[0].Value = model.id; parameters2[1].Value = model.call_index; parameters2[2].Value = model.is_msg; parameters2[3].Value = model.is_red; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //修改顶和踩 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("update dt_article_diggs set "); strSql3.Append("digg_good=@digg_good,"); strSql3.Append("digg_bad=@digg_bad"); strSql3.Append(" where id=@id "); SqlParameter[] parameters3 = { new SqlParameter("@digg_good", SqlDbType.Int,4), new SqlParameter("@digg_bad", SqlDbType.Int,4), new SqlParameter("@id", SqlDbType.Int,4)}; parameters3[0].Value = model.digg_good; parameters3[1].Value = model.digg_bad; parameters3[2].Value = model.id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// ����һ�����ݼ����ӱ� /// </summary> public bool Update(Model.manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_manager_role set "); strSql.Append("role_name=@role_name,"); strSql.Append("role_type=@role_type"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4), new SqlParameter("@role_name", SqlDbType.NVarChar,100), new SqlParameter("@role_type", SqlDbType.TinyInt,1)}; parameters[0].Value = model.id; parameters[1].Value = model.role_name; parameters[2].Value = model.role_type; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //ɾ��Ȩ�� StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_manager_role_value where role_id=@role_id "); StringBuilder idList = new StringBuilder(); if (model.manager_role_values != null) { foreach (Model.manager_role_value models in model.manager_role_values) { if (models.id > 0) { idList.Append(models.id + ","); } } string id_list = Utils.DelLastChar(idList.ToString(), ","); if (!string.IsNullOrEmpty(id_list)) { strSql2.Append(" and id not in(" + id_list + ")"); } } SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int,4)}; parameters2[0].Value = model.id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //���Ȩ�� if (model.manager_role_values != null) { StringBuilder strSql3; foreach (Model.manager_role_value models in model.manager_role_values) { strSql3 = new StringBuilder(); if (models.id == 0) { strSql3.Append("insert into dt_manager_role_value("); strSql3.Append("role_id,channel_name,channel_id,action_type)"); strSql3.Append(" values ("); strSql3.Append("@role_id,@channel_name,@channel_id,@action_type)"); SqlParameter[] parameters3 = { new SqlParameter("@role_id", SqlDbType.Int,4), new SqlParameter("@channel_name", SqlDbType.NVarChar,255), new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@action_type", SqlDbType.NVarChar,100)}; parameters3[0].Value = model.id; parameters3[1].Value = models.channel_name; parameters3[2].Value = models.channel_id; parameters3[3].Value = models.action_type; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); } } } int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public int Add(Model.orders model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into dt_orders("); strSql.Append("order_no,user_id,user_name,payment_id,distribution_id,status,payment_status,distribution_status,delivery_name,delivery_no,accept_name,post_code,telphone,mobile,address,message,payable_amount,real_amount,payable_freight,real_freight,payment_fee,order_amount,point,add_time,payment_time,confirm_time,distribution_time,complete_time)"); strSql.Append(" values ("); strSql.Append("@order_no,@user_id,@user_name,@payment_id,@distribution_id,@status,@payment_status,@distribution_status,@delivery_name,@delivery_no,@accept_name,@post_code,@telphone,@mobile,@address,@message,@payable_amount,@real_amount,@payable_freight,@real_freight,@payment_fee,@order_amount,@point,@add_time,@payment_time,@confirm_time,@distribution_time,@complete_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@order_no", SqlDbType.NVarChar,100), new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@payment_id", SqlDbType.Int,4), new SqlParameter("@distribution_id", SqlDbType.Int,4), new SqlParameter("@status", SqlDbType.TinyInt,1), new SqlParameter("@payment_status", SqlDbType.TinyInt,1), new SqlParameter("@distribution_status", SqlDbType.TinyInt,1), new SqlParameter("@delivery_name", SqlDbType.NVarChar,100), new SqlParameter("@delivery_no", SqlDbType.NVarChar,100), new SqlParameter("@accept_name", SqlDbType.NVarChar,50), new SqlParameter("@post_code", SqlDbType.NVarChar,20), new SqlParameter("@telphone", SqlDbType.NVarChar,30), new SqlParameter("@mobile", SqlDbType.NVarChar,30), new SqlParameter("@address", SqlDbType.NVarChar,255), new SqlParameter("@message", SqlDbType.NVarChar,500), new SqlParameter("@payable_amount", SqlDbType.Decimal,5), new SqlParameter("@real_amount", SqlDbType.Decimal,5), new SqlParameter("@payable_freight", SqlDbType.Decimal,5), new SqlParameter("@real_freight", SqlDbType.Decimal,5), new SqlParameter("@payment_fee", SqlDbType.Decimal,5), new SqlParameter("@order_amount", SqlDbType.Decimal,5), new SqlParameter("@point", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@payment_time", SqlDbType.DateTime), new SqlParameter("@confirm_time", SqlDbType.DateTime), new SqlParameter("@distribution_time", SqlDbType.DateTime), new SqlParameter("@complete_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.order_no; parameters[1].Value = model.user_id; parameters[2].Value = model.user_name; parameters[3].Value = model.payment_id; parameters[4].Value = model.distribution_id; parameters[5].Value = model.status; parameters[6].Value = model.payment_status; parameters[7].Value = model.distribution_status; parameters[8].Value = model.delivery_name; parameters[9].Value = model.delivery_no; parameters[10].Value = model.accept_name; parameters[11].Value = model.post_code; parameters[12].Value = model.telphone; parameters[13].Value = model.mobile; parameters[14].Value = model.address; parameters[15].Value = model.message; parameters[16].Value = model.payable_amount; parameters[17].Value = model.real_amount; parameters[18].Value = model.payable_freight; parameters[19].Value = model.real_freight; parameters[20].Value = model.payment_fee; parameters[21].Value = model.order_amount; parameters[22].Value = model.point; parameters[23].Value = model.add_time; parameters[24].Value = model.payment_time; parameters[25].Value = model.confirm_time; parameters[26].Value = model.distribution_time; parameters[27].Value = model.complete_time; parameters[28].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //订单商品列表 if (model.order_goods != null) { StringBuilder strSql2; foreach (Model.order_goods models in model.order_goods) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_order_goods("); strSql2.Append("order_id,goods_id,goods_name,goods_price,real_price,quantity,point)"); strSql2.Append(" values ("); strSql2.Append("@order_id,@goods_id,@goods_name,@goods_price,@real_price,@quantity,@point)"); SqlParameter[] parameters2 = { new SqlParameter("@order_id", SqlDbType.Int,4), new SqlParameter("@goods_id", SqlDbType.Int,4), new SqlParameter("@goods_name", SqlDbType.NVarChar,100), new SqlParameter("@goods_price", SqlDbType.Decimal,5), new SqlParameter("@real_price", SqlDbType.Decimal,5), new SqlParameter("@quantity", SqlDbType.Int,4), new SqlParameter("@point", SqlDbType.Int,4)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.goods_id; parameters2[2].Value = models.goods_name; parameters2[3].Value = models.goods_price; parameters2[4].Value = models.real_price; parameters2[5].Value = models.quantity; parameters2[6].Value = models.point; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[28].Value; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.weixin_request_rule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "weixin_request_rule("); strSql.Append("is_default,sort_id,add_time,account_id,name,keywords,request_type,response_type,is_like_query)"); strSql.Append(" values ("); strSql.Append("@is_default,@sort_id,@add_time,@account_id,@name,@keywords,@request_type,@response_type,@is_like_query)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@is_default", SqlDbType.TinyInt,1), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@account_id", SqlDbType.Int,4), new SqlParameter("@name", SqlDbType.NVarChar,200), new SqlParameter("@keywords", SqlDbType.NVarChar,2000), new SqlParameter("@request_type", SqlDbType.Int,4), new SqlParameter("@response_type", SqlDbType.Int,4), new SqlParameter("@is_like_query", SqlDbType.TinyInt,1), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.is_default; parameters[1].Value = model.sort_id; parameters[2].Value = model.add_time; parameters[3].Value = model.account_id; parameters[4].Value = model.name; parameters[5].Value = model.keywords; parameters[6].Value = model.request_type; parameters[7].Value = model.response_type; parameters[8].Value = model.is_like_query; parameters[9].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); if (model.contents != null) { StringBuilder strSql2; foreach (Model.weixin_request_content models in model.contents) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "weixin_request_content("); strSql2.Append("sort_id,add_time,account_id,rule_id,title,content,link_url,img_url,media_url,meida_hd_url)"); strSql2.Append(" values ("); strSql2.Append("@sort_id,@add_time,@account_id,@rule_id,@title,@content,@link_url,@img_url,@media_url,@meida_hd_url)"); SqlParameter[] parameters2 = { new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@account_id", SqlDbType.Int,4), new SqlParameter("@rule_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,500), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@link_url", SqlDbType.NVarChar,500), new SqlParameter("@img_url", SqlDbType.NVarChar,500), new SqlParameter("@media_url", SqlDbType.NVarChar,500), new SqlParameter("@meida_hd_url", SqlDbType.NVarChar,500)}; parameters2[0].Value = models.sort_id; parameters2[1].Value = models.add_time; parameters2[2].Value = models.account_id; parameters2[3].Direction = ParameterDirection.InputOutput; parameters2[4].Value = models.title; parameters2[5].Value = models.content; parameters2[6].Value = models.link_url; parameters2[7].Value = models.img_url; parameters2[8].Value = models.media_url; parameters2[9].Value = models.meida_hd_url; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[9].Value; }
/// <summary> /// ����һ������ /// </summary> public bool Update(Model.manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "manager_role set "); strSql.Append("role_name=@role_name,"); strSql.Append("role_type=@role_type,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@role_name", SqlDbType.NVarChar,100), new SqlParameter("@role_type", SqlDbType.TinyInt,1), new SqlParameter("@is_sys", SqlDbType.TinyInt,1), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Value = model.is_sys; parameters[3].Value = model.id; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //��ɾ���ý�ɫ����Ȩ�� StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "manager_role_value where role_id=@role_id "); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int,4)}; parameters2[0].Value = model.id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //���Ȩ�� if (model.manager_role_values != null) { StringBuilder strSql3; foreach (Model.manager_role_value modelt in model.manager_role_values) { strSql3 = new StringBuilder(); strSql3.Append("insert into " + databaseprefix + "manager_role_value("); strSql3.Append("role_id,nav_name,action_type)"); strSql3.Append(" values ("); strSql3.Append("@role_id,@nav_name,@action_type)"); SqlParameter[] parameters3 = { new SqlParameter("@role_id", SqlDbType.Int,4), new SqlParameter("@nav_name", SqlDbType.NVarChar,100), new SqlParameter("@action_type", SqlDbType.NVarChar,50)}; parameters3[0].Value = model.id; parameters3[1].Value = modelt.nav_name; parameters3[2].Value = modelt.action_type; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); } } int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 直接充值订单 /// </summary> public bool Recharge(Model.user_recharge model) { //增加一条账户余额记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into " + databaseprefix + "user_amount_log("); strSql3.Append("user_id,user_name,value,remark,add_time)"); strSql3.Append(" values ("); strSql3.Append("@user_id,@user_name,@value,@remark,@add_time)"); SqlParameter[] parameters3 = { new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@value", SqlDbType.Decimal,5), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@add_time", SqlDbType.DateTime)}; parameters3[0].Value = model.user_id; parameters3[1].Value = model.user_name; parameters3[2].Value = model.amount; parameters3[3].Value = "在线充值,单号:" + model.recharge_no; parameters3[4].Value = DateTime.Now; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //修改用户表金额 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.amount); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = model.user_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //添加充值表 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_recharge("); strSql.Append("user_id,user_name,recharge_no,payment_id,amount,status,add_time,complete_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@recharge_no,@payment_id,@amount,@status,@add_time,@complete_time)"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@recharge_no", SqlDbType.NVarChar,100), new SqlParameter("@payment_id", SqlDbType.Int,4), new SqlParameter("@amount", SqlDbType.Decimal,5), new SqlParameter("@status", SqlDbType.TinyInt,1), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@complete_time", SqlDbType.DateTime)}; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.recharge_no; parameters[3].Value = model.payment_id; parameters[4].Value = model.amount; parameters[5].Value = model.status; parameters[6].Value = model.add_time; parameters[7].Value = model.complete_time; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������,�����ӱ����� /// </summary> public int Add(Model.photo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_photo("); strSql.Append("channel_id,title,category_id,photo_no,market_price,sell_price,link_url,img_url,seo_title,seo_keywords,seo_description,content,sort_id,click,is_msg,is_top,is_red,is_hot,is_slide,is_lock,add_time,digg_good,digg_act)"); strSql.Append(" values ("); strSql.Append("@channel_id,@title,@category_id,@photo_no,@market_price,@sell_price,@link_url,@img_url,@seo_title,@seo_keywords,@seo_description,@content,@sort_id,@click,@is_msg,@is_top,@is_red,@is_hot,@is_slide,@is_lock,@add_time,@digg_good,@digg_act)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@category_id", SqlDbType.Int,4), new SqlParameter("@photo_no", SqlDbType.NVarChar,100), new SqlParameter("@market_price", SqlDbType.Decimal,9), new SqlParameter("@sell_price", SqlDbType.Decimal,9), new SqlParameter("@link_url", SqlDbType.NVarChar,255), new SqlParameter("@img_url", SqlDbType.NVarChar,255), new SqlParameter("@seo_title", SqlDbType.NVarChar,255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar,255), new SqlParameter("@seo_description", SqlDbType.NVarChar,255), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@click", SqlDbType.Int,4), new SqlParameter("@is_msg", SqlDbType.TinyInt,1), new SqlParameter("@is_top", SqlDbType.TinyInt,1), new SqlParameter("@is_red", SqlDbType.TinyInt,1), new SqlParameter("@is_hot", SqlDbType.TinyInt,1), new SqlParameter("@is_slide", SqlDbType.TinyInt,1), new SqlParameter("@is_lock", SqlDbType.TinyInt,1), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@digg_good", SqlDbType.Int,4), new SqlParameter("@digg_act", SqlDbType.Int,4), new SqlParameter("@ReturnValue",SqlDbType.Int)}; parameters[0].Value = model.channel_id; parameters[1].Value = model.title; parameters[2].Value = model.category_id; parameters[3].Value = model.photo_no; parameters[4].Value = model.market_price; parameters[5].Value = model.sell_price; parameters[6].Value = model.link_url; parameters[7].Value = model.img_url; parameters[8].Value = model.seo_title; parameters[9].Value = model.seo_keywords; parameters[10].Value = model.seo_description; parameters[11].Value = model.content; parameters[12].Value = model.sort_id; parameters[13].Value = model.click; parameters[14].Value = model.is_msg; parameters[15].Value = model.is_top; parameters[16].Value = model.is_red; parameters[17].Value = model.is_hot; parameters[18].Value = model.is_slide; parameters[19].Value = model.is_lock; parameters[20].Value = model.add_time; parameters[21].Value = model.digg_good; parameters[22].Value = model.digg_act; parameters[23].Direction = ParameterDirection.Output; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); if (model.photo_albums != null) { StringBuilder strSql2; foreach (Model.photo_album models in model.photo_albums) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_photo_album("); strSql2.Append("photo_id,big_img,small_img)"); strSql2.Append(" values ("); strSql2.Append("@photo_id,@big_img,@small_img)"); SqlParameter[] parameters2 = { new SqlParameter("@photo_id", SqlDbType.Int,4), new SqlParameter("@big_img", SqlDbType.NVarChar,255), new SqlParameter("@small_img", SqlDbType.NVarChar,255)}; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.big_img; parameters2[2].Value = models.small_img; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } if (model.photo_attribute_values != null) { StringBuilder strSql3; foreach (Model.photo_attribute_value models in model.photo_attribute_values) { strSql3 = new StringBuilder(); strSql3.Append("insert into dt_photo_attribute_value("); strSql3.Append("photo_id,attribute_id,title,content)"); strSql3.Append(" values ("); strSql3.Append("@photo_id,@attribute_id,@title,@content)"); SqlParameter[] parameters3 = { new SqlParameter("@photo_id", SqlDbType.Int,4), new SqlParameter("@attribute_id", SqlDbType.Int,4), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@content", SqlDbType.NText)}; parameters3[0].Direction = ParameterDirection.InputOutput; parameters3[1].Value = models.attribute_id; parameters3[2].Value = models.title; parameters3[3].Value = models.content; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return (int)parameters[23].Value; }
/// <summary> /// ɾ��һ�����ݣ����ӱ������������ /// </summary> public bool Delete(int channel_id, int id) { //ȡ�����MODEL List<Model.photo_album> ls = new List<Model.photo_album>(); Model.photo model = GetModel(id); if (model != null) { ls = model.photo_albums; } List<CommandInfo> sqllist = new List<CommandInfo>(); StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_photo_album "); strSql.Append(" where photo_id=@photo_id "); SqlParameter[] parameters = { new SqlParameter("@photo_id", SqlDbType.Int,4)}; parameters[0].Value = id; CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_photo_attribute_value "); strSql2.Append(" where photo_id=@photo_id"); SqlParameter[] parameters2 = { new SqlParameter("@photo_id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from dt_photo "); strSql3.Append(" where id=@id "); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from dt_comment "); strSql4.Append(" where channel_id=@channel_id and content_id=@content_id"); SqlParameter[] parameters4 = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@content_id", SqlDbType.Int,4)}; parameters4[0].Value = channel_id; parameters4[1].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { DeleteAlbumFile(ls); return true; } else { return false; } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得相册MODEL List<Model.article_albums> albumsList = new DAL.article_albums(databaseprefix).GetList(id); //取得附件MODEL List<Model.article_attach> attachList = new DAL.article_attach(databaseprefix).GetList(id); //删除扩展字段表 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "article_attribute_value "); strSql1.Append(" where article_id=@article_id "); SqlParameter[] parameters1 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters1[0].Value = id; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //删除图片相册 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "article_albums "); strSql2.Append(" where article_id=@article_id "); SqlParameter[] parameters2 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //删除附件 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "article_attach "); strSql3.Append(" where article_id=@article_id "); SqlParameter[] parameters3 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //删除用户组价格 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_group_price "); strSql4.Append(" where article_id=@article_id "); SqlParameter[] parameters4 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters4[0].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //删除商品价格 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "article_goods"); strSql5.Append(" where article_id=@article_id"); SqlParameter[] parameters5 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //删除商品规格 StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete from " + databaseprefix + "article_goods_spec"); strSql6.Append(" where article_id=@article_id"); SqlParameter[] parameters6 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters6[0].Value = id; cmd = new CommandInfo(strSql6.ToString(), parameters6); sqllist.Add(cmd); //删除Tags标签关系 StringBuilder strSql7 = new StringBuilder(); strSql7.Append("delete from " + databaseprefix + "article_tags_relation"); strSql7.Append(" where article_id=@article_id"); SqlParameter[] parameters7 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters7[0].Value = id; cmd = new CommandInfo(strSql7.ToString(), parameters7); sqllist.Add(cmd); //删除评论 StringBuilder strSql8 = new StringBuilder(); strSql8.Append("delete from " + databaseprefix + "article_comment "); strSql8.Append(" where article_id=@article_id "); SqlParameter[] parameters8 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters8[0].Value = id; cmd = new CommandInfo(strSql8.ToString(), parameters8); sqllist.Add(cmd); //删除主表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "article "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { new DAL.article_albums(databaseprefix).DeleteFile(albumsList); //删除图片 new DAL.article_attach(databaseprefix).DeleteFile(attachList); //删除附件 return true; } else { return false; } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //删除规格值 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "article_spec"); strSql1.Append(" where parent_id=@parent_id"); SqlParameter[] parameters1 = { new SqlParameter("@parent_id", SqlDbType.Int,4)}; parameters1[0].Value = id; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //删除规格 StringBuilder strSql=new StringBuilder(); strSql.Append("delete from " + databaseprefix + "article_spec "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// ɾ��һ������ /// </summary> public bool Delete(int id) { //��ȡ�û������� Model.users model = GetModel(id); if (model == null) { return false; } List<CommandInfo> sqllist = new List<CommandInfo>(); //ɾ�����ּ�¼ StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "user_point_log "); strSql1.Append(" where user_id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters1[0].Value = id; CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //ɾ������¼ StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "user_amount_log "); strSql2.Append(" where user_id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //ɾ������Ϣ StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "user_message "); strSql3.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); SqlParameter[] parameters3 = { new SqlParameter("@post_user_name", SqlDbType.NVarChar,100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar,100)}; parameters3[0].Value = model.user_name; parameters3[1].Value = model.user_name; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //ɾ�������� StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_code "); strSql4.Append(" where user_id=@id"); SqlParameter[] parameters4 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters4[0].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //ɾ����¼��־ StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "user_login_log "); strSql5.Append(" where user_id=@id"); SqlParameter[] parameters5 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //ɾ���û���¼ StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { List<CommandInfo> sqllist = new List<CommandInfo>(); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "weixin_request_content "); strSql2.Append(" where rule_id=@rule_id "); SqlParameter[] parameters2 = { new SqlParameter("@rule_id", SqlDbType.Int,4)}; parameters2[0].Value = id; CommandInfo cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "weixin_request_rule "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 确认充值订单 /// </summary> public bool Confirm(string recharge_no) { Model.user_recharge model = GetModel(recharge_no); //根据充值单号得到实体 if (model == null) { return false; } //增加一条账户余额记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("insert into " + databaseprefix + "user_amount_log("); strSql3.Append("user_id,user_name,value,remark,add_time)"); strSql3.Append(" values ("); strSql3.Append("@user_id,@user_name,@value,@remark,@add_time)"); SqlParameter[] parameters3 = { new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@value", SqlDbType.Decimal,5), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@add_time", SqlDbType.DateTime)}; parameters3[0].Value = model.user_id; parameters3[1].Value = model.user_name; parameters3[2].Value = model.amount; parameters3[3].Value = "在线充值,单号:" + recharge_no; parameters3[4].Value = DateTime.Now; List<CommandInfo> sqllist = new List<CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //修改用户表金额 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update " + databaseprefix + "users set amount=amount+" + model.amount); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = model.user_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //更新充值表 StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_recharge set "); strSql.Append("status=@status,"); strSql.Append("complete_time=@complete_time"); strSql.Append(" where recharge_no=@recharge_no"); SqlParameter[] parameters = { new SqlParameter("@status", SqlDbType.TinyInt,1), new SqlParameter("@complete_time", SqlDbType.DateTime), new SqlParameter("@recharge_no", SqlDbType.NVarChar,100)}; parameters[0].Value = 1; parameters[1].Value = DateTime.Now; parameters[2].Value = recharge_no; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }
/// <summary> /// 删除一条数据,及子表所有相关数据 /// </summary> public bool Delete(int id) { //取得相册MODEL List<Model.article_albums> albumsList = new article_albums().GetList(id); //取得附件MODEL List<Model.download_attach> attachList = new download_attach().GetList(id); List<CommandInfo> sqllist = new List<CommandInfo>(); //删除文章模型数据 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_article_news "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //删除下载模型数据 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_article_download "); strSql2.Append(" where id=@id "); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //删除商品模型数据 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from dt_article_goods "); strSql3.Append(" where id=@id "); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //删除内容模型数据 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from dt_article_content "); strSql4.Append(" where id=@id "); SqlParameter[] parameters4 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters4[0].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //删除顶和踩 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from dt_article_diggs "); strSql5.Append(" where id=@id "); SqlParameter[] parameters5 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //删除商品价格 StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete from dt_goods_group_price "); strSql6.Append(" where article_id=@article_id "); SqlParameter[] parameters6 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters6[0].Value = id; cmd = new CommandInfo(strSql6.ToString(), parameters6); sqllist.Add(cmd); //删除下载的附件 StringBuilder strSql7 = new StringBuilder(); strSql7.Append("delete from dt_download_attach "); strSql7.Append(" where article_id=@article_id "); SqlParameter[] parameters7 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters7[0].Value = id; cmd = new CommandInfo(strSql7.ToString(), parameters7); sqllist.Add(cmd); //删除图片相册 StringBuilder strSql8 = new StringBuilder(); strSql8.Append("delete from dt_article_albums "); strSql8.Append(" where article_id=@article_id "); SqlParameter[] parameters8 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters8[0].Value = id; cmd = new CommandInfo(strSql8.ToString(), parameters8); sqllist.Add(cmd); //删除扩展属性 StringBuilder strSql9 = new StringBuilder(); strSql9.Append("delete from dt_attribute_value "); strSql9.Append(" where article_id=@article_id "); SqlParameter[] parameters9 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters9[0].Value = id; cmd = new CommandInfo(strSql9.ToString(), parameters9); sqllist.Add(cmd); //删除评论 StringBuilder strSql10 = new StringBuilder(); strSql10.Append("delete from dt_article_comment "); strSql10.Append(" where article_id=@article_id "); SqlParameter[] parameters10 = { new SqlParameter("@article_id", SqlDbType.Int,4)}; parameters10[0].Value = id; cmd = new CommandInfo(strSql10.ToString(), parameters10); sqllist.Add(cmd); //删除主表信息 StringBuilder strSql11 = new StringBuilder(); strSql11.Append("delete from dt_article "); strSql11.Append(" where id=@id "); SqlParameter[] parameters11 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters11[0].Value = id; cmd = new CommandInfo(strSql11.ToString(), parameters11); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { new article_albums().DeleteFile(albumsList); //删除图片 new download_attach().DeleteFile(attachList); //删除附件 return true; } else { return false; } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //获取用户旧数据 Model.users model = GetModel(id); if (model == null) { return false; } List<CommandInfo> sqllist = new List<CommandInfo>(); //删除积分记录 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "user_point_log "); strSql1.Append(" where user_id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters1[0].Value = id; CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //删除金额记录 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "user_amount_log "); strSql2.Append(" where user_id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //删除附件购买记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "user_attach_log"); strSql3.Append(" where user_id=@id"); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //删除短消息 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_message "); strSql4.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); SqlParameter[] parameters4 = { new SqlParameter("@post_user_name", SqlDbType.NVarChar,100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar,100)}; parameters4[0].Value = model.user_name; parameters4[1].Value = model.user_name; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //删除申请码 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "user_code "); strSql5.Append(" where user_id=@id"); SqlParameter[] parameters5 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //删除登录日志 StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete from " + databaseprefix + "user_login_log "); strSql6.Append(" where user_id=@id"); SqlParameter[] parameters6 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters6[0].Value = id; cmd = new CommandInfo(strSql6.ToString(), parameters6); sqllist.Add(cmd); //删除用户地址簿 StringBuilder strSql7 = new StringBuilder(); strSql7.Append("delete from " + databaseprefix + "user_addr_book "); strSql7.Append(" where user_id=@id"); SqlParameter[] parameters7 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters7[0].Value = id; cmd = new CommandInfo(strSql7.ToString(), parameters7); sqllist.Add(cmd); //删除OAuth授权用户信息 StringBuilder strSql8 = new StringBuilder(); strSql8.Append("delete from " + databaseprefix + "user_oauth "); strSql8.Append(" where user_id=@id"); SqlParameter[] parameters8 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters8[0].Value = id; cmd = new CommandInfo(strSql8.ToString(), parameters8); sqllist.Add(cmd); //删除用户充值表 StringBuilder strSql9 = new StringBuilder(); strSql9.Append("delete from " + databaseprefix + "user_recharge "); strSql9.Append(" where user_id=@id"); SqlParameter[] parameters9 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters9[0].Value = id; cmd = new CommandInfo(strSql9.ToString(), parameters9); sqllist.Add(cmd); //删除用户主表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }