/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PaymentNo,CustomerId,GoodsId,PaymentTime,Money,State ");
strSql.Append(" FROM t_payment ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,IsManage,TrueName,AgentCode,Nickname,Gender,AvatarUrl,PhoneNumber,OpenId,UnionId,AppId,City,Province,Country,NativePlace,Height,Birthday,RegisterTime,State,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId ");
strSql.Append(" FROM t_agent ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,BannerTitle,ClickStatus,ImgUrl,ClickTrunOnUrl,UpOnLineTime,DownOnLimeTime,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId ");
strSql.Append(" FROM t_bannerimage ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.manager GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,role_id,role_type,user_name,password,salt,real_name,telephone,email,is_lock,add_time from " + databaseprefix + "manager ");
strSql.Append(" where id=@id");
strSql.Append(" limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 4)
};
parameters[0].Value = id;
Model.manager model = new Model.manager();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["role_id"].ToString() != "")
{
model.role_id = int.Parse(ds.Tables[0].Rows[0]["role_id"].ToString());
}
if (ds.Tables[0].Rows[0]["role_type"].ToString() != "")
{
model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString());
}
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
model.password = ds.Tables[0].Rows[0]["password"].ToString();
model.salt = ds.Tables[0].Rows[0]["salt"].ToString();
model.real_name = ds.Tables[0].Rows[0]["real_name"].ToString();
model.telephone = ds.Tables[0].Rows[0]["telephone"].ToString();
model.email = ds.Tables[0].Rows[0]["email"].ToString();
if (ds.Tables[0].Rows[0]["is_lock"].ToString() != "")
{
model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString());
}
if (ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
return(model);
}
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.*,IFNULL( b.StoreNum, 0 ) AS StoreNum FROM " + @"t_agent a
LEFT JOIN(SELECT COUNT(* ) AS StoreNum, AgentId FROM t_agent_store GROUP BY AgentId) b ON a.ID = b.AgentId ");
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)));
}
/// <summary>
/// 获得查询分页数据
/// </summary>
public DataSet GetList(int pageSize, int pageIndex, string strWhere, string filedOrder, out int recordCount)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select b.*, c.StoreName, c.StoreImgUrl, CASE a.RoleId
WHEN 0 THEN '超级管理员'
WHEN 1 THEN '管理员'
WHEN 2 THEN '门店经理'
WHEN 3 THEN '服务员'END AS RoleId,a.State, a.ID r_ID FROM "
+ " t_store_business a LEFT JOIN t_business b ON a.BusinessId = b.ID LEFT JOIN t_store c ON a.StoreId = c.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)));
}
public DataSet GetListOther(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@" SELECT
a.BusinessId, b.OpenId, a.StoreId
FROM
t_store_business a
left JOIN t_business b
on a.BusinessId = b.ID
where a.State = 0 and a.RoleId = 3 and b.IsDeleted = 0 ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" id,role_id,role_type,user_name,password,salt,real_name,telephone,email,is_lock,add_time ");
strSql.Append(" FROM " + databaseprefix + "manager ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
if (Top > 0)
{
strSql.Append(" limit " + Top.ToString());
}
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" id,user_id,user_name,action_type,remark,user_ip,add_time ");
strSql.Append(" FROM " + databaseprefix + "manager_log ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
if (Top > 0)
{
strSql.Append(" limit " + Top.ToString());
}
return(DbHelperMySql.Query(strSql.ToString()));
}
/// <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 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 LingLong.Admin.Model.dt_manager GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,role_id,role_type,user_name,password,salt,real_name,telephone,email,is_lock,add_time from dt_manager ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
LingLong.Admin.Model.dt_manager model = new LingLong.Admin.Model.dt_manager();
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_reward_goods GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PlanId,GoodsImgUrl,GoodsName,Money,IsDeleted,DeleterUserId,LastModificationTime,LastModifierUserId,CreationTime,CreatorUserId from t_reward_goods ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_reward_goods model = new LingLong.Admin.Model.t_reward_goods();
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_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_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.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 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_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_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_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_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_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.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 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)));
}
/// <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_payment GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PaymentNo,CustomerId,GoodsId,PaymentTime,Money,State from t_payment ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
LingLong.Admin.Model.t_payment model = new LingLong.Admin.Model.t_payment();
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 Model.manager_role GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,role_name,role_type,is_sys from " + databaseprefix + "manager_role ");
strSql.Append(" where id=@id");
strSql.Append(" limit 1");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 4)
};
parameters[0].Value = id;
Model.manager_role model = new Model.manager_role();
DataSet ds = DbHelperMySql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region 父表信息
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.role_name = ds.Tables[0].Rows[0]["role_name"].ToString();
if (ds.Tables[0].Rows[0]["role_type"].ToString() != "")
{
model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString());
}
if (ds.Tables[0].Rows[0]["is_sys"].ToString() != "")
{
model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString());
}
#endregion
#region 子表信息
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select id,role_id,nav_name,action_type from " + databaseprefix + "manager_role_value ");
strSql2.Append(" where role_id=@role_id");
MySqlParameter[] parameters2 =
{
new MySqlParameter("@role_id", MySqlDbType.Int32, 4)
};
parameters2[0].Value = id;
DataSet ds2 = DbHelperMySql.Query(strSql2.ToString(), parameters2);
if (ds2.Tables[0].Rows.Count > 0)
{
List <Model.manager_role_value> models = new List <Model.manager_role_value>();
Model.manager_role_value modelt;
foreach (DataRow dr in ds2.Tables[0].Rows)
{
modelt = new Model.manager_role_value();
if (dr["id"].ToString() != "")
{
modelt.id = int.Parse(dr["id"].ToString());
}
if (dr["role_id"].ToString() != "")
{
modelt.role_id = int.Parse(dr["role_id"].ToString());
}
modelt.nav_name = dr["nav_name"].ToString();
modelt.action_type = dr["action_type"].ToString();
models.Add(modelt);
}
model.manager_role_values = models;
}
#endregion
return(model);
}
else
{
return(null);
}
}
