/// <summary> /// 将标准的添加操作XmlElement对象转化为T-SQL语句 /// </summary> /// <param name="eleSQL">业务操作型 XmlElement 对象</param> /// <returns>T-SQL语句</returns> private static string parseInsert(XmlElement eleSQL) { XmlNodeList it_Temp = eleSQL.ChildNodes; string str_FieldList = ""; /// 字段列表 string str_ValueList = ""; /// 字段值列表 string str_TableName = eleSQL.Name; /// 表名 for (int k = 0; k < it_Temp.Count; k++) { XmlNode ele_Field = it_Temp[k]; String str_State = XmlFun.getAttributValue(ele_Field, Common.XML_PROP_STATE); String str_FieldName = ele_Field.Name; String str_FieldValue = ele_Field.InnerText; if (General.empty(str_State)) { continue; } if (str_State.Equals(Common.ST_NORMAL)) { str_FieldList += str_FieldName + Common.COMMA; string str_DataType = XmlFun.getAttributValue(ele_Field, Common.XML_PROP_DATATYPE); if (General.empty(str_DataType)) { continue; } int int_DataType = Convert.ToInt32(str_DataType); str_ValueList += General.converType(int_DataType, str_FieldValue, str_FieldName) + Common.COMMA; } /// if(str_State.equals(Common.DT_STRING)) } /// for~~~~~~~ if (General.empty(str_FieldList)) { return(null); } return(Common.INSERT + str_TableName + Common.SPACE + General.addBracket(str_FieldList.Substring(0, str_FieldList.Length - 1)) + Common.S_VALUES + General.addBracket(str_ValueList.Substring(0, str_ValueList.Length - 1))); }
/// <summary> /// 通过传入的 XML 结构,组织返回 Delete 类型的 SQL 语句 /// </summary> /// <param name="eleSQL">业务操作型 XmlElement 对象</param> /// <returns>T-SQL语句</returns> private static string parseDelete(XmlElement eleSQL) { XmlNodeList it_Temp = eleSQL.ChildNodes; string str_WhereList = ""; /// 条件列表 string str_TableName = eleSQL.Name; // 表名 for (int k = 0; k < it_Temp.Count; k++) { XmlNode ele_Field = it_Temp[k]; string str_State = XmlFun.getAttributValue(ele_Field, Common.XML_PROP_STATE); string str_FieldName = ele_Field.Name; string str_FieldValue = ele_Field.InnerText; if (General.empty(str_State)) { continue; } int int_State = Convert.ToInt32(str_State); String str_DataType; int int_DataType; switch (int_State) { case Common.IST_QUERY: str_DataType = XmlFun.getAttributValue(ele_Field, Common.XML_PROP_DATATYPE); int_DataType = General.empty(str_DataType) ? Convert.ToInt32(Common.DT_STRING) : Convert.ToInt32(str_DataType); if (int_DataType != Common.IDT_BINARY) { str_WhereList += str_FieldName + Common.EQUAL + General.converType(int_DataType, str_FieldValue, str_FieldName) + Common.S_AND; } /// if (int_DataType==Common.IDT_BINARY) break; } /// switch ~~~~~~~~~~ } /// for~~~~~~~~ if (!General.empty(str_WhereList)) { str_WhereList = Common.S_WHERE + str_WhereList.Substring(0, str_WhereList.Length - 5); } return(Common.DELETE + str_TableName + str_WhereList); }
/// <summary> /// 根据xml初始化构造函数 /// </summary> /// <param name="strXML">查询型的xml字符串</param> public QueryDoc(string strXML) { m_doc_Self = new XmlDocument(); m_doc_Self.LoadXml(strXML); XmlElement ele_Condition = this.getCondition(); string str_Return = XmlFun.getAttributValue(ele_Condition, Common.XML_PROP_RECORDSPERPAGE); int int_PageSize = str_Return == null ? 10 : Convert.ToInt32(str_Return); setIntPageSize(int_PageSize); /// 获得当前待查询页码 str_Return = XmlFun.getAttributValue(ele_Condition, Common.XML_PROP_CURRENTPAGENUM); int int_CurrentPage = str_Return == null ? 1 : Convert.ToInt32(str_Return); setIntCurrentPage(int_CurrentPage); }
/// <summary> /// 根据 XML 文档解析得到T-SQL查询Where语句 /// </summary> /// <param name="ele">XmlElement节点对象</param> /// <returns>解析好的T-SQL查询Where语句</returns> private string parseConditions(XmlElement ele) { XmlNodeList it_Condition = ele.SelectNodes(Common.BAR2 + Common.XDOC_CONDITION); XmlNodeList it_Conditions = ele.SelectNodes(Common.BAR2 + Common.XDOC_CONDITIONS); string str_Where = ""; string str_Type = ""; for (int k = 0; k < it_Condition.Count; k++) { if (k > 0) { str_Type = XmlFun.getNodeValue(it_Conditions.Item(k - 1), Common.XDOC_TYPE); str_Type = General.empty(str_Type) ? "" : str_Type.Trim().ToUpper(); } /// 获得查询节点 if (!General.empty(str_Where)) { if (General.empty(str_Type)) { throw new Exception("QueryDoc.parseConditions.77.未提供类型"); } str_Where += Common.SPACE + str_Type + Common.SPACE; } XmlNode ele_Condition = it_Condition.Item(k); string str_Alias = XmlFun.getAttributValue(ele_Condition, Common.XML_PROP_ALIAS); string str_DataType = XmlFun.getAttributValue(ele_Condition, Common.XML_PROP_DATATYPE); int int_DataType = General.empty(str_DataType) ? 0 : Convert.ToInt32(str_DataType); string str_FieldName = XmlFun.getNodeValue(ele_Condition, Common.XDOC_FIELDNAME); str_FieldName = General.empty(str_Alias) ? str_FieldName : str_Alias + Common.DOT + str_FieldName; /// + /// 如果是查询出生日期,则获得该字典的 sv 属性,用来确定是否是按照年龄来查询的 /// 如果是 AGERANGE 则说明是按照年龄来查询 /// 如果是 空,则说明是按照出生日期来查询 string str_Sv = XmlFun.getNodeValue(ele_Condition, Common.XDOC_FIELDNAME + Common.BAR + "@" + Common.XML_PROP_SV); string str_Operation = XmlFun.getNodeValue(ele_Condition, Common.XDOC_OPERATION); string str_DataValue = XmlFun.getNodeValue(ele_Condition, Common.XDOC_VALUE); str_Operation = str_Operation.Trim().ToUpper(); /// 单独处理日期类型的字段 if (int_DataType == 3) { /// 按年龄来进行查询 if (str_Sv.Equals(Common.XML_AGERANGE)) { str_Where += General.opYearDate(str_FieldName, str_DataValue, str_Operation); } else { str_Where += General.opDate(str_FieldName, str_DataValue, str_Operation); } } else { if (int_DataType == Common.IDT_BINARY) { throw new Exception("QueryDoc.parseConditions.函数不能处理二进制类型的数据"); } if (str_Operation.ToUpper().Equals("NOT IN") || str_Operation.ToUpper().Equals("IS") || str_Operation.ToUpper().Equals("IS NOT")) { str_Where += str_FieldName + Common.SPACE + str_Operation + Common.SPACE + str_DataValue; } else { str_Where += str_FieldName + Common.SPACE + str_Operation + Common.SPACE + General.converType(int_DataType, str_DataValue, str_FieldName); } } } return(str_Where); }
/// <summary> /// 通过传入的 XML 结构,组织返回 UPDATE 类型的 SQL 语句 /// </summary> /// <param name="eleSQL">业务操作型 XmlElement 对象</param> /// <returns>T-SQL语句</returns> private static String parseUpdate(XmlElement eleSQL) { XmlNodeList it_Temp = eleSQL.ChildNodes; string str_EditList = ""; /// 字段值列表 string str_WhereList = ""; /// 条件列表 string str_TableName = eleSQL.Name; // 表名 for (int k = 0; k < it_Temp.Count; k++) { XmlNode ele_Field = it_Temp[k]; string str_State = XmlFun.getAttributValue(ele_Field, Common.XML_PROP_STATE); string str_FieldName = ele_Field.Name; string str_FieldValue = ele_Field.InnerText; if (General.empty(str_State)) { continue; } int int_State = Convert.ToInt32(str_State); string str_DataType; int int_DataType; str_DataType = XmlFun.getAttributValue(ele_Field, Common.XML_PROP_DATATYPE); int_DataType = General.empty(str_DataType) ? Convert.ToInt32(Common.DT_STRING) : Convert.ToInt32(str_DataType); switch (int_State) { case Common.IST_NORMAL: str_EditList += str_FieldName + Common.EQUAL + General.converType(int_DataType, str_FieldValue, str_FieldName) + Common.COMMA; break; case Common.IST_QUERY: if (int_DataType == Common.IDT_BINARY) { throw new Exception("查询字句中不能以二进制流字段类型作为查询字句的内容!"); } str_WhereList += str_FieldName + Common.EQUAL + General.converType(int_DataType, str_FieldValue, str_FieldName) + Common.S_AND; break; } /// switch (int_State) } /// for~~~~~~~~~~ if (General.empty(str_EditList)) { return(null); } if (!General.empty(str_WhereList)) { str_WhereList = Common.S_WHERE + str_WhereList.Substring(0, str_WhereList.Length - 5); } return(Common.UPDATE + str_TableName + Common.S_SET + str_EditList.Substring(0, str_EditList.Length - 1) + str_WhereList); }