/// <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>
/// 插入
/// 使用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>
/// 更新
/// 使用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>
/// 为OrmBaseModel的所有同名属性赋值
/// </summary>
/// <param name="from">源实例</param>
/// <param name="model">OrmBaseModel实例</param>
public static void AutoSetOrmModelProperty(object from, OrmBaseModel to)
{
PropertyInfo[] infos = to.GetType().GetProperties();
foreach (PropertyInfo t_info in infos)
{
object[] attrs = t_info.GetCustomAttributes(typeof(OrmColumnAttribute), true);
if (attrs.Length == 0)
{
if (t_info.Name != "OrderBy")
{
continue;
}
}
PropertyInfo f_info = from.GetType().GetProperty(t_info.Name);
if (f_info != null)
{
if (f_info.Name == "OrderBy")
{
t_info.SetValue(to, f_info.GetValue(from));
}
t_info.SetValue(to, f_info.GetValue(from));
}
}
FieldInfo[] finfos = to.GetType().GetFields(BindingFlags.NonPublic | BindingFlags.Instance);
foreach (FieldInfo t_info in finfos)
{
FieldInfo f_info = from.GetType().GetField(t_info.Name, BindingFlags.NonPublic | BindingFlags.Instance);
if (f_info != null)
{
t_info.SetValue(to, f_info.GetValue(from));
}
}
}
/// <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);
}
}
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>
/// 将DataGridViewRow的一行赋值给OrmModel
/// </summary>
/// <param name="row"></param>
/// <param name="to"></param>
public static void AutoSetOrmModelFromDataGridViewRow(DataGridViewRow row, OrmBaseModel to)
{
PropertyInfo[] infos = to.GetType().GetProperties();
foreach (PropertyInfo t_info in infos)
{
object[] attrs = t_info.GetCustomAttributes(typeof(OrmColumnAttribute), true);
if (attrs.Length == 0)
{
continue;
}
try
{
DataGridViewCell cell = row.Cells["col_" + t_info.Name];
object value = row.Cells["col_" + t_info.Name].Value.ToString();
t_info.SetValue(to, value);
}
catch (System.ArgumentException ex)
{
logger.Warn(ex.Message + ":" + ex.StackTrace);
}
}
}
/// <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 DataTable QueryUDData(OrmBaseModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.Select(session, tbModel));
}
public virtual int DeleteUDData(OrmBaseModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.Delete(session, tbModel, true));
}
public virtual int InsertUDData(OrmBaseModel tbModel)
{
DBSession session = LTCingFWSet.GetThreadContext().DBSession;
return(udDao.Insert(session, tbModel));
}
