/// <summary>
/// 查询事务类型详细信息
/// </summary>
/// <param name="affairTypeid">事务类型编号</param>
/// <returns>标准查询返回结构</returns>
public static string affairTypeDetail(string affairTypeid)
{
string str_Select = Table.S + Common.DOT + Field.AFFAIRTYPEID + Common.SPACE + Field.AFFAIRTYPEID + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPENAME + Common.SPACE + Field.AFFAIRTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPEMODE + Common.SPACE + Field.AFFAIRTYPEMODE + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPEDES + Common.SPACE + Field.AFFAIRTYPEDES;
string str_From = Table.AFFAIRTYPE + Common.SPACE + Table.S;
string str_Where = Common.WHERE + Field.AFFAIRTYPEID + Common.EQUAL + General.addQuotes(affairTypeid);
string[] str_DicFieldList = { Field.AFFAIRTYPEMODE };
string[] str_DicNameList = { Table.DIC_AFFAIRTYPEMODE };
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.AFFAIRTYPEID,
str_DicFieldList,
str_DicNameList,
null,
1,
1,
1,
1,
0,
true,
Table.AFFAIRTYPE));
}
/// <summary>
/// 获取会员积分变更历史分页数据
/// </summary>
/// <param name="query">通用查询条件</param>
/// <returns></returns>
public Page <MemberPointHistoryModel> GetMemberPointHistoryModels(CommonQuery query)
{
Page <MemberPointHistoryModel> page = new Page <MemberPointHistoryModel>();
try
{
if (string.IsNullOrWhiteSpace(query.Name))
{
return(page);
}
StringBuilder sql = new StringBuilder();
sql.Append($"SELECT a.*,b.Name as CreateUserName FROM saas_member_point_history as a LEFT JOIN saas_employee as b on a.CreateUser=b.Id where a.Yn = '1'");
sql.Append($" and a.organSign='{CacheInfo.Drugstore.OrganSign}' and a.Guid not null and a.Guid='{query.Name}'");
int totalCount = DBService.GetInstance().GetTotalCount(string.Format("select count(*) from ({0})", sql));
sql.AppendFormat(" order by datetime(a.CreateTime) desc limit {0} offset {1};", query.PageSize, (query.PageIndex - 1) * query.PageSize);
var items = DapperHelper.SqlWithParams <MemberPointHistoryModel>(sql.ToString(), null);
if (items != null)
{
page = new Page <MemberPointHistoryModel> {
PageIndex = query.PageIndex, PageSize = query.PageSize
};
page.TotalCount = totalCount;
page.Items = new ObservableCollection <MemberPointHistoryModel>(items);
}
}
catch (Exception ex)
{
Trace.TraceError(ex.ToString());
}
return(page);
}
public static string affairTypeList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.AFFAIRTYPEID + Common.SPACE + Field.AFFAIRTYPEID + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPENAME + Common.SPACE + Field.AFFAIRTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPEMODE + Common.SPACE + Field.AFFAIRTYPEMODE + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPEDES + Common.SPACE + Field.AFFAIRTYPEDES;
string str_From = Table.AFFAIRTYPE + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.AFFAIRTYPEID,
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 获取会员
/// </summary>
/// <param name="query">通用查询条件-guid</param>
/// <returns></returns>
public Page <MemberBase> GetMembersByGuid(CommonQuery query)
{
Page <MemberBase> page = new Page <MemberBase>();
try
{
StringBuilder sql = new StringBuilder();
sql.Append($"SELECT mem.*,lev.value as priceStrategy,lev.name as vipLevelName,lev.isSpecial,pot.consumePrice,pot.point as addPerPoint,lev.discount FROM saas_Member_Base as mem LEFT JOIN (select level.*,dict.value from saas_Member_Level as level left join saas_system_dict as dict on level.priceStrategy=dict.id) as lev on mem.vipLevelId=lev.id left join (select * from saas_member_point_exchange as exch left join saas_system_dict as dict on exch.exchangeType=dict.id where dict.value='1' and exch.organSign='{CacheInfo.Drugstore.OrganSign}' and exch.Yn=1) as pot on mem.vipLevelId=pot.memberLevelId where mem.state=1 and mem.guid is not null and (date(mem.expriedTime)>=date('{DBService.GetInstance().GetSqlDateString(CacheInfo.Global.ServerTime)}') or mem.expriedTime isnull)");
if (!string.IsNullOrWhiteSpace(query.Name))
{
sql.AppendFormat(" and mem.guid ='{0}' ", query.Name);
}
sql.Append($" and mem.yn='1' and mem.organSign='{CacheInfo.Drugstore.OrganSign}' and lev.organSign='{CacheInfo.Drugstore.OrganSign}' ");
int totalCount = DBService.GetInstance().GetTotalCount(string.Format("select count(*) from ({0})", sql));
sql.AppendFormat("order by datetime(mem.CreateTime) desc limit {0} offset {1};", query.PageSize, (query.PageIndex - 1) * query.PageSize);
var items = DapperHelper.SqlWithParams <MemberBase>(sql.ToString(), null);
if (totalCount > 0 && items != null)
{
page = new Page <MemberBase> {
PageIndex = query.PageIndex, PageSize = query.PageSize
};
page.TotalCount = totalCount;
page.Items = new ObservableCollection <MemberBase>(items);
}
}
catch (Exception ex)
{
Trace.TraceError(ex.ToString());
}
return(page);
}
/// <summary>
/// 班级信息查询
/// </summary>
/// <param name="strXML"></param>
/// <returns></returns>
public static string stuClassList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
// 每页查询多少条记录
int int_PageSize = obj_Query.getIntPageSize();
// 查询第几页
int int_CurrentPage = obj_Query.getIntCurrentPage();
// 将xml分析成标准的where语句
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
string str_Select = "s.CLASSID,s.CLASSNAME";
string str_From = "STUCLASS s";
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"CLASSID ASC",
int_PageSize,
int_CurrentPage));
}
public static string eventTypeList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.EVENTTYPEID + Common.SPACE + Field.EVENTTYPEID + Common.COMMA +
Table.S + Common.DOT + Field.EVENTTYPENAME + Common.SPACE + Field.EVENTTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPENAME + Common.SPACE + Field.AFFAIRTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.BEGINEVENT + Common.SPACE + Field.BEGINEVENT + Common.COMMA +
Table.S + Common.DOT + Field.DISABLED + Common.SPACE + Field.DISABLED + Common.COMMA +
Table.S + Common.DOT + Field.SHORTCUT + Common.SPACE + Field.SHORTCUT + Common.COMMA +
Table.S + Common.DOT + Field.VISIBLE + Common.SPACE + Field.VISIBLE;
string str_From = Table.VW_EVENTTYPE + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.EVENTTYPEID,
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 查询日志列表
/// </summary>
/// <param name="strXML"></param>
/// <returns></returns>
public static string sysLogList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.LOGID + Common.SPACE + Field.LOGID + Common.COMMA +
Table.S + Common.DOT + Field.USERID + Common.SPACE + Field.USERID + Common.COMMA +
Table.S + Common.DOT + Field.USERNAME + Common.SPACE + Field.USERNAME + Common.COMMA +
Table.S + Common.DOT + Field.UNITNAME + Common.SPACE + Field.UNITNAME + Common.COMMA +
Table.S + Common.DOT + Field.LOGINIP + Common.SPACE + Field.LOGINIP + Common.COMMA +
Table.S + Common.DOT + Field.ENTERTIME + Common.SPACE + Field.ENTERTIME + Common.COMMA +
Table.S + Common.DOT + Field.LEAVETIME + Common.SPACE + Field.LEAVETIME + Common.COMMA +
Table.S + Common.DOT + Field.MAC + Common.SPACE + Field.MAC;
string str_From = Table.SYSLOG + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.LOGID + Common.SPACE + Common.S_DESC,
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 订单基本信息列表查询
/// </summary>
/// <param name="strXML"></param>
/// <returns></returns>
public static string ordersList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
// 每页查询多少条记录
int int_PageSize = obj_Query.getIntPageSize();
// 查询第几页
int int_CurrentPage = obj_Query.getIntCurrentPage();
// 将xml分析成标准的where语句
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
string str_Select = "*";
string str_From = "PIPELINE s";
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"PIPEID DESC",
int_PageSize,
int_CurrentPage));
}
public static string ErrLogList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.SQLID + Common.SPACE + Field.SQLID + Common.COMMA +
Table.S + Common.DOT + Field.APPLYDATE + Common.SPACE + Field.APPLYDATE + Common.COMMA +
Table.S + Common.DOT + Field.OBJID + Common.SPACE + Field.OBJID + Common.COMMA +
Table.S + Common.DOT + Field.ERRDES1 + Common.SPACE + Field.ERRDES1 + Common.COMMA +
Table.S + Common.DOT + Field.SQLSCRIPT + Common.SPACE + Field.SQLSCRIPT;
string str_From = Table.SQLSTORAGE + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.SQLID + Common.S_DESC,
int_PageSize,
int_CurrentPage));
}
public Pager <RoleAuthorEntity> GetRoleAuthorPageList(CommonQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager <RoleAuthorEntity> RoleAuthorPageList = clientHelper.PostAuth <Pager <RoleAuthorEntity>, CommonQuery>(GetAPIUrl(APIConstant.GETROLEAUTHORPAGELIST), query);
return(RoleAuthorPageList);
}
public static string dicList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.DICNAME + Common.SPACE + Field.DICNAME + Common.COMMA +
Table.S + Common.DOT + Field.DICDES + Common.SPACE + Field.DICDES + Common.COMMA +
Table.S + Common.DOT + Field.CODELEN + Common.SPACE + Field.CODELEN + Common.COMMA +
Table.S + Common.DOT + Field.TEXTLEN + Common.SPACE + Field.TEXTLEN + Common.COMMA +
Table.S + Common.DOT + Field.EDITABLE + Common.SPACE + Field.EDITABLE;
string str_From = Table.DICLIST + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.DICNAME,
int_PageSize,
int_CurrentPage));
}
public Pager <RoleAuthorEntity> GetRoleAuthorPageList(CommonQuery query)
{
IRoleAuthorService service = ServiceContainer.Instance.Container.Resolve <IRoleAuthorService>();
Pager <RoleAuthorEntity> pager = service.GetRoleAuthorPageList(query);
return(pager);
}
/// <summary>
/// 查询字典内容的简单列表
/// </summary>
/// <param name="strXML">标准 XML 数据信息</param>
/// <param name="strDicName">字典名称</param>
/// <returns></returns>
public static string dicDataList(string strXML, string strDicName)
{
QueryDoc obj_Query = new QueryDoc(strXML);
XmlElement ele_Condition = obj_Query.getCondition();
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.DICNAME + Common.SPACE + Field.DICNAME + Common.COMMA +
Table.S + Common.DOT + Field.DIC_CODE + Common.SPACE + Field.DIC_CODE + Common.COMMA +
Table.S + Common.DOT + Field.DIC_TEXT + Common.SPACE + Field.DIC_TEXT + Common.COMMA +
Table.S + Common.DOT + Field.DIC_VALID + Common.SPACE + Field.DIC_VALID;
string str_From = Table.DICDATA + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
str_Where = !General.empty(str_Where) ?
str_Where +
Common.SPACE + Field.DICNAME + Common.EQUAL + General.addQuotes(strDicName) :
Common.S_WHERE + Field.DICNAME + Common.EQUAL + General.addQuotes(strDicName);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.DIC_CODE,
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 用户列表查询
/// </summary>
/// <param name="strXML"></param>
/// <returns></returns>
public static string userList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.USERID + Common.SPACE + Field.USERID + Common.COMMA +
Table.S + Common.DOT + Field.USERTITLE + Common.SPACE + Field.USERTITLE + Common.COMMA +
Table.S + Common.DOT + Field.USERNAME + Common.SPACE + Field.USERNAME + Common.COMMA +
Table.S + Common.DOT + Field.SEX + Common.SPACE + Field.SEX + Common.COMMA +
Table.S + Common.DOT + Field.UNITID + Common.SPACE + Field.UNITID + Common.COMMA +
Table.S + Common.DOT + Field.UNITNAME + Common.SPACE + Field.UNITNAME + Common.COMMA +
Table.S + Common.DOT + Field.DISABLED + Common.SPACE + Field.DISABLED + Common.COMMA +
Table.S + Common.DOT + Field.CANEDITPASSWORD + Common.SPACE + Field.CANEDITPASSWORD + Common.COMMA +
Table.S + Common.DOT + Field.USERTYPE + Common.SPACE + Field.USERTYPE;
string str_From = Table.VW_USERLIST + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.USERID,
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 初始化所有字典数据，进行数据缓存
/// </summary>
private void init()
{
OleDbDataReader rst = null;
try
{
m_htb_Dic = new Hashtable();
/// 首先查询出所有字典的名称
string str_SQL = Common.SELECT + Field.DICNAME +
Common.S_FROM + Table.DICLIST;
if (CommonQuery.qryRst(str_SQL, ref rst) == "0")
{
while (rst.Read())
{
refresh(rst[Field.DICNAME].ToString());
}
}
rst.Close();
/// 载入系统特殊字典
refresh(Table.MANAGEUNIT);
refresh(Table.AFFAIRTYPE);
refresh(Table.EVENTTYPE);
refresh(Table.USERLIST);
}
catch (Exception e)
{
}
finally
{
}
}
/// <summary>
/// 查询编码类型信息列表（列表返回）
/// </summary>
/// <param name="strXML"></param>
/// <returns></returns>
public static string maxidtypeList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = Table.S + Common.DOT + Field.IDTYPE + Common.SPACE + Field.IDTYPE + Common.COMMA +
Table.S + Common.DOT + Field.IDNAME + Common.SPACE + Field.IDNAME + Common.COMMA +
Table.S + Common.DOT + Field.IDSIZE + Common.SPACE + Field.IDSIZE + Common.COMMA +
Table.S + Common.DOT + Field.IDPARA + Common.SPACE + Field.IDPARA + Common.COMMA +
Table.S + Common.DOT + Field.IDLOOP + Common.SPACE + Field.IDLOOP + Common.COMMA +
Table.S + Common.DOT + Field.IDMIN + Common.SPACE + Field.IDMIN + Common.COMMA +
Table.S + Common.DOT + Field.IDMAX + Common.SPACE + Field.IDMAX + Common.COMMA +
Table.S + Common.DOT + Field.IDDES + Common.SPACE + Field.IDDES;
string str_From = Table.MAXIDTYPE + Common.SPACE + Table.S;
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.IDTYPE,
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 学生查询
/// </summary>
/// <param name="strXML">标准的查询型XML</param>
/// <returns>xml数据</returns>
public static string personList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
// 每页查询多少条记录
int int_PageSize = obj_Query.getIntPageSize();
// 查询第几页
int int_CurrentPage = obj_Query.getIntCurrentPage();
// 将xml分析成标准的where语句
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
string str_Select = "s.PERSONID,s.NAME,s.SEX,s.IDCARD,s.YEAROLD";
string str_From = "PERSON s";
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"PERSONID DESC",
int_PageSize,
int_CurrentPage));
}
/// <summary>
/// 查询角色中不包含的事件类型
/// </summary>
/// <param name="roleid"></param>
/// <returns></returns>
public static string eventTypeList_AddToRole(string roleid)
{
string str_Select = Table.S + Common.DOT + Field.EVENTTYPEID + Common.SPACE + Field.EVENTTYPEID + Common.COMMA +
Table.S + Common.DOT + Field.EVENTTYPENAME + Common.SPACE + Field.EVENTTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.AFFAIRTYPENAME + Common.SPACE + Field.AFFAIRTYPENAME + Common.COMMA +
Table.S + Common.DOT + Field.DISABLED + Common.SPACE + Field.DISABLED + Common.COMMA +
Table.S + Common.DOT + Field.SHORTCUT + Common.SPACE + Field.SHORTCUT + Common.COMMA +
Table.S + Common.DOT + Field.VISIBLE + Common.SPACE + Field.VISIBLE;
string str_From = Table.VW_EVENTTYPE + Common.SPACE + Table.S;
string str_Where = Common.SELECT + Field.EVENTTYPEID +
Common.S_FROM + Table.ROLEPOWER +
Common.S_WHERE + Field.ROLEID + Common.EQUAL + General.addQuotes(roleid);
str_Where = Common.WHERE + Field.EVENTTYPEID + Common.NOT_IN + General.addBracket(str_Where) +
Common.S_AND + Field.AFFAIRTYPEID + Common.N_EQUAL + General.addQuotes("000100");
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.EVENTTYPEID,
99999,
1));
}
public void UnRegister()
{
var query = new CommonQuery();
query.Command = "UnRegister";
query.SetParameter("ModuleManager", this);
CommonQuery.StartQuery(query, MessageQueueSupport);
}
public static string ExpExcel(string path)
{
ReturnDoc obj_ReturnDoc = new ReturnDoc();
try
{
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
worksheet.Cells[1, 1] = "管道名称";
// 数据查询
OleDbDataReader rst = null;
string ret = CommonQuery.qryRst("select * from PIPELINE", ref rst);
Int16 i = 2;
DicCache dic = DicCache.getInstance();
if (ret.Equals("0"))
{
while (rst.Read())
{
worksheet.Cells[i, 1] = rst["DATA1"].ToString();
i++;
}
rst.Close();
}
string sPath = path;
string filename = "海底管道数据导出.xls";
workbook.Saved = true;
workbook.SaveCopyAs(sPath + filename);
xlApp.Quit();
obj_ReturnDoc.addErrorResult(Common.RT_SUCCESS);
obj_ReturnDoc.setFuncErrorInfo(filename);
}
catch (Exception e)
{
obj_ReturnDoc.addErrorResult(Common.RT_FUNCERROR);
obj_ReturnDoc.setFuncErrorInfo(e.Message);
}
return(obj_ReturnDoc.getXml());
}
public void ModifySetting(CommonQuery query)
{
foreach (var p in query.ParameterList)
{
if (ParameterList.ContainsKey(p.Name))
{
ParameterList[p.Name] = p.Value;
}
else
{
ParameterList.Add(p.Name, p.Value);
}
}
}
public void ReportSetting(CommonQuery query)
{
query.ParameterList.Clear();
foreach (var p in ParameterList)
{
query.ParameterList.Add(new Parameter()
{
Name = p.Key,
Value = CommonLib.CommonProc.ConvertObjectToString(p.Value),
DataTypeFullName = p.Value.GetType().AssemblyQualifiedName
});
}
CommonQuery.ReplyQuery(query, MessageQueueSupport);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<IssueViewLogEntity></returns>
public Pager <IssueViewLogEntity> GetIssueViewLogPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("IssueViewLog", "ViewLogID,JournalID,ContentID,AuthorID,Daytime,Year,Month,IP,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <IssueViewLogEntity> pager = new Pager <IssueViewLogEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeIssueViewLogList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<RoleAuthorEntity></returns>
public Pager <RoleAuthorEntity> GetRoleAuthorPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("RoleAuthor", "MapID,JournalID,RoleID,AuthorID,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <RoleAuthorEntity> pager = new Pager <RoleAuthorEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeRoleAuthorList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<DictEntity></returns>
public Pager <DictEntity> GetDictPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("Dict", "DictID,JournalID,DictKey,Note,InUserID,EditUserID,EditDate,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <DictEntity> pager = new Pager <DictEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeDictList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<ContactWayEntity></returns>
public Pager <ContactWayEntity> GetContactWayPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("ContactWay", "ContactID,JournalID,ChannelID,Company,LinkMan,Address,ZipCode,Tel,Fax,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <ContactWayEntity> pager = new Pager <ContactWayEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeContactWayList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<GuestbookEntity></returns>
public Pager <GuestbookEntity> GetGuestbookPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("Guestbook", "MessageID,JournalID,PMessageID,UserName,Email,Tel,Title,MessageContent,IP,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <GuestbookEntity> pager = new Pager <GuestbookEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeGuestbookList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<PayNoticeEntity></returns>
public Pager <PayNoticeEntity> GetPayNoticePageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("PayNotice", "NoticeID,JournalID,PayType,CID,Amount,Title,Body,SendDate,Status", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <PayNoticeEntity> pager = new Pager <PayNoticeEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakePayNoticeList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<SysAccountInfoEntity></returns>
public Pager <SysAccountInfoEntity> GetSysAccountInfoPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("SysAccountInfo", "AdminID,UserName,LoginName,Pwd,Gender,Email,Mobile,Status,LastIP,LoginDate,LogOnTimes,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <SysAccountInfoEntity> pager = new Pager <SysAccountInfoEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeSysAccountInfoList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="CommonQuery">通用查询对象</param>
/// <returns>Pager<ApiServerInfoEntity></returns>
public Pager <ApiServerInfoEntity> GetApiServerInfoPageList(CommonQuery query)
{
int recordCount = 0;
DataSet ds = db.GetPagingData("ApiServerInfo", "ApiServerID,SiteName,SiteUrl,Status,Note,AddDate", query.Order, query.Where, query.CurrentPage, query.PageSize, out recordCount);
Pager <ApiServerInfoEntity> pager = new Pager <ApiServerInfoEntity>();
if (ds != null && ds.Tables.Count > 0)
{
pager.ItemList = MakeApiServerInfoList(ds.Tables[0]);
}
pager.CurrentPage = query.CurrentPage;
pager.PageSize = query.PageSize;
pager.TotalRecords = recordCount;
return(pager);
}