/// <summary>
/// 增加
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Insert(Room value)
{
bool result = false;
string sql = string.Format("insert into e_room ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :name, :address, :contact, :phone)", 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("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 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;
}
/// <summary>
/// 增加
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Insert(Room value)
{
bool result = false;
RoomHibernate hibernate = new RoomHibernate();
result = hibernate.Insert(value);
return result;
}
public bool Delete(Room value)
{
bool result = false;
RoomHibernate hibernate = new RoomHibernate();
result = hibernate.Delete(value);
return result;
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
bool done = false;
StringBuilder stringBuilder = new StringBuilder();
RoomBusiness business = new RoomBusiness();
if (this.CheckBoxListRooms.Items != null)
{
List<Room> rooms = new List<Room>();
for (int i = 0; i < this.CheckBoxListRooms.Items.Count; i++)
{
if (this.CheckBoxListRooms.Items[i].Selected)
{
Room room = new Room();
room.Guid = this.CheckBoxListRooms.Items[i].Value;
rooms.Add(room);
}
}
if ((rooms != null) && (rooms.Count > 0))
{
int success = 0;
int fail = 0;
for (int i = 0; i < rooms.Count; i++)
{
done = business.Delete(rooms[i]);
if (done)
{
success++;
}
else
{
fail++;
}
}
stringBuilder.Append(string.Format("删除{0}个机房成功！", success));
stringBuilder.Append(string.Format("删除{0}个机房失败！", fail));
}
}
this.LabelMessage.Text = stringBuilder.ToString();
this.InitializeBind();
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
bool done = false;
StringBuilder stringBuilder = new StringBuilder();
RoomBusiness business = new RoomBusiness();
Room module = new Room();
this.InitializeInsertModule(module);
module.Name = this.TextBoxName.Text;
module.Address = this.TextBoxAddress.Text;
module.Contact = this.TextBoxContact.Text;
module.Phone = this.TextBoxPhone.Text;
Room room = business.QueryByName(module.Name);
if (room == null)
{
done = business.Insert(module);
if (done)
{
stringBuilder.Append("新增机房成功！");
}
else
{
stringBuilder.Append("新增机房失败！");
}
}
else
{
stringBuilder.Append("机房已经存在（名称相同）！");
}
this.LabelMessage.Text = stringBuilder.ToString();
this.InitializeBind();
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
StringBuilder stringBuilder = new StringBuilder();
DateTime now = DateTime.Now;
DateTime beginDate = new DateTime(now.Year, now.Month, 1);
DateTime endDate = beginDate.AddMonths(1).AddSeconds(-1);
try
{
if (!string.IsNullOrEmpty(this.TextBoxBeginDate.Text))
{
beginDate = DateTime.Parse(this.TextBoxBeginDate.Text);
}
if (!string.IsNullOrEmpty(this.TextBoxEndDate.Text))
{
endDate = DateTime.Parse(this.TextBoxEndDate.Text);
endDate = endDate.AddDays(1).AddSeconds(-1);
}
}
finally
{
}
if (this.DropDownListMachines.SelectedValue != null)
{
string guid = this.DropDownListMachines.SelectedValue;
if (!string.IsNullOrEmpty(guid))
{
MachineBusiness machineBusiness = new MachineBusiness();
this.Machine = machineBusiness.QueryByGuid(guid);
if (this.Machine != null)
{
if (!string.IsNullOrEmpty(this.Machine.RoomId))
{
RoomBusiness roomBusiness = new RoomBusiness();
this.Room = roomBusiness.QueryByGuid(this.Machine.RoomId);
}
if (!string.IsNullOrEmpty(this.Machine.Guid))
{
DetectorBusiness detectorBusiness = new DetectorBusiness();
this.Detectors = detectorBusiness.QueryByMachine(this.Machine.Guid);
this.NormalDataCaches = detectorBusiness.QueryNormalDataCacheByMachine(this.Machine.Guid, beginDate, endDate);
this.AlarmDataCaches = detectorBusiness.QueryAlarmDataCacheByMachine(this.Machine.Guid, beginDate, endDate);
MessageCacheBusiness messageCacheBusiness = new MessageCacheBusiness();
this.MessageCaches = messageCacheBusiness.QueryByMachine(this.Machine.Guid, beginDate, endDate);
}
}
}
else
{
stringBuilder.Append("没有选择检测仪！");
}
}
this.LabelMessage.Text = stringBuilder.ToString();
}
private void InitializeBind()
{
this.TextBoxName.Text = string.Empty;
this.TextBoxAddress.Text = string.Empty;
this.TextBoxContact.Text = string.Empty;
this.TextBoxPhone.Text = string.Empty;
RoomBusiness business = new RoomBusiness();
int total = 0;
List<Room> rooms = business.Query(1, int.MaxValue, ref total);
Room emptyRoom = new Room();
emptyRoom.Guid = string.Empty;
emptyRoom.Name = string.Empty;
rooms.Insert(0, emptyRoom);
this.DropDownListRooms.DataSource = rooms;
this.DropDownListRooms.DataTextField = "Name";
this.DropDownListRooms.DataValueField = "Guid";
this.DropDownListRooms.DataBind();
}
/// <summary>
/// 解析数据
/// </summary>
/// <param name="values">数据</param>
/// <returns>机房</returns>
public Room Parse(object[] values)
{
Room result = new Room();
try
{
result = DatabaseHibernate.ParseModule(result, values) as Room;
result.Name = DatabaseHibernate.ParseString(values[7]);
result.Address = DatabaseHibernate.ParseString(values[8]);
result.Contact = DatabaseHibernate.ParseString(values[9]);
result.Phone = DatabaseHibernate.ParseString(values[10]);
}
catch (Exception exception)
{
result = null;
EnvironmentalMonitor.Support.Resource.Variable.Logger.Log(exception);
}
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 Room QueryByName(string name)
{
Room result = null;
string sql = string.Format("select {0} from e_room as t where ucase([t].[name]) = ucase(:name)", this.Asterisk("[t]."));
List<Parameter> parameters = new List<Parameter>();
parameters.Add(new Parameter("name", DatabaseHibernate.Parameter(name)));
DatabaseHibernate hibernate = new DatabaseHibernate();
List<object[]> values = hibernate.Read(Variable.Link, sql, parameters);
if ((values != null) && (values.Count == 1))
{
result = new Room();
object[] moduleValues = values[0];
result = this.Parse(moduleValues);
}
return result;
}
public Room QueryByGuid(string guid)
{
Room result = null;
string sql = string.Format("select {0} from e_room as t where [t].[guid] = '{1}'", this.Asterisk("[t]."), guid);
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))
{
result = new Room();
object[] moduleValues = values[0];
result = this.Parse(moduleValues);
}
return result;
}