/// <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 int Add(Model.amount_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_amount_log("); strSql.Append("user_id,user_name,type,order_no,payment_id,value,remark,status,add_time,complete_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@type,@order_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("@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.payment_id; parameters[5].Value = model.value; parameters[6].Value = model.remark; parameters[7].Value = model.status; parameters[8].Value = model.add_time; parameters[9].Value = model.complete_time; parameters[10].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 dt_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[10].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.point_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_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 dt_users set point=point+" + model.value); if (model.value > 0) { 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 bool Update(Model.amount_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_amount_log set "); strSql.Append("user_id=@user_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("type=@type,"); strSql.Append("order_no=@order_no,"); strSql.Append("payment_id=@payment_id,"); strSql.Append("value=@value,"); strSql.Append("remark=@remark,"); strSql.Append("status=@status,"); strSql.Append("add_time=@add_time,"); strSql.Append("complete_time=@complete_time"); strSql.Append(" where id=@id"); 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("@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("@id", SqlDbType.Int,4)}; 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.payment_id; parameters[5].Value = model.value; parameters[6].Value = model.remark; parameters[7].Value = model.status; parameters[8].Value = model.add_time; parameters[9].Value = model.complete_time; parameters[10].Value = model.id; 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 dt_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); } 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 bool Delete(int id) { //��ȡ���û�Model Model.users model = GetModel(id); if (model == null) { return false; } List<CommandInfo> sqllist = new List<CommandInfo>(); //ɾ����¼��־ StringBuilder strSql = new StringBuilder(); strSql.Append("delete from dt_user_login_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_user_code "); strSql1.Append(" where user_id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters1[0].Value = id; cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //ɾ�����ּ�¼ StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from dt_point_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 dt_amount_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 dt_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 dt_users "); 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); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return true; } else { return false; } }