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