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);
}
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);
}
/// <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>
/// <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);
}
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);
}
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);
}
/// <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 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 spellList(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.WORD + Common.SPACE + Field.WORD + Common.COMMA +
Table.S + Common.DOT + Field.SPELL + Common.SPACE + Field.SPELL + Common.COMMA +
Table.S + Common.DOT + Field.ASPELL + Common.SPACE + Field.ASPELL;
string str_From = Table.SPELL + 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.SPELL,
int_PageSize,
int_CurrentPage);
}
/// <summary>
/// 查询单位列表
/// </summary>
/// <param name="strXML"></param>
/// <returns></returns>
public static string munitList(string strXML)
{
QueryDoc obj_Query = new QueryDoc(strXML);
int int_PageSize = obj_Query.getIntPageSize();
int int_CurrentPage = obj_Query.getIntCurrentPage();
string str_Select = "s." + Field.MUNITID + " " + Field.MUNITID + "," +
"s." + Field.MUNITNAME + " " + Field.MUNITNAME + "," +
"s." + Field.MSUNITID + " " + Field.MSUNITID + "," +
"s." + Field.MTYPE + " " + Field.MTYPE + "," +
"s." + Field.MLEVEL + " " + Field.MLEVEL + "," +
"s." + Field.VALID + " " + Field.VALID;
string str_From = Table.MANAGEUNIT + " s";
string str_Where = obj_Query.getConditions();
str_Where = General.empty(str_Where) ? str_Where : Common.WHERE + str_Where;
if (General.empty(str_Where))
{
str_Where = " WHERE " + Field.MTYPE + "!=" + General.addQuotes("AA");
}
else
{
str_Where = str_Where +
" AND " + Field.MTYPE + "!=" + General.addQuotes("AA");
}
return CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.MUNITID,
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="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>
/// <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);
}