/// <summary>
/// 根据查询条件得到Memberlevel记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="MemberlevelQueryEntity">Memberlevel查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Memberlevel记录</returns>
public DataSet GetMemberlevelByQueryList(Database db, DbTransaction tran, QueryEntity memberlevelQuery)
{
string temp = SQL_SELECT_ALL_MEMBERLEVEL;
if (memberlevelQuery != null && memberlevelQuery.sqlWhere != null && memberlevelQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < memberlevelQuery.sqlWhere.Count; i++)
{
temp += " AND " + memberlevelQuery.sqlWhere[i];
}
}
if (!memberlevelQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, memberlevelQuery.CurrentPage, memberlevelQuery.PageSize, memberlevelQuery.SortField, memberlevelQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Item记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="ItemQueryEntity">Item查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Item记录</returns>
public DataSet GetItemByQueryList(Database db, DbTransaction tran, QueryEntity itemQuery)
{
string temp = SQL_SELECT_ALL_ITEM;
if (itemQuery != null && itemQuery.sqlWhere != null && itemQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < itemQuery.sqlWhere.Count; i++)
{
temp += " AND " + itemQuery.sqlWhere[i];
}
}
if (!itemQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, itemQuery.CurrentPage, itemQuery.PageSize, itemQuery.SortField, itemQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Usersupplier记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="UsersupplierQueryEntity">Usersupplier查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Usersupplier记录</returns>
public DataSet GetUsersupplierByQueryList(Database db, DbTransaction tran, QueryEntity usersupplierQuery)
{
string temp = SQL_SELECT_ALL_USERSUPPLIER;
if (usersupplierQuery != null && usersupplierQuery.sqlWhere != null && usersupplierQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < usersupplierQuery.sqlWhere.Count; i++)
{
temp += " AND " + usersupplierQuery.sqlWhere[i];
}
}
if (!usersupplierQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, usersupplierQuery.CurrentPage, usersupplierQuery.PageSize, usersupplierQuery.SortField, usersupplierQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Operationlog记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="OperationlogQueryEntity">Operationlog查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Operationlog记录</returns>
public DataSet GetOperationlogByQueryList(Database db, DbTransaction tran, QueryEntity operationlogQuery)
{
string temp = SQL_SELECT_ALL_OPERATIONLOG;
if (operationlogQuery != null && operationlogQuery.sqlWhere != null && operationlogQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < operationlogQuery.sqlWhere.Count; i++)
{
temp += " AND " + operationlogQuery.sqlWhere[i];
}
}
if (!operationlogQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, operationlogQuery.CurrentPage, operationlogQuery.PageSize, operationlogQuery.SortField, operationlogQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Syssetting记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="SyssettingQueryEntity">Syssetting查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Syssetting记录</returns>
public DataSet GetSyssettingByQueryList(Database db, DbTransaction tran, QueryEntity syssettingQuery)
{
string temp = SQL_SELECT_ALL_SYSSETTING;
if (syssettingQuery != null && syssettingQuery.sqlWhere != null && syssettingQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < syssettingQuery.sqlWhere.Count; i++)
{
temp += " AND " + syssettingQuery.sqlWhere[i];
}
}
if (!syssettingQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, syssettingQuery.CurrentPage, syssettingQuery.PageSize, syssettingQuery.SortField, syssettingQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Purchaseorderdetail记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="PurchaseorderdetailQueryEntity">Purchaseorderdetail查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Purchaseorderdetail记录</returns>
public DataSet GetPurchaseorderdetailByQueryList(Database db, DbTransaction tran, QueryEntity purchaseorderdetailQuery)
{
string temp = SQL_SELECT_ALL_PURCHASEORDERDETAIL;
if (purchaseorderdetailQuery != null && purchaseorderdetailQuery.sqlWhere != null && purchaseorderdetailQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < purchaseorderdetailQuery.sqlWhere.Count; i++)
{
temp += " AND " + purchaseorderdetailQuery.sqlWhere[i];
}
}
if (!purchaseorderdetailQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, purchaseorderdetailQuery.CurrentPage, purchaseorderdetailQuery.PageSize, purchaseorderdetailQuery.SortField, purchaseorderdetailQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Rolefunction记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="RolefunctionQueryEntity">Rolefunction查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Rolefunction记录</returns>
public DataSet GetRolefunctionByQueryList(Database db, DbTransaction tran, QueryEntity rolefunctionQuery)
{
string temp = SQL_SELECT_ALL_ROLEFUNCTION;
if (rolefunctionQuery != null && rolefunctionQuery.sqlWhere != null && rolefunctionQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < rolefunctionQuery.sqlWhere.Count; i++)
{
temp += " AND " + rolefunctionQuery.sqlWhere[i];
}
}
if (!rolefunctionQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, rolefunctionQuery.CurrentPage, rolefunctionQuery.PageSize, rolefunctionQuery.SortField, rolefunctionQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Functiongroup记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="FunctiongroupQueryEntity">Functiongroup查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Functiongroup记录</returns>
public DataSet GetFunctiongroupByQueryList(Database db, DbTransaction tran, QueryEntity functiongroupQuery)
{
string temp = SQL_SELECT_ALL_FUNCTIONGROUP;
if (functiongroupQuery != null && functiongroupQuery.sqlWhere != null && functiongroupQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < functiongroupQuery.sqlWhere.Count; i++)
{
temp += " AND " + functiongroupQuery.sqlWhere[i];
}
}
if (!functiongroupQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, functiongroupQuery.CurrentPage, functiongroupQuery.PageSize, functiongroupQuery.SortField, functiongroupQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Membercomment记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="MembercommentQueryEntity">Membercomment查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Membercomment记录</returns>
public DataSet GetMembercommentByQueryList(QueryEntity membercommentQuery)
{
string temp = SQL_SELECT_ALL_MEMBERCOMMENT;
if (membercommentQuery != null && membercommentQuery.sqlWhere != null && membercommentQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < membercommentQuery.sqlWhere.Count; i++)
{
temp += " AND " + membercommentQuery.sqlWhere[i];
}
}
if (!membercommentQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, membercommentQuery.CurrentPage, membercommentQuery.PageSize, membercommentQuery.SortField, membercommentQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Area记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="AreaQueryEntity">Area查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Area记录</returns>
public DataSet GetAreaByQueryList(QueryEntity areaQuery)
{
string temp = SQL_SELECT_ALL_AREA;
if (areaQuery != null && areaQuery.sqlWhere != null && areaQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < areaQuery.sqlWhere.Count; i++)
{
temp += " AND " + areaQuery.sqlWhere[i];
}
}
if (!areaQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, areaQuery.CurrentPage, areaQuery.PageSize, areaQuery.SortField, areaQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Userrole记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="UserroleQueryEntity">Userrole查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Userrole记录</returns>
public DataSet GetUserroleByQueryList(QueryEntity userroleQuery)
{
string temp = SQL_SELECT_ALL_USERROLE;
if (userroleQuery != null && userroleQuery.sqlWhere != null && userroleQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < userroleQuery.sqlWhere.Count; i++)
{
temp += " AND " + userroleQuery.sqlWhere[i];
}
}
if (!userroleQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, userroleQuery.CurrentPage, userroleQuery.PageSize, userroleQuery.SortField, userroleQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Supplier记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="SupplierQueryEntity">Supplier查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Supplier记录</returns>
public DataSet GetSupplierByQueryList(QueryEntity supplierQuery)
{
string temp = SQL_SELECT_ALL_SUPPLIER;
if (supplierQuery != null && supplierQuery.sqlWhere != null && supplierQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < supplierQuery.sqlWhere.Count; i++)
{
temp += " AND " + supplierQuery.sqlWhere[i];
}
}
if (!supplierQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, supplierQuery.CurrentPage, supplierQuery.PageSize, supplierQuery.SortField, supplierQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Salesorderdetail记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="SalesorderdetailQueryEntity">Salesorderdetail查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Salesorderdetail记录</returns>
public DataSet GetSalesorderdetailByQueryList(QueryEntity salesorderdetailQuery)
{
string temp = SQL_SELECT_ALL_SALESORDERDETAIL;
if (salesorderdetailQuery != null && salesorderdetailQuery.sqlWhere != null && salesorderdetailQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < salesorderdetailQuery.sqlWhere.Count; i++)
{
temp += " AND " + salesorderdetailQuery.sqlWhere[i];
}
}
if (!salesorderdetailQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, salesorderdetailQuery.CurrentPage, salesorderdetailQuery.PageSize, salesorderdetailQuery.SortField, salesorderdetailQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(CommandType.Text, temp));
}
/// <summary>
/// 根据查询条件得到Invtransaction记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="InvtransactionQueryEntity">Invtransaction查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Invtransaction记录</returns>
public DataSet GetInvtransactionByQueryList(QueryEntity invtransactionQuery)
{
string temp = SQL_SELECT_ALL_INVTRANSACTION;
if (invtransactionQuery != null && invtransactionQuery.sqlWhere != null && invtransactionQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < invtransactionQuery.sqlWhere.Count; i++)
{
temp += " AND " + invtransactionQuery.sqlWhere[i];
}
}
if (!invtransactionQuery.IsGetAll)
{
temp = PagingHelper.GetPagingSQL(temp, invtransactionQuery.CurrentPage, invtransactionQuery.PageSize, invtransactionQuery.SortField, invtransactionQuery.SortDirection);
}
return(DBHelper.ExecuteDataSet(CommandType.Text, temp));
}