public OperationDataArgs11111 OperationMethodA(int AIntOperationID, List <string> AListStringArgs) { OperationDataArgs11111 LOperationReturn = new OperationDataArgs11111(); try { if (AIntOperationID == 0) { LOperationReturn = OperationA00(AListStringArgs); } if (AIntOperationID == 1) { LOperationReturn = OperationA01(AListStringArgs); } if (AIntOperationID == 2) { LOperationReturn = OperationA02(AListStringArgs); } } catch (Exception ex) { LOperationReturn.BoolReturn = false; LOperationReturn.StringReturn = ex.ToString(); } return(LOperationReturn); }
/// <summary> /// 获取所有资源类型 /// </summary> /// <param name="AListStringArgs"> /// 0:数据库类型 /// 1:数据库连接串 /// 2:租户编码 /// </param> /// <returns></returns> private OperationDataArgs11111 OperationA01(List <string> AListStringArgs) { OperationDataArgs11111 LOperationReturn = new OperationDataArgs11111(); string LStrDynamicSQL = string.Empty; try { DatabaseOperation01Return LDatabaseOperation01Return = new DatabaseOperation01Return(); DataOperations01 LDataOperations01 = new DataOperations01(); LStrDynamicSQL = "SELECT * FROM T_00_010"; LDatabaseOperation01Return = LDataOperations01.SelectDataByDynamicSQL(int.Parse(AListStringArgs[0]), AListStringArgs[1], LStrDynamicSQL); if (LDatabaseOperation01Return.BoolReturn) { LOperationReturn.DataSetReturn = LDatabaseOperation01Return.DataSetReturn; LOperationReturn.StringReturn = LDatabaseOperation01Return.StrReturn; } else { LOperationReturn.BoolReturn = false; LOperationReturn.StringReturn = LDatabaseOperation01Return.StrReturn; } } catch (Exception ex) { LOperationReturn.BoolReturn = false; LOperationReturn.StringReturn = ex.ToString(); } return(LOperationReturn); }
/// <summary> /// 根据资源ID获取资源信息 /// </summary> /// <param name="AListStringArgs"> /// 0:数据库类型 /// 1:数据库连接串 /// 2:租户编码 /// 3:资源ID编码(3位数)</param> /// <returns></returns> private OperationDataArgs11111 OperationA02(List <string> AListStringArgs) { OperationDataArgs11111 LOperationReturn = new OperationDataArgs11111(); string LStrDynamicSQL = string.Empty; int LIntTypeID = 0; string LStrIDBegin = string.Empty, LStrIDEnd = string.Empty; try { DatabaseOperation01Return LDatabaseOperation01Return = new DatabaseOperation01Return(); DataOperations01 LDataOperations01 = new DataOperations01(); LIntTypeID = int.Parse(AListStringArgs[3]); LStrIDBegin = LIntTypeID.ToString() + "0000000000000001"; LStrIDEnd = (LIntTypeID + 1).ToString() + "0000000000000000"; LStrDynamicSQL = "SELECT * FROM T_11_101_" + AListStringArgs[2] + " WHERE C001 >= " + LStrIDBegin + " AND C001 < " + LStrIDEnd + " ORDER BY C001 ASC"; LDatabaseOperation01Return = LDataOperations01.SelectDataByDynamicSQL(int.Parse(AListStringArgs[0]), AListStringArgs[1], LStrDynamicSQL); if (LDatabaseOperation01Return.BoolReturn) { LOperationReturn.DataSetReturn = LDatabaseOperation01Return.DataSetReturn; LOperationReturn.StringReturn = LDatabaseOperation01Return.StrReturn; } else { LOperationReturn.BoolReturn = false; LOperationReturn.StringReturn = LDatabaseOperation01Return.StrReturn; } } catch (Exception ex) { LOperationReturn.BoolReturn = false; LOperationReturn.StringReturn = ex.ToString(); } return(LOperationReturn); }