/// <summary>
/// 根据查询条件得到Purchaseorderdetail记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="PurchaseorderdetailQueryEntity">Purchaseorderdetail查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Purchaseorderdetail记录</returns>
public DataSet GetPurchaseorderdetailByQueryList(QueryEntity purchaseorderdetailQuery)
{
return purchaseorderdetailDA.GetPurchaseorderdetailByQueryList(purchaseorderdetailQuery);
}
/// <summary>
/// 根据查询条件得到Itemclass记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="ItemclassQueryEntity">Itemclass查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Itemclass记录</returns>
public DataSet GetItemclassByQueryList(QueryEntity itemclassQuery)
{
return itemclassDA.GetItemclassByQueryList(itemclassQuery);
}
/// <summary>
/// 根据查询条件得到Area记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="AreaQueryEntity">Area查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Area记录</returns>
public DataSet GetAreaByQueryList(Database db, DbTransaction tran, 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(db, tran, CommandType.Text, temp);
}
/// <summary>
/// 根据查询条件得到Itemproperty记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="ItempropertyQueryEntity">Itemproperty查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Itemproperty记录</returns>
public DataSet GetItempropertyByQueryList(QueryEntity itempropertyQuery)
{
return itempropertyDA.GetItempropertyByQueryList(itempropertyQuery);
}
public DataSet GetUserByQueryList(QueryEntity userQuery)
{
throw new NotImplementedException();
}
/// <summary>
/// 根据查询条件得到Itembrand记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="ItembrandQueryEntity">Itembrand查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Itembrand记录</returns>
public DataSet GetItembrandByQueryList(QueryEntity itembrandQuery)
{
string temp = SQL_SELECT_ALL_ITEMBRAND;
if (itembrandQuery != null && itembrandQuery.sqlWhere != null && itembrandQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < itembrandQuery.sqlWhere.Count; i++)
{
temp += " AND " + itembrandQuery.sqlWhere[i];
}
}
if (!itembrandQuery.IsGetAll)
temp = PagingHelper.GetPagingSQL(temp, itembrandQuery.CurrentPage, itembrandQuery.PageSize, itembrandQuery.SortField, itembrandQuery.SortDirection);
return DBHelper.ExecuteDataSet(CommandType.Text, temp);
}
/// <summary>
/// 根据查询条件得到Inventory记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="InventoryQueryEntity">Inventory查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Inventory记录</returns>
public DataSet GetInventoryByQueryList(Database db, DbTransaction tran, QueryEntity inventoryQuery)
{
string temp = SQL_SELECT_ALL_INVENTORY;
if (inventoryQuery != null && inventoryQuery.sqlWhere != null && inventoryQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < inventoryQuery.sqlWhere.Count; i++)
{
temp += " AND " + inventoryQuery.sqlWhere[i];
}
}
if (!inventoryQuery.IsGetAll)
temp = PagingHelper.GetPagingSQL(temp, inventoryQuery.CurrentPage, inventoryQuery.PageSize, inventoryQuery.SortField, inventoryQuery.SortDirection);
return DBHelper.ExecuteDataSet(db, tran, CommandType.Text, temp);
}
/// <summary>
/// 根据查询条件得到Memberorderdetail记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="MemberorderdetailQueryEntity">Memberorderdetail查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Memberorderdetail记录</returns>
public DataSet GetMemberorderdetailByQueryList(QueryEntity memberorderdetailQuery)
{
return memberorderdetailDA.GetMemberorderdetailByQueryList(memberorderdetailQuery);
}
/// <summary>
/// 根据查询条件得到Purchaseorder记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="PurchaseorderQueryEntity">Purchaseorder查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Purchaseorder记录</returns>
public DataSet GetPurchaseorderByQueryList(QueryEntity purchaseorderQuery)
{
return purchaseorderDA.GetPurchaseorderByQueryList(purchaseorderQuery);
}
/// <summary>
/// 根据查询条件得到Userrole记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="UserroleQueryEntity">Userrole查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Userrole记录</returns>
public DataSet GetUserroleByQueryList(Database db, DbTransaction tran, 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(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)
{
return membercommentDA.GetMembercommentByQueryList(membercommentQuery);
}
/// <summary>
/// 根据查询条件得到Inventory记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="InventoryQueryEntity">Inventory查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Inventory记录</returns>
public DataSet GetInventoryByQueryList(QueryEntity inventoryQuery)
{
return inventoryDA.GetInventoryByQueryList(inventoryQuery);
}
/// <summary>
/// 根据查询条件得到Invtransaction记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="InvtransactionQueryEntity">Invtransaction查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Invtransaction记录</returns>
public DataSet GetInvtransactionByQueryList(QueryEntity invtransactionQuery)
{
return invtransactionDA.GetInvtransactionByQueryList(invtransactionQuery);
}
/// <summary>
/// 根据查询条件得到Operationlog记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="OperationlogQueryEntity">Operationlog查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Operationlog记录</returns>
public DataSet GetOperationlogByQueryList(QueryEntity operationlogQuery)
{
return operationlogDA.GetOperationlogByQueryList(operationlogQuery);
}
/// <summary>
/// 根据查询条件得到Syscode记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="SyscodeQueryEntity">Syscode查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Syscode记录</returns>
public DataSet GetSyscodeByQueryList(QueryEntity syscodeQuery)
{
string temp = SQL_SELECT_ALL_SYSCODE;
if (syscodeQuery != null && syscodeQuery.sqlWhere != null && syscodeQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < syscodeQuery.sqlWhere.Count; i++)
{
temp += " AND " + syscodeQuery.sqlWhere[i];
}
}
if (!syscodeQuery.IsGetAll)
temp = PagingHelper.GetPagingSQL(temp, syscodeQuery.CurrentPage, syscodeQuery.PageSize, syscodeQuery.SortField, syscodeQuery.SortDirection);
return DBHelper.ExecuteDataSet(CommandType.Text, temp);
}
/// <summary>
/// 根据查询条件得到Syscode记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="SyscodeQueryEntity">Syscode查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Syscode记录</returns>
public DataSet GetSyscodeByQueryList(QueryEntity syscodeQuery)
{
return syscodeDA.GetSyscodeByQueryList(syscodeQuery);
}
/// <summary>
/// 根据查询条件得到Role记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="RoleQueryEntity">Role查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Role记录</returns>
public DataSet GetRoleByQueryList(QueryEntity roleQuery)
{
string temp = SQL_SELECT_ALL_ROLE;
if (roleQuery != null && roleQuery.sqlWhere != null && roleQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < roleQuery.sqlWhere.Count; i++)
{
temp += " AND " + roleQuery.sqlWhere[i];
}
}
if (!roleQuery.IsGetAll)
temp = PagingHelper.GetPagingSQL(temp, roleQuery.CurrentPage, roleQuery.PageSize, roleQuery.SortField, roleQuery.SortDirection);
return DBHelper.ExecuteDataSet(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>
/// 根据查询条件得到Memberlevel记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="MemberlevelQueryEntity">Memberlevel查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Memberlevel记录</returns>
public DataSet GetMemberlevelByQueryList(QueryEntity memberlevelQuery)
{
return memberlevelDA.GetMemberlevelByQueryList(memberlevelQuery);
}
/// <summary>
/// 根据查询条件得到Functiongroup记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="FunctiongroupQueryEntity">Functiongroup查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Functiongroup记录</returns>
public DataSet GetFunctiongroupByQueryList(QueryEntity functiongroupQuery)
{
return functiongroupDA.GetFunctiongroupByQueryList(functiongroupQuery);
}
/// <summary>
/// 根据查询条件得到Area记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="AreaQueryEntity">Area查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Area记录</returns>
public DataSet GetAreaByQueryList(QueryEntity areaQuery)
{
return areaDA.GetAreaByQueryList(areaQuery);
}
/// <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>
/// 根据查询条件得到Member记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="MemberQueryEntity">Member查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Member记录</returns>
public DataSet GetMemberByQueryList(QueryEntity memberQuery)
{
return memberDA.GetMemberByQueryList(memberQuery);
}
/// <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);
}
public DataSet GetUserByQueryList(Database db, DbTransaction tran, QueryEntity userQuery)
{
throw new NotImplementedException();
}
/// <summary>
/// 根据查询条件得到Rolefunction记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="RolefunctionQueryEntity">Rolefunction查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Rolefunction记录</returns>
public DataSet GetRolefunctionByQueryList(QueryEntity rolefunctionQuery)
{
return rolefunctionDA.GetRolefunctionByQueryList(rolefunctionQuery);
}
/// <summary>
/// 根据查询条件得到Member记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="MemberQueryEntity">Member查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Member记录</returns>
public DataSet GetMemberByQueryList(QueryEntity memberQuery)
{
string temp = SQL_SELECT_ALL_MEMBER;
if (memberQuery != null && memberQuery.sqlWhere != null && memberQuery.sqlWhere.Count > 0)
{
for (int i = 0; i < memberQuery.sqlWhere.Count; i++)
{
temp += " AND " + memberQuery.sqlWhere[i];
}
}
if (!memberQuery.IsGetAll)
temp = PagingHelper.GetPagingSQL(temp, memberQuery.CurrentPage, memberQuery.PageSize, memberQuery.SortField, memberQuery.SortDirection);
return DBHelper.ExecuteDataSet(CommandType.Text, temp);
}
public QueryEntity InitQueryEntity()
{
QueryEntity qe = new QueryEntity();
qe.IsGetAll = false;
qe.CurrentPage = Request["page"] == null ? "1" : Request["page"];
qe.PageSize = Request["rows"] == null ? "10" : Request["rows"];
qe.SortDirection = Request["order"] == null ? "" : Request["order"];
qe.SortField = Request["sort"] == null ? "" : Request["sort"];
for (int i = 0; i < Request.Form.AllKeys.Length; i++)
{
if (Request.Form.AllKeys[i].StartsWith("Q_"))
{
if (!string.IsNullOrEmpty(Request[Request.Form.AllKeys[i]]))
{
qe.sqlWhere.Add(string.Format("{0} like '%{1}%'", Request.Form.AllKeys[i].Substring(2, Request.Form.AllKeys[i].Length - 2), Request[Request.Form.AllKeys[i]]));
}
}
}
return qe;
}
/// <summary>
/// 根据查询条件得到Salesorderdetail记录
/// </summary>
/// <param name="sqlWhere">查询条件集合</param>
/// <param name="SalesorderdetailQueryEntity">Salesorderdetail查询实体类</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>根据查询条件得到Salesorderdetail记录</returns>
public DataSet GetSalesorderdetailByQueryList(QueryEntity salesorderdetailQuery)
{
return salesorderdetailDA.GetSalesorderdetailByQueryList(salesorderdetailQuery);
}
/// <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);
}
