/// <summary>
/// 获取记录总数
/// </summary>
public int GetRecordCount(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) FROM t_business ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
object obj = DbHelperMySql.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据用户名取得Salt
/// </summary>
public string GetSalt(string user_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select salt from " + databaseprefix + "manager");
strSql.Append(" where user_name=@user_name");
strSql.Append(" limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_name", MySqlDbType.VarChar, 100)
};
parameters[0].Value = user_name;
string salt = Convert.ToString(DbHelperMySql.GetSingle(strSql.ToString(), parameters));
if (string.IsNullOrEmpty(salt))
{
return("");
}
return(salt);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LingLong.Admin.Model.t_reward_detail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_reward_detail set ");
strSql.Append("RewardId=@RewardId,");
strSql.Append("OpenrId=@OpenrId,");
strSql.Append("DistributionRatio=@DistributionRatio,");
strSql.Append("UserType=@UserType,");
strSql.Append("RewardMoney=@RewardMoney,");
strSql.Append("BenefitMoney=@BenefitMoney");
strSql.Append(" where ID=@ID");
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),
new MySqlParameter("@ID", MySqlDbType.Int32, 11)
};
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;
parameters[6].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_reward_plan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_reward_plan(");
strSql.Append("PlanName,IsDefault,IsUse,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId)");
strSql.Append(" values (");
strSql.Append("@PlanName,@IsDefault,@IsUse,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime,@CreatorUserId)");
MySqlParameter[] parameters =
{
new MySqlParameter("@PlanName", MySqlDbType.VarChar, 50),
new MySqlParameter("@IsDefault", MySqlDbType.Int16, 4),
new MySqlParameter("@IsUse", 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.PlanName;
parameters[1].Value = model.IsDefault;
parameters[2].Value = model.IsUse;
parameters[3].Value = model.IsDeleted;
parameters[4].Value = model.DeleterUserId;
parameters[5].Value = model.LastModificationTime;
parameters[6].Value = model.LastModifierUserId;
parameters[7].Value = model.CreationTime;
parameters[8].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.dt_manager_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_manager_log set ");
strSql.Append("user_id=@user_id,");
strSql.Append("user_name=@user_name,");
strSql.Append("action_type=@action_type,");
strSql.Append("remark=@remark,");
strSql.Append("user_ip=@user_ip,");
strSql.Append("add_time=@add_time");
strSql.Append(" where id=@id");
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),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
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;
parameters[6].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_payment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_payment set ");
strSql.Append("PaymentNo=@PaymentNo,");
strSql.Append("CustomerId=@CustomerId,");
strSql.Append("GoodsId=@GoodsId,");
strSql.Append("PaymentTime=@PaymentTime,");
strSql.Append("Money=@Money,");
strSql.Append("State=@State");
strSql.Append(" where ID=@ID");
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),
new MySqlParameter("@ID", MySqlDbType.Int32, 11)
};
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;
parameters[6].Value = model.ID;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据用户名密码返回一个实体
/// </summary>
public Model.manager GetModel(string user_name, string password)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id from " + databaseprefix + "manager");
strSql.Append(" where user_name=@user_name and password=@password and is_lock=0");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_name", MySqlDbType.VarChar, 100),
new MySqlParameter("@password", MySqlDbType.VarChar, 100)
};
parameters[0].Value = user_name;
parameters[1].Value = password;
object obj = DbHelperMySql.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
return(GetModel(Convert.ToInt32(obj)));
}
return(null);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(LingLong.Admin.Model.t_templatemessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_templatemessage(");
strSql.Append("Type,OpenId,Message,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime)");
strSql.Append(" values (");
strSql.Append("@Type,@OpenId,@Message,@IsDeleted,@DeleterUserId,@LastModificationTime,@LastModifierUserId,@CreationTime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Type", MySqlDbType.Int16, 4),
new MySqlParameter("@OpenId", MySqlDbType.LongText),
new MySqlParameter("@Message", MySqlDbType.LongText),
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)
};
parameters[0].Value = model.Type;
parameters[1].Value = model.OpenId;
parameters[2].Value = model.Message;
parameters[3].Value = model.IsDeleted;
parameters[4].Value = model.DeleterUserId;
parameters[5].Value = model.LastModificationTime;
parameters[6].Value = model.LastModifierUserId;
parameters[7].Value = model.CreationTime;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 快捷添加系统默认导航，带事务
/// </summary>
public int Add(MySqlConnection conn, MySqlTransaction trans, string parent_name, string nav_name, string title, string link_url, int sort_id, int channel_id, string action_type)
{
//先根据名称查询该父ID
StringBuilder strSql = new StringBuilder();
strSql.Append("select id from " + databaseprefix + "navigation");
strSql.Append(" where name=@parent_name limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@parent_name", MySqlDbType.VarChar, 50)
};
parameters[0].Value = parent_name;
object obj = DbHelperMySql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
int parent_id = Convert.ToInt32(obj);
return(Add(conn, trans, parent_id, nav_name, title, link_url, sort_id, channel_id, action_type));
}
/// <summary>
/// 删除一条数据，及子表所有相关数据
/// </summary>
public bool Delete(int id)
{
Hashtable sqllist = new Hashtable();
//删除管理角色权限
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "manager_role_value ");
strSql.Append(" where role_id=@role_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@role_id", MySqlDbType.Int32, 4)
};
parameters[0].Value = id;
sqllist.Add(strSql.ToString(), parameters);
//删除管理角色
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "manager_role ");
strSql2.Append(" where id=@id");
MySqlParameter[] parameters2 =
{
new MySqlParameter("@id", MySqlDbType.Int32, 4)
};
parameters2[0].Value = id;
sqllist.Add(strSql2.ToString(), parameters2);
bool result = DbHelperMySql.ExecuteSqlTran(sqllist);
if (result)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取类别列表
/// </summary>
/// <param name="parent_id">父ID</param>
/// <param name="nav_type">导航类别</param>
/// <returns>DataTable</returns>
public DataTable GetList(int parent_id, string nav_type)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,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(" FROM " + databaseprefix + "navigation");
strSql.Append(" where nav_type='" + nav_type + "'");
strSql.Append(" order by sort_id asc,id desc");
DataSet ds = DbHelperMySql.Query(strSql.ToString());
//重组列表
DataTable oldData = ds.Tables[0] as DataTable;
if (oldData == null)
{
return(null);
}
//创建一个新的DataTable增加一个深度字段
DataTable newData = new DataTable();
newData.Columns.Add("id", typeof(int));
newData.Columns.Add("parent_id", typeof(int));
newData.Columns.Add("channel_id", typeof(int));
newData.Columns.Add("class_layer", typeof(int));
newData.Columns.Add("nav_type", typeof(string));
newData.Columns.Add("name", typeof(string));
newData.Columns.Add("title", typeof(string));
newData.Columns.Add("sub_title", typeof(string));
newData.Columns.Add("icon_url", typeof(string));
newData.Columns.Add("link_url", typeof(string));
newData.Columns.Add("sort_id", typeof(int));
newData.Columns.Add("is_lock", typeof(int));
newData.Columns.Add("remark", typeof(string));
newData.Columns.Add("action_type", typeof(string));
newData.Columns.Add("is_sys", typeof(int));
//调用迭代组合成DAGATABLE
GetChilds(oldData, newData, parent_id, 0);
return(newData);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LingLong.Admin.Model.t_store_business model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_store_business set ");
strSql.Append("StoreId=@StoreId,");
strSql.Append("BusinessId=@BusinessId,");
strSql.Append("ParentId=@ParentId,");
strSql.Append("RoleId=@RoleId,");
strSql.Append("State=@State");
strSql.Append(" where ID=@ID");
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),
new MySqlParameter("@ID", MySqlDbType.Int32, 11)
};
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;
parameters[5].Value = model.ID;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby);
}
else
{
strSql.Append("order by T.ID desc");
}
strSql.Append(")AS Row, T.* from t_checkcode T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <summary>
/// 删除一条数据，带事务
/// </summary>
public bool Delete(MySqlConnection conn, MySqlTransaction trans, string nav_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "navigation");
strSql.Append(" where name=@name");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar, 50)
};
parameters[0].Value = nav_name;
int rows = DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from t_checkcode ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from dt_manager_role_value ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
int rows = DbHelperMySql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.dt_manager_role_value GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,role_id,nav_name,action_type from dt_manager_role_value ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
LingLong.Admin.Model.dt_manager_role_value model = new LingLong.Admin.Model.dt_manager_role_value();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_service_evaluation GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,StoreId,CustomerId,BusinessId,EvaluateTime,Score,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_service_evaluation ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_service_evaluation model = new LingLong.Admin.Model.t_service_evaluation();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_agent_store GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,AgentId,StoreId from t_agent_store ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_agent_store model = new LingLong.Admin.Model.t_agent_store();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_bannerimage GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,BannerTitle,ClickStatus,ImgUrl,ClickTrunOnUrl,UpOnLineTime,DownOnLimeTime,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_bannerimage ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_bannerimage model = new LingLong.Admin.Model.t_bannerimage();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_wallet GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,StoreId,OpenId,Balance,Withdraw,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_wallet ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_wallet model = new LingLong.Admin.Model.t_wallet();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_message GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,MessageType,StoreId,SendUserId,SendOpenId,AcceptUserId,AcceptOpenId,Content,SendTime,State,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_message ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_message model = new LingLong.Admin.Model.t_message();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.dt_navigation GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,parent_id,channel_id,nav_type,name,title,sub_title,icon_url,link_url,sort_id,is_lock,remark,action_type,is_sys from dt_navigation ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
LingLong.Admin.Model.dt_navigation model = new LingLong.Admin.Model.dt_navigation();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_store GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,ApplyOpenId,StoreName,PhoneNumber,StoreImgUrl,Area,City,Province,Address,State,Score,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime from t_store ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_store model = new LingLong.Admin.Model.t_store();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_reward_distribution GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,DistributionName,PlatformRatio,AgentRatio,StoreRatio,BusinessRatio,IsDefault,IsUse,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_reward_distribution ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_reward_distribution model = new LingLong.Admin.Model.t_reward_distribution();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_business GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,TrueName,Nickname,Gender,AvatarUrl,OpenId,UnionId,PhoneNumber,AppId,City,Province,Country,NativePlace,Height,Birthday,RegisterTime,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_business ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_business model = new LingLong.Admin.Model.t_business();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_reward_detail GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,RewardId,OpenrId,DistributionRatio,UserType,RewardMoney,BenefitMoney from t_reward_detail ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_reward_detail model = new LingLong.Admin.Model.t_reward_detail();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_checkcode GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PhoneNumber,Code,Type,CreateTime from t_checkcode ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_checkcode model = new LingLong.Admin.Model.t_checkcode();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LingLong.Admin.Model.t_particulars GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Title,TextContent,CreateTime from t_particulars ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_particulars model = new LingLong.Admin.Model.t_particulars();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得查询分页数据
/// </summary>
public DataSet GetList(int pageSize, int pageIndex, string strWhere, string filedOrder, out int recordCount)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"SELECT
a.*,
CASE
b.Nickname
WHEN NULL THEN
b.TrueName ELSE b.Nickname
END AS CustomerName,
CASE
c.TrueName
WHEN NULL THEN
c.Nickname ELSE c.TrueName
END AS BusinessName,
d.StoreName,
CASE
f.TrueName
WHEN NULL THEN
f.Nickname ELSE f.TrueName
END AS AgentName
FROM
t_reward a
LEFT JOIN t_customer b ON a.CustomerId = b.ID
LEFT JOIN t_business c ON a.BusinessId = c.ID
LEFT JOIN t_store d ON a.StoreId = d.ID
LEFT JOIN t_agent_store e ON d.ID = e.StoreId
LEFT JOIN t_agent f ON e.AgentId = f.ID " );
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
recordCount = Convert.ToInt32(DbHelperMySql.GetSingle(PagingHelper.CreateCountingSql(strSql.ToString())));
return(DbHelperMySql.Query(PagingHelper.CreatePagingSql(recordCount, pageSize, pageIndex, strSql.ToString(), filedOrder)));
}
