private static IDataReader GetListPages_SPPT(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string strFields, string KeyField, string OrderBy, string strWhere, out int totalRecords, string TablePrefix)
{
DbHelperBase base2 = DB;
sTableName = TablePrefix + sTableName;
if (string.IsNullOrEmpty(strFields))
{
strFields = "*";
}
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Tables", SqlDbType.VarChar, 0x3e8), new SqlParameter("@PrimaryKey", SqlDbType.VarChar, 10), new SqlParameter("@Sort", SqlDbType.VarChar, 200), new SqlParameter("@CurrentPage", SqlDbType.Int, 4), new SqlParameter("@PageSize", SqlDbType.Int, 4), new SqlParameter("@Fields", SqlDbType.VarChar, 0x3e8), new SqlParameter("@Filter", SqlDbType.VarChar, 0x3e8) };
commandParameters[0].Value = sTableName;
commandParameters[1].Value = KeyField;
commandParameters[2].Value = OrderBy.Trim();
commandParameters[3].Value = PageIndex;
commandParameters[4].Value = PageSize;
commandParameters[5].Value = strFields;
commandParameters[6].Value = strWhere.Trim();
IDataReader reader = base2.ExecuteReader(CommandType.StoredProcedure, string.Format("{0}SplitPages", TablePrefix), commandParameters);
string commandText = string.Format("select count(*) from {0} {1} ", sTableName, string.IsNullOrEmpty(strWhere) ? "" : (" Where " + strWhere));
object objA = base2.ExecuteScalar(CommandType.Text, commandText);
totalRecords = 1;
if (!object.Equals(objA, null))
{
totalRecords = int.Parse(objA.ToString());
}
return(reader);
}
public ViewDocumentWindow(Project project)
{
_dbHelper = project.DbHelper;
_timeTableCaretaker = project.TimeTableCaretaker;
InitializeComponent();
DataContext = this;
var state = _timeTableCaretaker.GetState();
FirstWeek = state.FirstWeek;
SecondWeek = state.SecondWeek;
}
public static IDataReader GetListPagesSql2005(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string Fileds, string strWhere, string oderby, out int RecordCount)
{
string commandText = string.Format("select count(*) from {0} {1} ", sTableName, string.IsNullOrEmpty(strWhere) ? "" : (" Where " + strWhere));
object objA = DB.ExecuteScalar(CommandType.Text, commandText);
RecordCount = 1;
if (!object.Equals(objA, null))
{
RecordCount = int.Parse(objA.ToString());
}
string str2 = GetListPagesSql2005(sTableName, PageIndex, PageSize, Fileds, strWhere, oderby);
return(DB.ExecuteReader(CommandType.Text, str2));
}
//private Dictionary<string, object> options;
//private Queue<WhereParam> conditions;
//private string TableName { get; set; }
public ORMHelper()
{
DBConfig dbConfig = DBConfig.Instance;
string connStr = string.Empty;
switch (dbConfig.Type.ToLower())
{
case "oracle":
connStr = string.Format("User ID={0};Password={1};Data Source={2};",
dbConfig.Username,
dbConfig.Password,
dbConfig.HostName);
foreach (var item in dbConfig.Params)
{
string value = item.Value;
if (string.IsNullOrEmpty(value))
{
value = "none";
}
connStr += string.Format("{0}={1};", item.Key, value);
}
DbHelper = new OracleHelper(connStr);
break;
case "mysql":
connStr = string.Format("server={0};User Id=root;password=njbosa;Database=bifms;charset=utf8;",
dbConfig.HostName,
dbConfig.Username,
dbConfig.Password,
dbConfig.DataBase,
dbConfig.Charset);
foreach (var item in dbConfig.Params)
{
string value = item.Value;
if (string.IsNullOrEmpty(value))
{
value = "none";
}
connStr += string.Format("{0}={1};", item.Key, value);
}
DbHelper = new MysqlHelper(connStr);
break;
default:
throw new Exception("不支持的数据库类型");
}
//options = new Dictionary<string, object>();
//conditions = new Queue<WhereParam>();
//TableName = AttributeProcess.GetTableName(typeof(T));
}
public ORMHelper(string connStr, string type = "mysql")
{
switch (type.ToLower())
{
case "oracle":
DbHelper = new OracleHelper(connStr);
break;
case "sqlserver":
DbHelper = new SQLHelper(connStr);
break;
case "mysql":
default:
throw new Exception("不支持的数据库类型");
}
//options = new Dictionary<string, object>();
//conditions = new Queue<WhereParam>();
//TableName = AttributeProcess.GetTableName(typeof(T));
}
public void SetDbHelper(DbHelperBase dbHelper)
{
Result.DbHelper = dbHelper;
}
public static IDataReader GetListPages_SP(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string strFields, string KeyField, string OrderBy, string strWhere, out int totalRecords, string TablePrefix)
{
return(GetListPages_SPPT(DB, sTableName, PageSize, PageIndex, strFields, KeyField, OrderBy, strWhere, out totalRecords, TablePrefix));
}
public static string GetSplitPagesMySql(DbHelperBase DB, string sTableName1, string sTableName2, int PageSize, int PageIndex, string strFields, string sTable1Key, string sTable2Key, string OrderBy, string strWhere, string TablePrefix)
{
sTableName1 = TablePrefix + sTableName1;
sTableName2 = TablePrefix + sTableName2;
string commandText = string.Empty;
string str2 = string.Empty;
if (PageIndex > 0)
{
PageIndex--;
}
if (!string.IsNullOrEmpty(OrderBy))
{
str2 = " ORDER BY " + OrderBy;
}
int num = PageIndex * PageSize;
object[] args = new object[] { sTableName1, sTable1Key, sTableName2, sTable2Key };
string str3 = string.Format(" where {0}.{1}={2}.{3}", args);
if (!string.IsNullOrEmpty(strWhere))
{
strWhere = str3 + " and " + strWhere;
}
else
{
strWhere = str3;
}
object[] objArray2 = new object[] { "select ", sTableName1, ".", sTable1Key, " from ", sTableName1, ",", sTableName2, " ", strWhere, str2, " limit ", num, ",", PageSize, ";" };
commandText = string.Concat(objArray2);
StringBuilder builder = new StringBuilder();
using (IDataReader reader = DB.ExecuteReader(CommandType.Text, commandText))
{
while (reader.Read())
{
builder.Append(reader.GetString(0));
builder.Append(",");
}
}
if (builder.Length > 1)
{
builder.Remove(builder.Length - 1, 1);
}
else
{
builder.Append("0");
}
if (string.IsNullOrEmpty(strFields))
{
strFields = "*";
}
else
{
strFields = string.Format(strFields, sTableName1, sTableName2);
}
object[] objArray3 = new object[] {
"select ", strFields, " from ", sTableName1, ",", sTableName2, " where ", sTableName1, ".", sTable1Key, "=", sTableName2, ".", sTable2Key, " and ", sTableName1,
".", sTable1Key, " in (", builder, ")", str2
};
return(string.Concat(objArray3));
}
public static string GetSplitPagesMySql(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string strFields, string KeyField, string OrderBy, string strWhere, string TablePrefix, bool isint)
{
sTableName = TablePrefix + sTableName;
string commandText = string.Empty;
string str2 = string.Empty;
if (PageIndex > 0)
{
PageIndex--;
}
if (!string.IsNullOrEmpty(OrderBy))
{
str2 = " ORDER BY " + OrderBy;
}
else if (!string.IsNullOrEmpty(KeyField))
{
str2 = " ORDER BY " + KeyField + " desc";
}
int num = PageIndex * PageSize;
if (!string.IsNullOrEmpty(strWhere))
{
strWhere = " where " + strWhere;
}
object[] objArray1 = new object[] { "select ", KeyField, " from ", sTableName, " ", strWhere, str2, " limit ", num, ",", PageSize, ";" };
commandText = string.Concat(objArray1);
StringBuilder builder = new StringBuilder();
if (isint)
{
using (IDataReader reader = DB.ExecuteReader(CommandType.Text, commandText))
{
while (reader.Read())
{
builder.Append(reader.GetString(0));
builder.Append(",");
}
}
}
else
{
using (IDataReader reader2 = DB.ExecuteReader(CommandType.Text, commandText))
{
while (reader2.Read())
{
builder.Append("'");
builder.Append(reader2.GetString(0));
builder.Append("'");
builder.Append(",");
}
}
}
if (builder.Length > 1)
{
builder.Remove(builder.Length - 1, 1);
}
else
{
builder.Append("0");
}
if (string.IsNullOrEmpty(strFields))
{
strFields = "*";
}
object[] objArray2 = new object[] { "select ", strFields, " from ", sTableName, " where ", KeyField, " in (", builder, ")", str2 };
return(string.Concat(objArray2));
}
public static string GetSplitPagesMySql(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string strFields, string KeyField, string OrderBy, string strWhere, string TablePrefix)
{
return(GetSplitPagesMySql(DB, sTableName, PageSize, PageIndex, strFields, KeyField, OrderBy, strWhere, TablePrefix, true));
}
public TimeTableCaretaker(DbHelperBase dbHelper)
{
_dbHelper = dbHelper;
}
public void SetDb(DbHelperBase db)
{
_dbHelper = db;
}
