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