public bool DeleteByRoom(string roomGuid)
{
bool result = false;
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0} from e_machine as t where [t].[room_id] = '{1}'", this.Asterisk("[t]."), roomGuid);
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
List<Machine> results = this.Parse(values);
if ((results != null) && (results.Count > 0))
{
for (int i = 0; i < results.Count; i++)
{
result = this.Delete(results[i]);
if (!result)
{
break;
}
}
}
else
{
result = true;
}
return result;
}
public bool Delete(Room value)
{
bool result = false;
MachineHibernate machineHibernate = new MachineHibernate();
result = machineHibernate.DeleteByRoom(value.Guid);
DatabaseHibernate hibernate = new DatabaseHibernate();
List<Parameter> parameters = new List<Parameter>();
if (result)
{
string sql = string.Format("delete from e_user_room as t where [t].[room_id] = '{0}'", value.Guid);
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
}
if (result)
{
string sql = string.Format("delete from e_room as t where [t].[guid] = '{0}'", value.Guid);
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
}
return result;
}
public bool Insert(Detector value)
{
bool result = false;
string sql = string.Format("insert into e_detector ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :machine_id, :detector_type_id, :serial, minimum_a, maximum_a, minimum_b, maximum_b, null, null)", this.Asterisk(""));
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID())));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("machine_id", DatabaseHibernate.Parameter(value.MachineId)));
parameters.Add(new Parameter("detector_type_id", DatabaseHibernate.Parameter(value.DetectorTypeId)));
parameters.Add(new Parameter("serial", DatabaseHibernate.Parameter(value.Serial)));
parameters.Add(new Parameter("minimum_a", DatabaseHibernate.Parameter(value.MinimumA)));
parameters.Add(new Parameter("maximum_a", DatabaseHibernate.Parameter(value.MaximumA)));
parameters.Add(new Parameter("minimum_b", DatabaseHibernate.Parameter(value.MinimumB)));
parameters.Add(new Parameter("maximum_b", DatabaseHibernate.Parameter(value.MaximumB)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public bool Delete(User value)
{
bool result = false;
string sql = string.Format("delete from m_user_module as t where [t].[user_id] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
if (result)
{
sql = string.Format("delete from e_user_room as t where [t].[user_id] = '{0}'", value.Guid);
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
}
if (result)
{
sql = string.Format("delete from m_user as t where [t].[guid] = '{0}'", value.Guid);
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
}
return result;
}
public bool Insert(List<Module.Environmental.DataCache> values)
{
bool result = false;
DatabaseHibernate hibernate = new DatabaseHibernate();
if (values != null)
{
string sql = string.Empty;
List<Parameter> parameters = new List<Parameter>();
for (int i = 0; i < values.Count; i++)
{
DateTime refreshTime = DateTime.Now;
refreshTime = refreshTime.AddDays(-100);
sql = string.Format("delete from e_data_cache where [refresh_time] < #{0}#", refreshTime.ToString("yyyy-MM-dd HH:mm:ss"));
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
if (!result)
{
break;
}
sql = string.Format("update e_data_cache set [newest] = :newest where [detector_id] = '{0}'", values[i].DetectorId);
parameters.Clear();
parameters.Add(new Parameter("newest", DatabaseHibernate.Parameter(false)));
result = hibernate.Write(Variable.Link, sql, parameters);
if (!result)
{
break;
}
sql = string.Format("insert into e_data_cache ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :detector_id, :value, :refresh_time, :newest)", this.Asterisk(""));
parameters.Clear();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID())));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(values[i].InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(values[i].InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(values[i].UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(values[i].UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(values[i].Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(values[i].Validity)));
parameters.Add(new Parameter("detector_id", DatabaseHibernate.Parameter(values[i].DetectorId)));
parameters.Add(new Parameter("value", DatabaseHibernate.Parameter(values[i].Value)));
parameters.Add(new Parameter("refresh_time", DatabaseHibernate.Parameter(values[i].RefreshTime)));
parameters.Add(new Parameter("newest", DatabaseHibernate.Parameter(values[i].Newest)));
result = hibernate.Write(Variable.Link, sql, parameters);
if (!result)
{
break;
}
}
}
return result;
}
public bool Delete(Detector value)
{
bool result = false;
string sql = string.Format("delete from e_detector as t where [t].[guid] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public bool DeleteByUser(string userGuid)
{
bool result = false;
string sql = string.Format("delete from e_user_room as t where [t].[user_id] = '{0}'", userGuid);
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public bool ChangePassword(string guid, string password)
{
bool result = false;
string sql = string.Format("update m_user as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[password] = :password where [t].[guid] = '{0}'", guid);
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(guid)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(DateTime.Now)));
parameters.Add(new Parameter("password", DatabaseHibernate.Parameter(password)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public bool Insert(MessageCache value)
{
bool result = false;
DatabaseHibernate hibernate = new DatabaseHibernate();
if (value != null)
{
string sql = string.Empty;
List<Parameter> parameters = new List<Parameter>();
DateTime refreshTime = DateTime.Now;
refreshTime = refreshTime.AddDays(-100);
sql = string.Format("delete from e_message_cache where [refresh_time] < #{0}#", refreshTime.ToString("yyyy-MM-dd HH:mm:ss"));
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
if (result)
{
sql = string.Format("insert into e_message_cache ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :ip, :machine, :code, :result, :send_time, :refresh_time)", this.Asterisk(""));
parameters.Clear();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID())));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("ip", DatabaseHibernate.Parameter(value.Ip)));
parameters.Add(new Parameter("machine_id", DatabaseHibernate.Parameter(value.MachineId)));
parameters.Add(new Parameter("code", DatabaseHibernate.Parameter(value.Code)));
parameters.Add(new Parameter("result", DatabaseHibernate.Parameter(value.Result)));
parameters.Add(new Parameter("send_time", DatabaseHibernate.Parameter(value.SendTime)));
parameters.Add(new Parameter("refresh_time", DatabaseHibernate.Parameter(value.RefreshTime)));
result = hibernate.Write(Variable.Link, sql, parameters);
}
}
return result;
}
/// <summary>
/// 总数
/// </summary>
/// <returns>总数</returns>
public int Count()
{
int result = -1;
string sql = "select count([t].[guid]) from m_user as t";
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
if ((values != null) && (values.Count == 1))
{
object[] moduleValues = values[0];
result = DatabaseHibernate.ParseInt(moduleValues[0]);
}
return result;
}
public bool Delete(Machine value)
{
bool result = false;
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("delete from e_detector as t where [t].[machine_id] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
result = hibernate.Write(Variable.Link, sql, parameters);
if (result)
{
sql = string.Format("delete from e_machine as t where [t].[guid] = '{0}'", value.Guid);
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
}
return result;
}
/// <summary>
/// 增加
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Insert(UserRoom value)
{
bool result = false;
string sql = string.Format("insert into e_user_room ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :user_id, :room_id)", this.Asterisk(""));
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID())));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("user_id", DatabaseHibernate.Parameter(value.UserId)));
parameters.Add(new Parameter("room_id", DatabaseHibernate.Parameter(value.RoomId)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
/// <summary>
/// 通过帐户查询
/// </summary>
/// <param name="account">帐号</param>
/// <returns>用户</returns>
public User SelectByAccount(string account)
{
User result = null;
string sql = string.Format("select {0} from m_user as t where ucase([t].[account]) = ucase(:account)", this.Asterisk("[t]."));
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("account", DatabaseHibernate.Parameter(account)));
DatabaseHibernate hibernate = new DatabaseHibernate();
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
if ((values != null) && (values.Count == 1))
{
result = new User();
object[] moduleValues = values[0];
result = this.Parse(moduleValues);
}
return result;
}
public List<User> QueryByInsertUser(string insertUserId)
{
List<User> results = null;
string sql = string.Format("select {0} from m_user as t where[t].[insert_user_id] = '{1}'", this.Asterisk("[t]."), insertUserId);
List<Parameter> parameters = new List<Parameter>();
parameters.Clear();
DatabaseHibernate hibernate = new DatabaseHibernate();
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
results = this.Parse(values);
return results;
}
/// <summary>
/// 通过主键查询
/// </summary>
/// <param name="guid">主键</param>
/// <returns>用户</returns>
public User QueryByGuid(string guid)
{
User result = null;
string sql = string.Format("select {0} from m_user as t where [t].[guid] = :guid", this.Asterisk("[t]."));
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(guid)));
DatabaseHibernate hibernate = new DatabaseHibernate();
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
if ((values != null) && (values.Count == 1))
{
result = new User();
object[] moduleValues = values[0];
result = this.Parse(moduleValues);
}
return result;
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="page">页码</param>
/// <param name="rows">每页行数</param>
/// <param name="total">总数</param>
/// <returns>用户集合</returns>
public List<User> Query(int page, int rows, ref int total)
{
List<User> results = new List<User>();
string sql = string.Format("select {0} from m_user as t order by [t].[name]", this.Asterisk("[t]."));
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string countSql = string.Format("select count(*) from ({0})", sql);
parameters.Clear();
List<object[]> values = hibernate.Read(Variable.Link, countSql, parameters);
if ((values != null) && (values.Count == 1))
{
object[] moduleValues = values[0];
total = DatabaseHibernate.ParseInt(moduleValues[0]);
}
string querySql = sql;
parameters.Clear();
values = hibernate.Read(Variable.Link, querySql, parameters, page, rows);
results = this.Parse(values);
return results;
}
/// <summary>
/// 增加
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Insert(User value)
{
bool result = false;
string sql = string.Format("insert into m_user ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :name, :account, :password, :prerogative)", this.Asterisk(""));
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID())));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name)));
parameters.Add(new Parameter("account", DatabaseHibernate.Parameter(value.Account.ToUpper())));
parameters.Add(new Parameter("password", DatabaseHibernate.Parameter(value.Password)));
parameters.Add(new Parameter("prerogative", DatabaseHibernate.Parameter(value.Prerogative)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public List<MessageCache> QueryByMachine(string machineId, DateTime beginDate, DateTime endDate)
{
List<MessageCache> results = new List<MessageCache>();
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0} from e_message_cache as t where ([t].[send_time] >= :beginDate and [t].[send_time] <= :endDate) and [t].[machine_id] = '{1}' order by [t].[send_time] desc", this.Asterisk("[t]."), machineId);
parameters.Add(new Parameter("beginDate", DatabaseHibernate.Parameter(beginDate)));
parameters.Add(new Parameter("endDate", DatabaseHibernate.Parameter(endDate)));
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
results = this.Parse(values);
return results;
}
public List<Detector> QueryDataCacheByMachine(string machineId)
{
List<Detector> results = new List<Detector>();
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0}, [v].[value], [v].[refresh_time] from (select t_a.* from e_detector as t_a left join e_machine as u_a on [t_a].[machine_id] = [u_a].[guid]) as t, e_data_cache as v where [t].[guid] = [v].[detector_id] and [v].[newest] = 1 and [t].[machine_id] = '{1}' order by [t].[serial], [v].[refresh_time] desc", this.Asterisk("[t]."), machineId);
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
results = this.ParseDataCache(values);
return results;
}
public bool UpdatePosition(List<Detector> detectors)
{
bool result = false;
DatabaseHibernate hibernate = new DatabaseHibernate();
for (int i = 0; i < detectors.Count; i++)
{
string sql = string.Format("update e_detector as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[position_x] = :position_x, [t].[position_y] = :position_y where [t].[guid] = '{0}'", detectors[i].Guid);
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(detectors[i].UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(detectors[i].UpdateTime)));
parameters.Add(new Parameter("machine_id", DatabaseHibernate.Parameter(detectors[i].PositionX)));
parameters.Add(new Parameter("machine_id", DatabaseHibernate.Parameter(detectors[i].PositionY)));
result = hibernate.Write(Variable.Link, sql, parameters);
if (!result)
{
break;
}
}
return result;
}
public Detector QueryByGuid(string guid)
{
Detector result = null;
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0} from e_detector as t where [t].[guid] = '{1}'", this.Asterisk("[t]."), guid);
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
List<Detector> detectors = this.Parse(values);
if ((detectors != null) && (detectors.Count > 0))
{
result = detectors[0];
}
return result;
}
public DetectorType QueryByNameOrCode(string name, byte code)
{
DetectorType result = null;
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0} from e_detector_type as t where (([t].[name] = :name) or ([t].[code] = :code))", this.Asterisk("[t]."));
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(name)));
parameters.Add(new Parameter("code", DatabaseHibernate.Parameter(code)));
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
List<DetectorType> results = this.Parse(values);
if ((results != null) && (results.Count > 0))
{
result = results[0];
}
return result;
}
public bool Update(Detector value)
{
bool result = false;
string sql = string.Format("update e_detector as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[remark] = :remark, [t].[validity] = :validity, [t].[machine_id] = :machine_id, [t].[detector_type_id] = :detector_type_id, [t].[serial] = :serial, [t].[minimum_a] = :minimum_a, [t].[maximum_a] = :maximum_a, [t].[minimum_b] = :minimum_b, [t].[maximum_b] = :maximum_b where [t].[guid] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("machine_id", DatabaseHibernate.Parameter(value.MachineId)));
parameters.Add(new Parameter("detector_type_id", DatabaseHibernate.Parameter(value.DetectorTypeId)));
parameters.Add(new Parameter("serial", DatabaseHibernate.Parameter(value.Serial)));
parameters.Add(new Parameter("minimum_a", DatabaseHibernate.Parameter(value.MinimumA)));
parameters.Add(new Parameter("maximum_a", DatabaseHibernate.Parameter(value.MaximumA)));
parameters.Add(new Parameter("minimum_b", DatabaseHibernate.Parameter(value.MinimumB)));
parameters.Add(new Parameter("maximum_b", DatabaseHibernate.Parameter(value.MaximumB)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public List<Detector> QueryNormalDataCacheByMachine(string machineId, DateTime beginDate, DateTime endDate)
{
List<Detector> results = new List<Detector>();
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0}, [v].[value], [v].[refresh_time] from (select t_a.* from e_detector as t_a left join e_machine as u_a on [t_a].[machine_id] = [u_a].[guid]) as t, e_data_cache as v where [t].[guid] = [v].[detector_id] and ([v].[refresh_time] >= :beginDate and [v].[refresh_time] <= :endDate) and [v].[update_user_id] >= :type and [t].[machine_id] = '{1}' order by [v].[refresh_time] desc, [t].[serial]", this.Asterisk("[t]."), machineId);
parameters.Add(new Parameter("beginDate", DatabaseHibernate.Parameter(beginDate)));
parameters.Add(new Parameter("endDate", DatabaseHibernate.Parameter(endDate)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter("UploadInstruction")));
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
results = this.ParseDataCache(values);
return results;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Update(User value)
{
bool result = false;
string sql = string.Format("update m_user as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[remark] = :remark, [t].[validity] = :validity, [t].[name] = :name, [t].[account] = :account, [t].[password] = :password, [t].[prerogative] = :prerogative where [t].[guid] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name)));
parameters.Add(new Parameter("account", DatabaseHibernate.Parameter(value.Account.ToUpper())));
parameters.Add(new Parameter("password", DatabaseHibernate.Parameter(value.Password)));
parameters.Add(new Parameter("prerogative", DatabaseHibernate.Parameter(value.Prerogative)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Update(DetectorType value)
{
bool result = false;
string sql = string.Format("update e_detector_type as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[remark] = :remark, [t].[validity] = :validity, [t].[name] = :name, [t].[type] = :type, [t].[code] = :code, [t].[description_a] = :description_a, [t].[description_b] = :description_b, [t].[unit_a] = :unit_a, [t].[unit_b] = :unit_b where [t].[guid] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name)));
parameters.Add(new Parameter("type", DatabaseHibernate.Parameter((int)value.Type)));
parameters.Add(new Parameter("code", DatabaseHibernate.Parameter(value.Code)));
parameters.Add(new Parameter("description_a", DatabaseHibernate.Parameter(value.DescriptionA)));
parameters.Add(new Parameter("description_b", DatabaseHibernate.Parameter(value.DescriptionB)));
parameters.Add(new Parameter("unit_a", DatabaseHibernate.Parameter(value.UnitA)));
parameters.Add(new Parameter("unit_b", DatabaseHibernate.Parameter(value.UnitB)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Update(Room value)
{
bool result = false;
string sql = string.Format("update e_room as t set [t].[update_user_id] = :update_user_id, [t].[update_time] = :update_time, [t].[remark] = :remark, [t].[validity] = :validity, [t].[name] = :name, [t].[address] = :address, [t].[contact] = :contact, [t].[phone] = :phone where [t].[guid] = '{0}'", value.Guid);
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name)));
parameters.Add(new Parameter("address", DatabaseHibernate.Parameter(value.Address)));
parameters.Add(new Parameter("contact", DatabaseHibernate.Parameter(value.Contact)));
parameters.Add(new Parameter("phone", DatabaseHibernate.Parameter(value.Phone)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
public List<Module.Environmental.Detector> QueryByMachine(string machineId)
{
List<Detector> results = new List<Detector>();
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string sql = string.Format("select {0} from e_detector as t left join e_machine as u on [t].[machine_id] = [u].[guid] where [t].[machine_id] = '{1}' order by [t].[serial]", this.Asterisk("[t]."), machineId);
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
results = this.Parse(values);
return results;
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="page">页码</param>
/// <param name="rows">每页行数</param>
/// <param name="total">总数</param>
/// <param name="userGuid"></param>
/// <returns>用户和房间关系集合</returns>
public List<UserRoom> QueryByUser(int page, int rows, ref int total, string userGuid)
{
List<UserRoom> results = new List<UserRoom>();
string sql = string.Format("select {0} from e_user_room as t, e_room as u where [t].[room_id] = [u].[guid] and [t].[user_id] = '{1}' order by [u].[name]", this.Asterisk("[t]."), userGuid);
List<Parameter> parameters = new List<Parameter>();
DatabaseHibernate hibernate = new DatabaseHibernate();
string countSql = string.Format("select count(*) from ({0})", sql);
parameters.Clear();
List<object[]> values = hibernate.Read(Variable.Link, countSql, parameters);
if ((values != null) && (values.Count == 1))
{
object[] moduleValues = values[0];
total = DatabaseHibernate.ParseInt(moduleValues[0]);
}
string querySql = sql;
parameters.Clear();
values = hibernate.Read(Variable.Link, querySql, parameters, page, rows);
results = this.Parse(values);
return results;
}
/// <summary>
/// 增加
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Insert(DetectorType value)
{
bool result = false;
string sql = string.Format("insert into e_detector_type ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :name, :type, :code, :description_a, :description_b, :unit_a, :unit_b)", this.Asterisk(""));
List<Parameter> parameters = new List<Parameter>();
if (string.IsNullOrEmpty(value.Guid))
{
value.Guid = DatabaseHibernate.GUID();
}
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(value.Guid)));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(value.Name)));
parameters.Add(new Parameter("type", DatabaseHibernate.Parameter((int)value.Type)));
parameters.Add(new Parameter("code", DatabaseHibernate.Parameter(value.Code)));
parameters.Add(new Parameter("description_a", DatabaseHibernate.Parameter(value.DescriptionA)));
parameters.Add(new Parameter("description_b", DatabaseHibernate.Parameter(value.DescriptionB)));
parameters.Add(new Parameter("unit_a", DatabaseHibernate.Parameter(value.UnitA)));
parameters.Add(new Parameter("unit_b", DatabaseHibernate.Parameter(value.UnitB)));
DatabaseHibernate hibernate = new DatabaseHibernate();
result = hibernate.Write(Variable.Link, sql, parameters);
return result;
}
