/// <summary>
/// 为下拉菜单添加数据
/// </summary>
/// <param name="tb_combo_box">ComboBox</param>
/// <param name="controllerName">Controller名</param>
/// <param name="methodName">Controller里的方法名</param>
/// <param name="displayName">ComboBox的displayName</param>
/// <param name="valueName">ComboBox的valueName</param>
public static void AddComboBoxDropDownDataSource(ComboBox tb_combo_box, string controllerName, string methodName, string displayName, string valueName)
{
object controller = LTCingFWSet.GetInstanceBean(controllerName);
MethodInfo info = controller.GetType().GetMethod(methodName, BindingFlags.Public | BindingFlags.Instance);
DataTable dropDownDataSource = (DataTable)info.Invoke(controller, null);
DataRow row = dropDownDataSource.NewRow();
row[displayName] = "";
row[valueName] = "";
dropDownDataSource.Rows.InsertAt(row, 0);
//Distinct
DataView dataView = dropDownDataSource.DefaultView;
DataTable dataTableDistinct = null;
if (displayName == valueName)
{
dataTableDistinct = dataView.ToTable(true, displayName);
}
else
{
dataTableDistinct = dataView.ToTable(true, displayName, valueName);//注：其中ToTable（）的第一个参数为是否DISTINCT
}
tb_combo_box.DataSource = dataTableDistinct;
tb_combo_box.DisplayMember = displayName;
tb_combo_box.ValueMember = valueName;
}
/// <summary>
/// 更新
/// 使用model中的主键属性作为查询条件;
/// 使用Where查询条件;
/// 使用model中的非主键属性作为更新内容;
/// </summary>
/// <param name="update_model"></param>
public virtual void UpdateByPkWhere(OrmBaseModel update_model)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
dao.Update(session, update_model, true);
}
/// <summary>
/// 插入
/// 使用model作为插入内容;
/// </summary>
/// <param name="insert_model"></param>
public virtual void Insert(OrmBaseModel insert_model)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
dao.Insert(session, insert_model);
}
/// <summary>
/// 删除
/// 使用model作为查询条件;
/// </summary>
/// <param name="query_model"></param>
public virtual void Delete(OrmBaseModel query_model)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
dao.Delete(session, query_model, true);
}
/// <summary>
/// 自定义SQL查询
/// </summary>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public virtual DataTable UserDefinedQuery(DbConnection conn, DbTransaction dbTransaction, String sql, DbParameter[] parameters)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
return(dao.Select(session, sql, parameters));
}
/// <summary>
/// 自定义SQL语句，针对UPDATE/DELETE/INSERT
/// </summary>
/// <param name="conn"></param>
/// <param name="dbTransaction"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public virtual int UserDefinedSqlNotQuery(DbConnection conn, DbTransaction dbTransaction, String sql, DbParameter[] parameters)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
return(dao.executeSqlNotQuery(conn, dbTransaction, sql, parameters));
}
/// <summary>
/// 分页查询
/// 使用model作为查询条件;
/// 填写mdoel中当前页(current_page)和每页条数(page_item_count)分页信息
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query_model"></param>
/// <returns>List<T></returns>
public virtual List <T> QueryPage <T>(T query_model) where T : OrmBaseModel
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
return(dao.SelectPage <T>(session, query_model));
}
/// <summary>
/// 分页查询
/// 使用model作为查询条件;
/// 填写mdoel中当前页(current_page)和每页条数(page_item_count)分页信息
/// </summary>
/// <param name="query_model"></param>
/// <returns>DataTable</returns>
public virtual DataTable QueryPage_DT(OrmBaseModel query_model)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
return(dao.SelectPage(session, query_model));
}
/// <summary>
/// 反射调用控制器方法
/// </summary>
/// <param name="ControllerName">控制器类名</param>
/// <param name="MethodName">方法名</param>
/// <param name="parms">参数</param>
/// <returns></returns>
public static object ExecControllerMethod(String ControllerName, String MethodName, object[] parms)
{
object kepc = LTCingFWSet.GetInstanceBean(ControllerName);
MethodInfo info = kepc.GetType().GetMethod(MethodName, BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly);
object dt_data = info.Invoke(kepc, parms);
return(dt_data);
}
public virtual int QueryNewestRowIndex()
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
DataTable res = udDao.executeSqlQuery(session, mysql_get_max_row_id);
if (res.Rows[0][0] is System.DBNull)
{
return(0);
}
return(Convert.ToInt32(res.Rows[0][0]));
}
/// <summary>
/// 原数据库中存在则更新，不存在则插入
/// 使用model中的主键属性作为查询条件;
/// 使用Where查询条件;
/// 使用model中的非主键属性作为更新内容;
/// 使用model作为插入内容;
/// </summary>
/// <param name="update_model"></param>
public virtual void UpSertByPk(OrmBaseModel update_model)
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
DataTable rsl = dao.SelectByPrimaryKey(session, update_model);
if (rsl.Rows.Count == 1)
{
dao.Update(session, update_model, true);
}
else
{
dao.Insert(session, update_model);
}
}
/// <summary>
/// 查询单条
/// 使用model作为查询条件;
/// 根据model中的primarykey属性查询;
/// 根据model中的where属性查询;
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query_model"></param>
/// <returns>T</returns>
public virtual T QueryByPk <T>(T query_model) where T : OrmBaseModel
{
ThreadContext t = LTCingFWSet.GetThreadContext();
DBSession session = t.DBSession;
List <T> res = dao.SelectByPrimaryKey <T>(session, query_model);
if (res.Count == 1)
{
return(res[0]);
}
else
{
return(null);
}
}
public virtual void QueryValues(string columnID, string startTime, string endTime)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
ValueInfoOrmModel model = null;
if (session.ProviderName == DBSession.MySql_ProviderName)
{
model = new ValueInfoOrmModel();
}
if (model != null)
{
model.COLUMN_ID = columnID;
OrmBaseModel m = (OrmBaseModel)model;
m.Where = " UPDATE_TIME > '" + startTime + "' AND UPDATE_TIME < '" + endTime + "' ";
udDao.Select(session, m);
}
}
/// <summary>
/// 将DBSession加入到框架中
/// 目前支持mysql,sqlserver,oracle
/// </summary>
/// <param name="dbType"></param>
/// <param name="dbAlias"></param>
/// <param name="connStr"></param>
/// <param name=""></param>
public static void AddDBSession(string dbType, string dbAlias, string connStr)
{
if (dbType.ToLower().Trim() == "mysql")
{
String ProviderName = "MySql.Data.MySqlClient";
//server=127.0.0.1;database=test;user id=root;password=root;connectiontimeout=5;pooling=True;maxpoolsize=500;minpoolsize=1
LTCingFWSet.AddDB(dbAlias, ProviderName, connStr);
}
if (dbType.ToLower().Trim() == "sqlserver")
{
String ProviderName = "System.Data.SqlClient";
//Data Source=192.168.2.50;Initial Catalog=btmsdb;User ID=gserver;Password=Gserver246;Pooling=True;Min Pool Size=1;Max Pool Size=500;Connect Timeout=5
LTCingFWSet.AddDB(dbAlias, ProviderName, connStr);
}
if (dbType.ToLower().Trim() == "oracle")
{
String ProviderName = "Oracle.ManagedDataAccess.Client";
//DATA SOURCE=192.168.12.241:1522/fmsdb;USER ID=lgc;PASSWORD=FMSdba2018;POOLING=True;MAX POOL SIZE=500;DECR POOL SIZE=2;CONNECTION TIMEOUT=5;INCR POOL SIZE=5;MIN POOL SIZE=1
LTCingFWSet.AddDB(dbAlias, ProviderName, connStr);
}
}
public static Boolean IsDbAliasExist(string dbAlias)
{
return(LTCingFWSet.FindDbByAlias(dbAlias));
}
public virtual List <ValueInfoOrmModel> QueryValueInfo(ValueInfoOrmModel colModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.SelectT <ValueInfoOrmModel>(session, colModel));
}
public virtual int LockRowInfoTable()
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.executeSqlNotQuery(session, mysql_lock_table_write));
}
public virtual int UnLockTables()
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.executeSqlNotQuery(session, mysql_unlock_tables));
}
public virtual int UseUDDB()
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.executeSqlNotQuery(session, mysql_use_db));
}
public virtual int CreateUDMySqlTable()
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.executeSqlNotQuery(session, mysql_create_ud_table));
}
public virtual int InsertUDData(OrmBaseModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.Insert(session, tbModel));
}
public virtual int DeleteUDData(OrmBaseModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.Delete(session, tbModel, true));
}
public virtual DataTable QueryUDData(OrmBaseModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.Select(session, tbModel));
}
/// <summary>
/// 查询条数
/// 使用model作为查询条件;
/// 查询该条件下的所有条目
/// </summary>
/// <param name="query_model"></param>
/// <returns></returns>
public virtual int GetItemCount(OrmBaseModel query_model)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(dao.GetItemCount(session, query_model));
}
public virtual List <TableInfoOrmModel> QueryTableInfo(TableInfoOrmModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.SelectT <TableInfoOrmModel>(session, tbModel));
}
