/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public IList <T> SelectAll <T>() where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
IList <T> list = dbManage.Search <T>("1=1");
_operatorError = dbManage.ErrorMsg == null ? "" : dbManage.ErrorMsg;
return(list);
}
public T Select <T>(string tableName, object id) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
T t = dbManage.Select <T>(tableName, id);
_operatorError = dbManage.ErrorMsg == null ? "" : dbManage.ErrorMsg;
return(t);
}
/// <summary>
/// 搜索
/// </summary>
/// <param name="course"></param>
/// <returns></returns>
public T SelectByCondition <T>(string where) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
T t = dbManage.SelectByCondition <T>(where);
_operatorError = dbManage.ErrorMsg == null ? "" : dbManage.ErrorMsg;
return(t);
}
public System.Data.DataSet ExecuteProcedure(string ProcName, List <System.Data.Common.DbParameter> list)
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
System.Data.DataSet ds = dbManage.ExecuteProcedure(ProcName, list);
if (ds == null)
{
_operatorError = dbManage.ErrorMsg;
}
return(ds);
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public System.Data.DataSet ExecuteSql(string sqlstr)
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
System.Data.DataSet ds = dbManage.ExecuteQuery(sqlstr);
if (ds == null)
{
_operatorError = dbManage.ErrorMsg;
}
return(ds);
}
/// <summary>
/// 多项删除
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="IDs"></param>
/// <returns></returns>
public bool Delete <T>(List <object> IDs) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
bool result = dbManage.Delete <T>(IDs);
if (!result)
{
_operatorError = dbManage.ErrorMsg;
}
return(result);
}
/// <summary>
/// 按条件删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteByCondition <T>(string where) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
bool result = dbManage.DeleteByCondition <T>(where);
if (!result)
{
_operatorError = dbManage.ErrorMsg;
}
return(result);
}
public bool Update <T>(string tableName, T info) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
bool result = dbManage.Update <T>(tableName, info);
if (!result)
{
_operatorError = dbManage.ErrorMsg;
}
return(result);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="course"></param>
/// <returns></returns>
public bool Insert <T>(T info) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
bool result = dbManage.Insert <T>(info);
if (!result)
{
_operatorError = dbManage.ErrorMsg == null ? "" : dbManage.ErrorMsg;
}
return(result);
}
public IList <T> Search <T>(string tableName, string where, string orderby = "") where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
if (string.IsNullOrEmpty(orderby))
{
IList <T> list = dbManage.Search <T>(tableName, where, orderby);
_operatorError = dbManage.ErrorMsg == null ? "" : dbManage.ErrorMsg;
return(list);
}
else
{
IList <T> list = dbManage.Search <T>(tableName, where, orderby);
_operatorError = dbManage.ErrorMsg == null ? "" : dbManage.ErrorMsg;
return(list);
}
}
/// <summary>
/// 执行SQL语句事务提交
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public bool ExecuteNonQuery1(string sqlstr)
{
bool flag;
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
dbManage.BeginTransaction();
flag = dbManage.ExecuteNonQuery(sqlstr);
if (flag)
{
dbManage.Commit();
}
else
{
dbManage.Rollback();
}
return(flag);
}
public DBm(IDBManage dBManage) => this._IDBManage = dBManage;
/// <summary>
/// 将table数据转换为list
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dt"></param>
/// <returns></returns>
public List <T> FillData <T>(System.Data.DataTable dt) where T : Kingsun.DB.Action, new()
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
return(dbManage.FillData <T>(dt));
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public bool ExecuteNonQuery(string sqlstr)
{
IDBManage dbManage = DBFactory.CreateDBManage(AppSetting.ConnectionString);
return(dbManage.ExecuteNonQuery(sqlstr));
}
