/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_particulars model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_particulars("); strSql.Append("Title,TextContent,CreateTime)"); strSql.Append(" values ("); strSql.Append("@Title,@TextContent,@CreateTime)"); MySqlParameter[] parameters = { new MySqlParameter("@Title", MySqlDbType.VarChar, 128), new MySqlParameter("@TextContent", MySqlDbType.Text), new MySqlParameter("@CreateTime", MySqlDbType.DateTime) }; parameters[0].Value = model.Title; parameters[1].Value = model.TextContent; parameters[2].Value = model.CreateTime; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_agent_store model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_agent_store("); strSql.Append("AgentId,StoreId)"); strSql.Append(" values ("); strSql.Append("@AgentId,@StoreId)"); MySqlParameter[] parameters = { new MySqlParameter("@AgentId", MySqlDbType.Int32, 11), new MySqlParameter("@StoreId", MySqlDbType.Int32, 11) }; parameters[0].Value = model.AgentId; parameters[1].Value = model.StoreId; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_store_customer_business model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_store_customer_business("); strSql.Append("StoreId,CustomerId,BusinessId)"); strSql.Append(" values ("); strSql.Append("@StoreId,@CustomerId,@BusinessId)"); MySqlParameter[] parameters = { new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@CustomerId", MySqlDbType.Int32, 11), new MySqlParameter("@BusinessId", MySqlDbType.Int32, 11) }; parameters[0].Value = model.StoreId; parameters[1].Value = model.CustomerId; parameters[2].Value = model.BusinessId; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 快捷添加系统默认导航,带事务 /// </summary> public int Add(MySqlConnection conn, MySqlTransaction trans, int parent_id, string nav_name, string title, string link_url, int sort_id, int channel_id, string action_type) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "navigation("); strSql.Append("parent_id,channel_id,nav_type,name,title,link_url,sort_id,action_type,is_lock,is_sys)"); strSql.Append(" values ("); strSql.Append("@parent_id,@channel_id,@nav_type,@name,@title,@link_url,@sort_id,@action_type,@is_lock,@is_sys)"); MySqlParameter[] parameters = { new MySqlParameter("@parent_id", MySqlDbType.Int32, 4), new MySqlParameter("@channel_id", MySqlDbType.Int32, 4), new MySqlParameter("@nav_type", MySqlDbType.VarChar, 50), new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@title", MySqlDbType.VarChar, 100), new MySqlParameter("@link_url", MySqlDbType.VarChar, 255), new MySqlParameter("@sort_id", MySqlDbType.Int32, 4), new MySqlParameter("@action_type", MySqlDbType.VarChar, 500), new MySqlParameter("@is_lock", MySqlDbType.Int32, 4), new MySqlParameter("@is_sys", MySqlDbType.Int32, 4) }; parameters[0].Value = parent_id; parameters[1].Value = channel_id; parameters[2].Value = DTEnums.NavigationEnum.System.ToString(); parameters[3].Value = nav_name; parameters[4].Value = title; parameters[5].Value = link_url; parameters[6].Value = sort_id; parameters[7].Value = action_type; parameters[8].Value = 0; parameters[9].Value = 1; DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID return(GetMaxId(conn, trans)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_agent_store model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_agent_store set "); strSql.Append("AgentId=@AgentId,"); strSql.Append("StoreId=@StoreId"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@AgentId", MySqlDbType.Int32, 11), new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.AgentId; parameters[1].Value = model.StoreId; parameters[2].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.manager_role model) { using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString)) { conn.Open(); using (MySqlTransaction trans = conn.BeginTransaction()) { try { 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)"); MySqlParameter[] parameters = { new MySqlParameter("@role_name", MySqlDbType.VarChar, 100), new MySqlParameter("@role_type", MySqlDbType.Int32, 4), new MySqlParameter("@is_sys", MySqlDbType.Int32, 4) }; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Value = model.is_sys; DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID model.id = GetMaxId(conn, trans); 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)"); MySqlParameter[] parameters2 = { new MySqlParameter("@role_id", MySqlDbType.Int32, 4), new MySqlParameter("@nav_name", MySqlDbType.VarChar, 100), new MySqlParameter("@action_type", MySqlDbType.VarChar, 50) }; parameters2[0].Value = model.id; parameters2[1].Value = modelt.nav_name; parameters2[2].Value = modelt.action_type; DbHelperMySql.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(model.id); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_reward_detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_reward_detail("); strSql.Append("RewardId,OpenrId,DistributionRatio,UserType,RewardMoney,BenefitMoney)"); strSql.Append(" values ("); strSql.Append("@RewardId,@OpenrId,@DistributionRatio,@UserType,@RewardMoney,@BenefitMoney)"); MySqlParameter[] parameters = { new MySqlParameter("@RewardId", MySqlDbType.Int32, 11), new MySqlParameter("@OpenrId", MySqlDbType.LongText), new MySqlParameter("@DistributionRatio", MySqlDbType.Float), new MySqlParameter("@UserType", MySqlDbType.Int16, 4), new MySqlParameter("@RewardMoney", MySqlDbType.Decimal, 10), new MySqlParameter("@BenefitMoney", MySqlDbType.Decimal, 10) }; parameters[0].Value = model.RewardId; parameters[1].Value = model.OpenrId; parameters[2].Value = model.DistributionRatio; parameters[3].Value = model.UserType; parameters[4].Value = model.RewardMoney; parameters[5].Value = model.BenefitMoney; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.dt_manager_role_value model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_manager_role_value set "); strSql.Append("role_id=@role_id,"); strSql.Append("nav_name=@nav_name,"); strSql.Append("action_type=@action_type"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@role_id", MySqlDbType.Int32, 11), new MySqlParameter("@nav_name", MySqlDbType.VarChar, 100), new MySqlParameter("@action_type", MySqlDbType.VarChar, 50), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.role_id; parameters[1].Value = model.nav_name; parameters[2].Value = model.action_type; parameters[3].Value = model.id; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.dt_manager_role_value model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_manager_role_value("); strSql.Append("role_id,nav_name,action_type)"); strSql.Append(" values ("); strSql.Append("@role_id,@nav_name,@action_type)"); MySqlParameter[] parameters = { new MySqlParameter("@role_id", MySqlDbType.Int32, 11), new MySqlParameter("@nav_name", MySqlDbType.VarChar, 100), new MySqlParameter("@action_type", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.role_id; parameters[1].Value = model.nav_name; parameters[2].Value = model.action_type; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_checkcode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_checkcode set "); strSql.Append("PhoneNumber=@PhoneNumber,"); strSql.Append("Code=@Code,"); strSql.Append("Type=@Type,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@PhoneNumber", MySqlDbType.VarChar, 20), new MySqlParameter("@Code", MySqlDbType.VarChar, 10), new MySqlParameter("@Type", MySqlDbType.Int16, 4), new MySqlParameter("@CreateTime", MySqlDbType.DateTime), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.PhoneNumber; parameters[1].Value = model.Code; parameters[2].Value = model.Type; parameters[3].Value = model.CreateTime; parameters[4].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_checkcode model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_checkcode("); strSql.Append("PhoneNumber,Code,Type,CreateTime)"); strSql.Append(" values ("); strSql.Append("@PhoneNumber,@Code,@Type,@CreateTime)"); MySqlParameter[] parameters = { new MySqlParameter("@PhoneNumber", MySqlDbType.VarChar, 20), new MySqlParameter("@Code", MySqlDbType.VarChar, 10), new MySqlParameter("@Type", MySqlDbType.Int16, 4), new MySqlParameter("@CreateTime", MySqlDbType.DateTime) }; parameters[0].Value = model.PhoneNumber; parameters[1].Value = model.Code; parameters[2].Value = model.Type; parameters[3].Value = model.CreateTime; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_store_business model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_store_business("); strSql.Append("StoreId,BusinessId,ParentId,RoleId,State)"); strSql.Append(" values ("); strSql.Append("@StoreId,@BusinessId,@ParentId,@RoleId,@State)"); MySqlParameter[] parameters = { new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@BusinessId", MySqlDbType.Int32, 11), new MySqlParameter("@ParentId", MySqlDbType.Int32, 11), new MySqlParameter("@RoleId", MySqlDbType.Int16, 4), new MySqlParameter("@State", MySqlDbType.Int16, 4) }; parameters[0].Value = model.StoreId; parameters[1].Value = model.BusinessId; parameters[2].Value = model.ParentId; parameters[3].Value = model.RoleId; parameters[4].Value = model.State; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_particulars model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_particulars set "); strSql.Append("Title=@Title,"); strSql.Append("TextContent=@TextContent,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@Title", MySqlDbType.VarChar, 128), new MySqlParameter("@TextContent", MySqlDbType.Text), new MySqlParameter("@CreateTime", MySqlDbType.DateTime), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.Title; parameters[1].Value = model.TextContent; parameters[2].Value = model.CreateTime; parameters[3].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.dt_manager_log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_manager_log("); strSql.Append("user_id,user_name,action_type,remark,user_ip,add_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@action_type,@remark,@user_ip,@add_time)"); MySqlParameter[] parameters = { new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_name", MySqlDbType.VarChar, 100), new MySqlParameter("@action_type", MySqlDbType.VarChar, 100), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@user_ip", MySqlDbType.VarChar, 30), new MySqlParameter("@add_time", MySqlDbType.DateTime) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.action_type; parameters[3].Value = model.remark; parameters[4].Value = model.user_ip; parameters[5].Value = model.add_time; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 修改一条记录,带事务 /// </summary> public bool Update(MySqlConnection conn, MySqlTransaction trans, string old_name, int parent_id, string nav_name, string title, int sort_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "navigation set"); strSql.Append(" parent_id=@parent_id,"); strSql.Append(" name=@name,"); strSql.Append(" title=@title,"); strSql.Append(" sort_id=@sort_id"); strSql.Append(" where name=@old_name"); MySqlParameter[] parameters = { new MySqlParameter("@parent_id", MySqlDbType.Int32, 4), new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@title", MySqlDbType.VarChar, 100), new MySqlParameter("@sort_id", MySqlDbType.Int32, 4), new MySqlParameter("@old_name", MySqlDbType.VarChar, 50) }; parameters[0].Value = parent_id; parameters[1].Value = nav_name; parameters[2].Value = title; parameters[3].Value = sort_id; parameters[4].Value = old_name; int rows = DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_payment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_payment("); strSql.Append("PaymentNo,CustomerId,GoodsId,PaymentTime,Money,State)"); strSql.Append(" values ("); strSql.Append("@PaymentNo,@CustomerId,@GoodsId,@PaymentTime,@Money,@State)"); MySqlParameter[] parameters = { new MySqlParameter("@PaymentNo", MySqlDbType.VarChar, 50), new MySqlParameter("@CustomerId", MySqlDbType.Int32, 11), new MySqlParameter("@GoodsId", MySqlDbType.Int32, 11), new MySqlParameter("@PaymentTime", MySqlDbType.DateTime), new MySqlParameter("@Money", MySqlDbType.Decimal, 10), new MySqlParameter("@State", MySqlDbType.Int16, 4) }; parameters[0].Value = model.PaymentNo; parameters[1].Value = model.CustomerId; parameters[2].Value = model.GoodsId; parameters[3].Value = model.PaymentTime; parameters[4].Value = model.Money; parameters[5].Value = model.State; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.dt_manager_role model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_manager_role("); strSql.Append("role_name,role_type,is_sys)"); strSql.Append(" values ("); strSql.Append("@role_name,@role_type,@is_sys)"); MySqlParameter[] parameters = { new MySqlParameter("@role_name", MySqlDbType.VarChar, 100), new MySqlParameter("@role_type", MySqlDbType.Int16, 4), new MySqlParameter("@is_sys", MySqlDbType.Int16, 4) }; parameters[0].Value = model.role_name; parameters[1].Value = model.role_type; parameters[2].Value = model.is_sys; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_bannerimage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_bannerimage set "); strSql.Append("BannerTitle=@BannerTitle,"); strSql.Append("ClickStatus=@ClickStatus,"); strSql.Append("ImgUrl=@ImgUrl,"); strSql.Append("ClickTrunOnUrl=@ClickTrunOnUrl,"); strSql.Append("UpOnLineTime=@UpOnLineTime,"); strSql.Append("DownOnLimeTime=@DownOnLimeTime,"); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("DeleterUserId=@DeleterUserId,"); strSql.Append("LastModificationTime=@LastModificationTime,"); strSql.Append("LastModifierUserId=@LastModifierUserId,"); strSql.Append("CreationTime=@CreationTime,"); strSql.Append("CreatorUserId=@CreatorUserId"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@BannerTitle", MySqlDbType.VarChar, 256), new MySqlParameter("@ClickStatus", MySqlDbType.Int32, 11), new MySqlParameter("@ImgUrl", MySqlDbType.VarChar, 2048), new MySqlParameter("@ClickTrunOnUrl", MySqlDbType.VarChar, 2048), new MySqlParameter("@UpOnLineTime", MySqlDbType.DateTime), new MySqlParameter("@DownOnLimeTime", MySqlDbType.DateTime), new MySqlParameter("@IsDeleted", MySqlDbType.Int32), new MySqlParameter("@DeleterUserId", MySqlDbType.Int32), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int32), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int32), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.BannerTitle; parameters[1].Value = model.ClickStatus; parameters[2].Value = model.ImgUrl; parameters[3].Value = model.ClickTrunOnUrl; parameters[4].Value = model.UpOnLineTime; parameters[5].Value = model.DownOnLimeTime; parameters[6].Value = model.IsDeleted; parameters[7].Value = model.DeleterUserId; parameters[8].Value = model.LastModificationTime; parameters[9].Value = model.LastModifierUserId; parameters[10].Value = model.CreationTime; parameters[11].Value = model.CreatorUserId; parameters[12].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.navigation model) { using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString)) { conn.Open(); using (MySqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "navigation("); strSql.Append("parent_id,channel_id,nav_type,name,title,sub_title,icon_url,link_url,sort_id,is_lock,remark,action_type,is_sys)"); strSql.Append(" values ("); strSql.Append("@parent_id,@channel_id,@nav_type,@name,@title,@sub_title,@icon_url,@link_url,@sort_id,@is_lock,@remark,@action_type,@is_sys)"); MySqlParameter[] parameters = { new MySqlParameter("@parent_id", MySqlDbType.Int32, 4), new MySqlParameter("@channel_id", MySqlDbType.Int32, 4), new MySqlParameter("@nav_type", MySqlDbType.VarChar, 50), new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@title", MySqlDbType.VarChar, 100), new MySqlParameter("@sub_title", MySqlDbType.VarChar, 100), new MySqlParameter("@icon_url", MySqlDbType.VarChar, 255), new MySqlParameter("@link_url", MySqlDbType.VarChar, 255), new MySqlParameter("@sort_id", MySqlDbType.Int32, 4), new MySqlParameter("@is_lock", MySqlDbType.Int32, 4), new MySqlParameter("@remark", MySqlDbType.VarChar, 500), new MySqlParameter("@action_type", MySqlDbType.VarChar, 500), new MySqlParameter("@is_sys", MySqlDbType.Int32, 4) }; parameters[0].Value = model.parent_id; parameters[1].Value = model.channel_id; parameters[2].Value = model.nav_type; parameters[3].Value = model.name; parameters[4].Value = model.title; parameters[5].Value = model.sub_title; parameters[6].Value = model.icon_url; parameters[7].Value = model.link_url; parameters[8].Value = model.sort_id; parameters[9].Value = model.is_lock; parameters[10].Value = model.remark; parameters[11].Value = model.action_type; parameters[12].Value = model.is_sys; DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID model.id = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(model.id); }
///// <summary> ///// 删除7天前的日志数据 ///// </summary> public int Delete(int dayCount) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "manager_log "); strSql.Append(" where DATEDIFF(now(),add_time) > " + dayCount); return(DbHelperMySql.ExecuteSql(strSql.ToString())); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_service_evaluation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_service_evaluation set "); strSql.Append("StoreId=@StoreId,"); strSql.Append("CustomerId=@CustomerId,"); strSql.Append("BusinessId=@BusinessId,"); strSql.Append("EvaluateTime=@EvaluateTime,"); strSql.Append("Score=@Score,"); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("DeleterUserId=@DeleterUserId,"); strSql.Append("LastModificationTime=@LastModificationTime,"); strSql.Append("LastModifierUserId=@LastModifierUserId,"); strSql.Append("CreationTime=@CreationTime,"); strSql.Append("CreatorUserId=@CreatorUserId"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@CustomerId", MySqlDbType.Int32, 11), new MySqlParameter("@BusinessId", MySqlDbType.Int32, 11), new MySqlParameter("@EvaluateTime", MySqlDbType.DateTime), new MySqlParameter("@Score", MySqlDbType.Int16, 4), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int64, 20), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.StoreId; parameters[1].Value = model.CustomerId; parameters[2].Value = model.BusinessId; parameters[3].Value = model.EvaluateTime; parameters[4].Value = model.Score; parameters[5].Value = model.IsDeleted; parameters[6].Value = model.DeleterUserId; parameters[7].Value = model.LastModificationTime; parameters[8].Value = model.LastModifierUserId; parameters[9].Value = model.CreationTime; parameters[10].Value = model.CreatorUserId; parameters[11].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_store model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_store("); strSql.Append("ApplyOpenId,StoreName,PhoneNumber,StoreImgUrl,Area,City,Province,Address,State,Score,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,PlanId)"); strSql.Append(" values ("); strSql.Append("@ApplyOpenId,@StoreName,@PhoneNumber,@StoreImgUrl,@Area,@City,@Province,@Address,@State,@Score,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime,@PlanId)"); MySqlParameter[] parameters = { new MySqlParameter("@ApplyOpenId", MySqlDbType.LongText), new MySqlParameter("@StoreName", MySqlDbType.VarChar, 50), new MySqlParameter("@PhoneNumber", MySqlDbType.VarChar, 20), new MySqlParameter("@StoreImgUrl", MySqlDbType.LongText), new MySqlParameter("@Area", MySqlDbType.LongText), new MySqlParameter("@City", MySqlDbType.LongText), new MySqlParameter("@Province", MySqlDbType.LongText), new MySqlParameter("@Address", MySqlDbType.LongText), new MySqlParameter("@State", MySqlDbType.Int16, 4), new MySqlParameter("@Score", MySqlDbType.Float), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@PlanId", MySqlDbType.Int16, 4) }; parameters[0].Value = model.ApplyOpenId; parameters[1].Value = model.StoreName; parameters[2].Value = model.PhoneNumber; parameters[3].Value = model.StoreImgUrl; parameters[4].Value = model.Area; parameters[5].Value = model.City; parameters[6].Value = model.Province; parameters[7].Value = model.Address; parameters[8].Value = model.State; parameters[9].Value = model.Score; parameters[10].Value = model.IsDeleted; parameters[11].Value = model.DeleterUserId; parameters[12].Value = model.LastModificationTime; parameters[13].Value = model.LastModifierUserId; parameters[14].Value = model.CreationTime; parameters[15].Value = model.PlanId == 0 ? null : model.PlanId; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.manager model) { int newId; using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString)) { conn.Open(); using (MySqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "manager("); strSql.Append("role_id,role_type,user_name,password,salt,real_name,telephone,email,is_lock,add_time)"); strSql.Append(" values ("); strSql.Append("@role_id,@role_type,@user_name,@password,@salt,@real_name,@telephone,@email,@is_lock,@add_time)"); MySqlParameter[] parameters = { new MySqlParameter("@role_id", MySqlDbType.Int32, 4), new MySqlParameter("@role_type", MySqlDbType.Int32, 4), new MySqlParameter("@user_name", MySqlDbType.VarChar, 100), new MySqlParameter("@password", MySqlDbType.VarChar, 100), new MySqlParameter("@salt", MySqlDbType.VarChar, 20), new MySqlParameter("@real_name", MySqlDbType.VarChar, 50), new MySqlParameter("@telephone", MySqlDbType.VarChar, 30), new MySqlParameter("@email", MySqlDbType.VarChar, 30), new MySqlParameter("@is_lock", MySqlDbType.Int32, 4), new MySqlParameter("@add_time", MySqlDbType.Date) }; parameters[0].Value = model.role_id; parameters[1].Value = model.role_type; parameters[2].Value = model.user_name; parameters[3].Value = model.password; parameters[4].Value = model.salt; parameters[5].Value = model.real_name; parameters[6].Value = model.telephone; parameters[7].Value = model.email; parameters[8].Value = model.is_lock; parameters[9].Value = model.add_time; DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(newId); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.dt_manager model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_manager set "); strSql.Append("role_id=@role_id,"); strSql.Append("role_type=@role_type,"); strSql.Append("user_name=@user_name,"); strSql.Append("password=@password,"); strSql.Append("salt=@salt,"); strSql.Append("real_name=@real_name,"); strSql.Append("telephone=@telephone,"); strSql.Append("email=@email,"); strSql.Append("is_lock=@is_lock,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@role_id", MySqlDbType.Int32, 11), new MySqlParameter("@role_type", MySqlDbType.Int32, 11), new MySqlParameter("@user_name", MySqlDbType.VarChar, 100), new MySqlParameter("@password", MySqlDbType.VarChar, 100), new MySqlParameter("@salt", MySqlDbType.VarChar, 20), new MySqlParameter("@real_name", MySqlDbType.VarChar, 50), new MySqlParameter("@telephone", MySqlDbType.VarChar, 30), new MySqlParameter("@email", MySqlDbType.VarChar, 30), new MySqlParameter("@is_lock", MySqlDbType.Int32, 11), new MySqlParameter("@add_time", MySqlDbType.DateTime), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.role_id; parameters[1].Value = model.role_type; parameters[2].Value = model.user_name; parameters[3].Value = model.password; parameters[4].Value = model.salt; parameters[5].Value = model.real_name; parameters[6].Value = model.telephone; parameters[7].Value = model.email; parameters[8].Value = model.is_lock; parameters[9].Value = model.add_time; parameters[10].Value = model.id; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_reward_goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_reward_goods set "); strSql.Append("PlanId=@PlanId,"); strSql.Append("GoodsImgUrl=@GoodsImgUrl,"); strSql.Append("GoodsName=@GoodsName,"); strSql.Append("Money=@Money,"); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("DeleterUserId=@DeleterUserId,"); strSql.Append("LastModificationTime=@LastModificationTime,"); strSql.Append("LastModifierUserId=@LastModifierUserId,"); strSql.Append("CreationTime=@CreationTime,"); strSql.Append("CreatorUserId=@CreatorUserId"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@PlanId", MySqlDbType.Int32, 11), new MySqlParameter("@GoodsImgUrl", MySqlDbType.LongText), new MySqlParameter("@GoodsName", MySqlDbType.VarChar, 50), new MySqlParameter("@Money", MySqlDbType.Decimal, 10), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int64, 20), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.PlanId; parameters[1].Value = model.GoodsImgUrl; parameters[2].Value = model.GoodsName; parameters[3].Value = model.Money; parameters[4].Value = model.IsDeleted; parameters[5].Value = model.DeleterUserId; parameters[6].Value = model.LastModificationTime; parameters[7].Value = model.LastModifierUserId; parameters[8].Value = model.CreationTime; parameters[9].Value = model.CreatorUserId; parameters[10].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_message("); strSql.Append("MessageType,StoreId,SendUserId,SendOpenId,AcceptUserId,AcceptOpenId,Content,SendTime,State,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId)"); strSql.Append(" values ("); strSql.Append("@MessageType,@StoreId,@SendUserId,@SendOpenId,@AcceptUserId,@AcceptOpenId,@Content,@SendTime,@State,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime,@CreatorUserId)"); MySqlParameter[] parameters = { new MySqlParameter("@MessageType", MySqlDbType.Int16, 4), new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@SendUserId", MySqlDbType.Int32, 11), new MySqlParameter("@SendOpenId", MySqlDbType.LongText), new MySqlParameter("@AcceptUserId", MySqlDbType.Int32, 11), new MySqlParameter("@AcceptOpenId", MySqlDbType.LongText), new MySqlParameter("@Content", MySqlDbType.LongText), new MySqlParameter("@SendTime", MySqlDbType.DateTime), new MySqlParameter("@State", MySqlDbType.Int16, 4), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int64, 20) }; parameters[0].Value = model.MessageType; parameters[1].Value = model.StoreId; parameters[2].Value = model.SendUserId; parameters[3].Value = model.SendOpenId; parameters[4].Value = model.AcceptUserId; parameters[5].Value = model.AcceptOpenId; parameters[6].Value = model.Content; parameters[7].Value = model.SendTime; parameters[8].Value = model.State; parameters[9].Value = model.IsDeleted; parameters[10].Value = model.DeleterUserId; parameters[11].Value = model.LastModificationTime; parameters[12].Value = model.LastModifierUserId; parameters[13].Value = model.CreationTime; parameters[14].Value = model.CreatorUserId; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(LingLong.Admin.Model.t_wallet model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_wallet set "); strSql.Append("StoreId=@StoreId,"); strSql.Append("OpenId=@OpenId,"); strSql.Append("Balance=@Balance,"); strSql.Append("Withdraw=@Withdraw,"); strSql.Append("IsDeleted=@IsDeleted,"); strSql.Append("DeleterUserId=@DeleterUserId,"); strSql.Append("LastModificationTime=@LastModificationTime,"); strSql.Append("LastModifierUserId=@LastModifierUserId,"); strSql.Append("CreationTime=@CreationTime,"); strSql.Append("CreatorUserId=@CreatorUserId"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@OpenId", MySqlDbType.LongText), new MySqlParameter("@Balance", MySqlDbType.Decimal, 10), new MySqlParameter("@Withdraw", MySqlDbType.Decimal, 10), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int64, 20), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.StoreId; parameters[1].Value = model.OpenId; parameters[2].Value = model.Balance; parameters[3].Value = model.Withdraw; parameters[4].Value = model.IsDeleted; parameters[5].Value = model.DeleterUserId; parameters[6].Value = model.LastModificationTime; parameters[7].Value = model.LastModifierUserId; parameters[8].Value = model.CreationTime; parameters[9].Value = model.CreatorUserId; parameters[10].Value = model.ID; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool SetStatus() { string strSql = "update t_reward_distribution set IsDefault = 0"; int rows = DbHelperMySql.ExecuteSql(strSql); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_consumption model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_consumption("); strSql.Append("RecordType,StoreId,CustomerId,BusinessId,BoxNumber,Money,ConsumeTime,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId)"); strSql.Append(" values ("); strSql.Append("@RecordType,@StoreId,@CustomerId,@BusinessId,@BoxNumber,@Money,@ConsumeTime,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime,@CreatorUserId)"); MySqlParameter[] parameters = { new MySqlParameter("@RecordType", MySqlDbType.Int16, 4), new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@CustomerId", MySqlDbType.Int32, 11), new MySqlParameter("@BusinessId", MySqlDbType.Int32, 11), new MySqlParameter("@BoxNumber", MySqlDbType.VarChar, 20), new MySqlParameter("@Money", MySqlDbType.Decimal, 10), new MySqlParameter("@ConsumeTime", MySqlDbType.DateTime), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int64, 20) }; parameters[0].Value = model.RecordType; parameters[1].Value = model.StoreId; parameters[2].Value = model.CustomerId; parameters[3].Value = model.BusinessId; parameters[4].Value = model.BoxNumber; parameters[5].Value = model.Money; parameters[6].Value = model.ConsumeTime; parameters[7].Value = model.IsDeleted; parameters[8].Value = model.DeleterUserId; parameters[9].Value = model.LastModificationTime; parameters[10].Value = model.LastModifierUserId; parameters[11].Value = model.CreationTime; parameters[12].Value = model.CreatorUserId; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_withdraw model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_withdraw("); strSql.Append("StoreId,BillNo,OpenId,WithdrawName,Withdraw,WithdrawTime,State,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId)"); strSql.Append(" values ("); strSql.Append("@StoreId,@BillNo,@OpenId,@WithdrawName,@Withdraw,@WithdrawTime,@State,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime,@CreatorUserId)"); MySqlParameter[] parameters = { new MySqlParameter("@StoreId", MySqlDbType.Int32, 11), new MySqlParameter("@BillNo", MySqlDbType.LongText), new MySqlParameter("@OpenId", MySqlDbType.LongText), new MySqlParameter("@WithdrawName", MySqlDbType.VarChar, 100), new MySqlParameter("@Withdraw", MySqlDbType.Decimal, 10), new MySqlParameter("@WithdrawTime", MySqlDbType.DateTime), new MySqlParameter("@State", MySqlDbType.Int16, 4), new MySqlParameter("@IsDeleted", MySqlDbType.Int16, 4), new MySqlParameter("@DeleterUserId", MySqlDbType.Int64, 20), new MySqlParameter("@LastModificationTime", MySqlDbType.DateTime), new MySqlParameter("@LastModifierUserId", MySqlDbType.Int64, 20), new MySqlParameter("@CreationTime", MySqlDbType.DateTime), new MySqlParameter("@CreatorUserId", MySqlDbType.Int64, 20) }; parameters[0].Value = model.StoreId; parameters[1].Value = model.BillNo; parameters[2].Value = model.OpenId; parameters[3].Value = model.WithdrawName; parameters[4].Value = model.Withdraw; parameters[5].Value = model.WithdrawTime; parameters[6].Value = model.State; parameters[7].Value = model.IsDeleted; parameters[8].Value = model.DeleterUserId; parameters[9].Value = model.LastModificationTime; parameters[10].Value = model.LastModifierUserId; parameters[11].Value = model.CreationTime; parameters[12].Value = model.CreatorUserId; int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }