/// <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);
}
}
