/// <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));
}
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">标准 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 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 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 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 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));
}
/// <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="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="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="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 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="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="strPersonID"></param>
/// <returns></returns>
public static string personDetail(string strPersonID)
{
string str_Where = "WHERE PERSONID='" + strPersonID + "'";
string str_Select = "s.PERSONID,s.NAME,s.SEX,s.IDCARD,s.YEAROLD,s.PLACECODE,s.BIRTHDAY,s.BAK";
string str_From = "PERSON s";
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"PERSONID DESC",
1,
1,
"PERSON"));
}
/// <summary>
/// 查询班级详细信息
/// </summary>
/// <param name="strClassID"></param>
/// <returns></returns>
public static string stuClassDetail(string strClassID)
{
string str_Where = "WHERE CLASSID='" + strClassID + "'";
string str_Select = "s.CLASSID,s.CLASSNAME,s.CLASSBAK";
string str_From = "STUCLASS s";
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"CLASSID ASC",
1,
1,
"STUCLASS"));
}
public static string ordersDetail(string strOrderID)
{
string str_Where = "WHERE PIPEID='" + strOrderID + "'";
string str_Select = "*";
string str_From = "PIPELINE s";
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"PIPEID DESC",
1,
1,
"PIPELINE"));
}
/// <summary>
/// 查询编码类型信息列表（列表返回）
/// </summary>
/// <param name="strIDType"></param>
/// <returns></returns>
public static string maxidList(string strIDType)
{
string str_Select = Table.S + Common.DOT + Field.IDTYPE + Common.SPACE + Field.IDTYPE + Common.COMMA +
Table.S + Common.DOT + Field.ID1 + Common.SPACE + Field.ID1 + Common.COMMA +
Table.S + Common.DOT + Field.ID2 + Common.SPACE + Field.ID2 + Common.COMMA +
Table.S + Common.DOT + Field.MAXID + Common.SPACE + Field.MAXID;
string str_From = Table.MAXID + Common.SPACE + Table.S;
string str_Where = Common.WHERE + Field.IDTYPE + Common.EQUAL + General.addQuotes(strIDType);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.ID1,
9999,
1));
}
/// <summary>
/// 角色详细信息
/// </summary>
/// <param name="roleid"></param>
/// <returns></returns>
public static string roleDetail(string roleid)
{
string str_Select = Table.S + Common.DOT + Field.ROLEID + Common.SPACE + Field.ROLEID + Common.COMMA +
Table.S + Common.DOT + Field.ROLENAME + Common.SPACE + Field.ROLENAME + Common.COMMA +
Table.S + Common.DOT + Field.ROLEDES + Common.SPACE + Field.ROLEDES;
string str_From = Table.ROLEBASIC + Common.SPACE + Table.S;
string str_Where = Common.WHERE + Field.ROLEID + Common.EQUAL + General.addQuotes(roleid);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.ROLEID,
1,
1,
Table.ROLEBASIC));
}
public static string eventTypeDetail(string eventTypeid)
{
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.AFFAIRTYPEID + Common.SPACE + Field.AFFAIRTYPEID + Common.COMMA +
Table.S + Common.DOT + Field.OPURL + Common.SPACE + Field.OPURL + Common.COMMA +
Table.S + Common.DOT + Field.EVENTTYPEDES + Common.SPACE + Field.EVENTTYPEDES + 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 = Common.WHERE + Field.EVENTTYPEID + Common.EQUAL + General.addQuotes(eventTypeid);
string[] str_DicFieldList = { Field.AFFAIRTYPEID,
Field.BEGINEVENT,
Field.DISABLED,
Field.SHORTCUT,
Field.VISIBLE };
string[] str_DicNameList = { Table.DIC_AFFAIRTYPE,
Table.DIC_TRUEFALSE,
Table.DIC_TRUEFALSE,
Table.DIC_TRUEFALSE,
Table.DIC_TRUEFALSE };
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.EVENTTYPEID,
str_DicFieldList,
str_DicNameList,
null,
1,
1,
1,
1,
0,
true,
Table.EVENTTYPE));
}
/// <summary>
/// 查询角色权限信息列表（列表返回）
/// </summary>
/// <param name="roleid"></param>
/// <returns></returns>
public static string roleRightList(string roleid)
{
string str_Select = Table.S + Common.DOT + Field.ROLEID + Common.SPACE + Field.ROLEID + Common.COMMA +
Table.S + Common.DOT + Field.ROLENAME + Common.SPACE + Field.ROLENAME + Common.COMMA +
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.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_ROLEPOWER + Common.SPACE + Table.S;
string str_Where = Common.WHERE + Field.ROLEID + Common.EQUAL + General.addQuotes(roleid);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.EVENTTYPEID,
99999,
1));
}
/// <summary>
/// 查询编码规则详细信息
/// </summary>
/// <param name="idtype"></param>
/// <returns></returns>
public static string maxidtypeDetail(string idtype)
{
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 = Common.WHERE + Common.SPACE + Field.IDTYPE + Common.EQUAL + General.addQuotes(idtype);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.IDTYPE,
1, 1,
Table.MAXIDTYPE));
}
/// <summary>
/// 查询单位详细信息
/// </summary>
/// <param name="munitid">单位编码</param>
/// <returns></returns>
public static string munitDetail(string munitid)
{
string str_Select = "s." + Field.MUNITID + " " + Field.MUNITID + "," +
"s." + Field.MUNITNAME + " " + Field.MUNITNAME + "," +
"s." + Field.MTYPE + " " + Field.MTYPE + "," +
"s." + Field.MDES + " " + Field.MDES + "," +
"s." + Field.MSUNITID + " " + Field.MSUNITID + "," +
"s." + Field.VALID + " " + Field.VALID + "," +
"s." + Field.MLEVEL + " " + Field.MLEVEL;
string str_From = Table.MANAGEUNIT + " s";
string str_Where = "WHERE " + Field.MUNITID + "=" + General.addQuotes(munitid);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.MUNITID,
1,
1,
Table.MANAGEUNIT));
}
/// <summary>
/// 查询角色用户信息列表（列表返回）
/// </summary>
/// <param name="roleid">角色编号</param>
/// <returns></returns>
public static string roleUserList(string roleid)
{
string str_Select = Table.S + Common.DOT + Field.ROLEID + Common.SPACE + Field.ROLEID + Common.COMMA +
Table.S + Common.DOT + Field.ROLENAME + Common.SPACE + Field.ROLENAME + Common.COMMA +
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.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_ROLEUSER + Common.SPACE + Table.S;
string str_Where = Common.WHERE + Field.ROLEID + Common.EQUAL + General.addQuotes(roleid);
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.USERID,
99999,
1));
}
public static string userDetail(string userid)
{
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.DUTY + Common.SPACE + Field.DUTY + Common.COMMA +
Table.S + Common.DOT + Field.NATION + Common.SPACE + Field.NATION + Common.COMMA +
Table.S + Common.DOT + Field.IDCARD + Common.SPACE + Field.IDCARD + Common.COMMA +
Table.S + Common.DOT + Field.NATIVEPLACE + Common.SPACE + Field.NATIVEPLACE + Common.COMMA +
Table.S + Common.DOT + Field.EDUCATION + Common.SPACE + Field.EDUCATION + Common.COMMA +
Table.S + Common.DOT + Field.ADDRESS + Common.SPACE + Field.ADDRESS + Common.COMMA +
Table.S + Common.DOT + Field.USERDES + Common.SPACE + Field.USERDES + Common.COMMA +
Table.S + Common.DOT + Field.TEMPADDRESS + Common.SPACE + Field.TEMPADDRESS + Common.COMMA +
Table.S + Common.DOT + Field.CONTACT + Common.SPACE + Field.CONTACT + Common.COMMA +
Table.S + Common.DOT + Field.SMSTEL + Common.SPACE + Field.SMSTEL + Common.COMMA +
Table.S + Common.DOT + Field.BIRTHDAY + Common.SPACE + Field.BIRTHDAY + 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 = Common.WHERE + Field.USERID + Common.EQUAL + General.addQuotes(userid);
string[] str_FieldData = { Field.BIRTHDAY };
return(CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
Field.USERID,
str_FieldData,
1,
1,
Table.USERLIST));
}
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="strOrderID">订单编号</param>
/// <returns></returns>
public static string ordersProList(string strOrderID)
{
string str_Where = "WHERE PIPEID='" + strOrderID + "'";
string str_Select = "*";
string str_From = "PIPELINEDETAIL s";
string strProXml = CommonQuery.basicListQuery(str_Select,
str_From,
str_Where,
"PIPEID",
9999,
1,
"PIPELINEDETAIL");
XmlDocument objProDom = XmlFun.CreateNewDoc(strProXml);
for (int i = 0; i < objProDom.SelectNodes("//PIPELINEDETAIL").Count; i++)
{
XmlElement ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL").Item(i);
ele.SetAttribute("operation", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA1").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA2").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA3").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "1");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA4").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "1");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA5").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA6").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA7").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA8").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
ele = (XmlElement)objProDom.SelectNodes("//PIPELINEDETAIL/DATA9").Item(i);
ele.SetAttribute("state", "0");
ele.SetAttribute("datatype", "0");
}
return(objProDom.InnerXml);
}