/// <summary>
/// 查询设备信息
/// </summary>
/// <param name="operationNumber"></param>
/// <returns></returns>
public ActionResult OnSearchEquipment(string operationNumber)
{
StatusReport sr = new StatusReport();
sr = EquipmentDal.SearchEquipment(operationNumber);
return(Json(sr));
}
public ActionResult OnSetEquipmentImage()
{
StatusReport sr = new StatusReport();
if (Request.Files.Count == 0)
{
sr.status = "Fail";
sr.result = "没有图片";
return(Json(sr));
}
try
{
string mainPath = "F:\\wytws\\Files\\bywj\\";
string imagePath = mainPath + Request.Files.AllKeys[0];
string sqlImagePath = Request.Files.AllKeys[0];
HttpPostedFileBase uploadImage = (Request.Files[0]);
uploadImage.SaveAs(imagePath);
string ID = Request.Form["ID"];
string func = Request.Form["func"];
sr = EquipmentDal.SetEquipmentImage(ID, func, sqlImagePath);
return(Json(sr));
}
catch (NotImplementedException exp)
{
sr.status = "Fail";
sr.result = exp.Message;
return(Json(sr));
}
}
private void loadData()
{
lastSensor = ConfigurationManager.AppSettings["lastSensor"].ToString();
lastGas = ConfigurationManager.AppSettings["lastGas"].ToString();
mainList = EquipmentDal.GetListIn();
var sql = from a in mainList
group a by a.Name into g
select new
{
g.Key
};
comboBoxEdit1.Properties.Items.Clear();
sql.ToList().ForEach(c => { comboBoxEdit1.Properties.Items.Add(c.Key); });
if (sql.ToList().Count > 0)
{
foreach (var item in comboBoxEdit1.Properties.Items)
{
if (item.ToString() == lastSensor)
{
comboBoxEdit1.SelectedText = lastSensor;
break;
}
else
{
comboBoxEdit1.SelectedIndex = 0;
}
}
}
}
private void loadData()
{
mainList = EquipmentDal.GetListIn();
mainList = mainList.OrderBy(c => c.ID).ToList();
checkedComboBoxEdit1.Properties.Items.Clear();
mainList.ForEach(c => { checkedComboBoxEdit1.Properties.Items.Add(c.ID, c.Name + "," + c.Address + "," + c.SensorTypeB + "," + c.GasName); });
}
private void btn_UpdateAdd_Click(object sender, EventArgs e)
{
try
{
Equipment eee = gridView_Add.GetFocusedRow() as Equipment;
List <byte> adds = EquipmentDal.GetAddress();
// 不能和自己比较
adds.Remove(eee.Address);
Equipment upd = GetAddEquip();
if (adds.Contains(upd.Address))
{
XtraMessageBox.Show("ID重复，请重新输入");
return;
}
eee.Address = upd.Address;
eee.EName = upd.EName;
eee.Range = upd.Range;
eee.Unit = upd.Unit;
eee.Point = upd.Point;
eee.Revise = upd.Revise;
eee.HighAlert = upd.HighAlert;
eee.LowAlert = upd.LowAlert;
eee.AlertType = upd.AlertType;
eee.Place = upd.Place;
EquipmentDal.UpdateOne(eee);
RefreshenAdd();
}
catch (Exception ex)
{
LogLib.Log.GetLogger(this).Warn(ex);
}
}
// GET: Statistics
public ActionResult OnGetStatistics(string ztcode, string level, string func, string username, string before, string month)
{
StatusReport sr = new StatusReport();
if (string.IsNullOrEmpty(level) || string.IsNullOrEmpty(func))
{
sr.status = "Fail";
sr.result = "信息不完整";
return(Json(sr));
}
switch (func)
{
case "收费统计":
sr = ChargeDal.GetChargeStatistics(ztcode, level, username, month);
break;
case "工单统计":
sr = RepairDal.GetRepairStatistics(ztcode, level, username, before);
break;
case "设备统计":
sr = EquipmentDal.GetEquipmentStatistics(ztcode, level);
break;
case "投诉统计":
sr = ComplainDal.GetComplainStatistics(ztcode, level, before);
break;
case "设备故障统计":
sr = EquipmentDal.GetEquipmentTroubleStatistics(ztcode, level);
break;
}
return(Json(sr));
}
private void InitList()
{
list = EquipmentDal.GetAllList();
gridControl1.DataSource = list;
gridControl1.RefreshDataSource();
gridView1.BestFitColumns();
}
public ActionResult OnSetEquipmentTroubleImage()
{
StatusReport sr = new StatusReport();
if (Request.Files.Count == 0)
{
sr.status = "Fail";
sr.result = "没有图片";
return(Json(sr));
}
try
{
string mainPath = Comman.file_main_path + "基础资料_设备故障管理\\";
string imagePath = mainPath + Request.Files.AllKeys[0];
HttpPostedFileBase uploadImage = (Request.Files[0]);
uploadImage.SaveAs(imagePath);
string ID = Request.Form["id"];
string func = Request.Form["func"];
string index = Request.Form["index"];
string sqlImagePath = "~~-" + (3382 + Convert.ToInt32(index)) + "-" + ID.ToString() + "|" + Request.Files.AllKeys[0];
sr = EquipmentDal.SetEquipmentTroubleImage(ID, func, index, sqlImagePath);
return(Json(sr));
}
catch (NotImplementedException exp)
{
sr.status = "Fail";
sr.result = exp.Message;
return(Json(sr));
}
}
/// <summary>
/// 提交设备故障维修情况
/// </summary>
/// <param name="id"></param>
/// <param name="fee"></param>
/// <param name="doneTime"></param>
/// <param name="doneInfo"></param>
/// <returns></returns>
public ActionResult OnSetEquipmentTrouble(string id, string fee, string doneTime, string doneInfo)
{
StatusReport sr = new StatusReport();
sr = EquipmentDal.SetEquipmentTrouble(id, fee, doneInfo, doneTime);
return(Json(sr));
}
private void initList()
{
list = EquipmentDal.GetAllList();
if (list == null || list.Count < 1)
{
return;
}
gridControl1.DataSource = list;
}
private void btn_two_Click(object sender, EventArgs e)
{
Form_set fs = new Form_set("二级报警点");
if (fs.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return;
}
float f1;
if (float.TryParse(fs.valueStr, out f1))
{
if (f1 < eqOne.A1 || f1 > eqOne.Max)
{
XtraMessageBox.Show("A2报警值超过量程或者小于A1");
return;
}
if (f1 < 0 || f1 > 999999)
{
XtraMessageBox.Show("设置值只能为0~999999");
return;
}
eqOne.A2 = f1;
EquipmentDal.UpdateOne(eqOne);
UpdateGridControl(eqOne);
textEdit_Two.Text = eqOne.A2Str;
XtraMessageBox.Show("设置二级报警点成功");
#region 以前设置到仪器里面
//byte[] content = BitConverter.GetBytes(f1);
//Array.Reverse(content, 0, 2);
//Array.Reverse(content, 2, 2);
//Command cd = new Command(eqOne.Address, (byte)eqOne.SensorType, (byte)EM_LowType_U.A2报警点, content);
//if (CommandResult.GetResult(cd))
//{
// SendSaveCommand();
// eqOne.A2 = f1;
// EquipmentDal.UpdateOne(eqOne);
// UpdateGridControl(eqOne);
// textEdit_Two.Text = eqOne.A2Str;
// XtraMessageBox.Show("设置二级报警点成功");
//}
//else
//{
// XtraMessageBox.Show("设置二级报警点失败");
//}
#endregion
}
else
{
XtraMessageBox.Show("只能为数字");
}
}
public ActionResult OnGetEquipment(string classify, string isDone)
{
StatusReport sr = new StatusReport();
if (string.IsNullOrEmpty(classify) || string.IsNullOrEmpty(isDone))
{
sr.status = "Fail";
sr.result = "信息不完整";
return(Json(sr));
}
sr = EquipmentDal.GetEquipment(classify, isDone);
return(Json(sr));
}
public ActionResult OnSetEquipment(string id, string isDone, string inputMan, string doneInfo, string inputDate)
{
StatusReport sr = new StatusReport();
if (string.IsNullOrEmpty(id))
{
sr.status = "Fail";
sr.result = "ID不能为空";
return(Json(sr));
}
sr = EquipmentDal.SetEquipment(id, isDone, inputMan, doneInfo, inputDate);
return(Json(sr));
}
// 删除
private void simpleButton2_Click(object sender, EventArgs e)
{
Equipment eq1 = gridView1.GetFocusedRow() as Equipment;
if (EquipmentDal.DeleteListByName(eq1.Name))
{
XtraMessageBox.Show("删除设备成功");
InitList();
}
else
{
XtraMessageBox.Show("删除设备失败");
}
}
private void upDataAddress(byte old, byte address)
{
foreach (Equipment eq in list)
{
if (eq.Address != old)
{
continue;
}
eq.Address = address;
EquipmentDal.UpdateOne(eq);
}
setCapution();
gridControl1.RefreshDataSource();
}
private void btn_DeleteAdd_Click(object sender, EventArgs e)
{
try
{
Equipment eee = gridView_Add.GetFocusedRow() as Equipment;
EquipmentDal.DeleteOne(eee);
mainList.Remove(eee);
RefreshenAdd();
}
catch (Exception ex)
{
LogLib.Log.GetLogger(this).Warn(ex);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(textEdit1.Text))
{
SensorName = textEdit1.Text;
}
else
{
XtraMessageBox.Show("名称不能为空");
return;
}
byte add;
if (Byte.TryParse(textEdit3.Text, out add))
{
Address = add;
}
else
{
XtraMessageBox.Show("地址必须为正整数");
return;
}
if (EquipmentDal.GetNames().Contains(SensorName))
{
XtraMessageBox.Show("设备存在重名");
return;
}
if (EquipmentDal.GetAddress().Contains(add))
{
XtraMessageBox.Show("地址已存在,请先删除设备");
return;
}
mEquipment.Name = textEdit1.Text;
mEquipment.GasName = textEdit2.Text;
mEquipment.SensorTypeB = textEdit3.Text;
mEquipment.Address = Convert.ToByte(textEdit4.Text);
mEquipment.A2 = Convert.ToSingle(textEdit5.Text);
mEquipment.A1 = Convert.ToSingle(textEdit6.Text);
mEquipment.Point = Convert.ToByte(textEdit7.Text);
mEquipment.Max = Convert.ToUInt32(textEdit8.Text);
mEquipment.UnitType = Convert.ToUInt16(textEdit9.Text);
mEquipment.biNnum = Convert.ToUInt16(textEdit10.Text);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
// 更新
private void simpleButton3_Click(object sender, EventArgs e)
{
Equipment eq = gridView1.GetFocusedRow() as Equipment;
AddDeviceForm addform = new AddDeviceForm(eq);
if (addform.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (!EquipmentDal.UpdateOne(addform.mEquipment))
{
XtraMessageBox.Show("更新设备失败");
}
else
{
InitList();
}
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
bool flag = false;
if (eqOne != null)
{
flag = EquipmentDal.UpdateOneParm(eqOne, txt_SensorName.Text);
}
if (flag)
{
XtraMessageBox.Show("设置成功！");
}
else
{
XtraMessageBox.Show("设置失败！");
}
}
// 添加
private void simpleButton1_Click(object sender, EventArgs e)
{
byte addr = list == null ? (byte)0 : list.LastOrDefault().Address;
AddDeviceForm addfff = new AddDeviceForm(addr);
if (addfff.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (!EquipmentDal.AddOne(addfff.mEquipment))
{
LogLib.Log.GetLogger(this).Warn("插入失败");
XtraMessageBox.Show("添加设备失败");
}
else
{
InitList();
}
}
}
private void Form_InputData_Load(object sender, EventArgs e)
{
mainList = EquipmentDal.GetAllList();
var sql = from a in mainList
group a by a.Name into g
select new
{
g.Key
};
sql.ToList().ForEach(c => { comboBoxEdit1.Properties.Items.Add(c.Key); });
if (sql.ToList().Count > 0)
{
comboBoxEdit1.SelectedIndex = 0;
}
port = PLAASerialPort.GetInstance();
}
public ActionResult OnSetEquipmentImage()
{
StatusReport sr = new StatusReport();
if (Request.Files.Count == 0)
{
sr.status = "Fail";
sr.result = "没有图片";
return(Json(sr));
}
string ID = Request.Form["id"];
string func = Request.Form["func"];
string fileName = Request.Files.AllKeys[0];
sr = EquipmentDal.SetEquipmentImage(ID, func, fileName);
sr = SetImage(Request);
return(Json(sr));
}
private void Initlist()
{
List <Equipment> list = EquipmentDal.GetAllList();
if (list == null || list.Count < 1)
{
UnEnabled();
}
else
{
list2 = list.GroupBy(c => c.Name).Select(it => it.First()).ToList();
list2.ForEach(c =>
{
comboBoxEdit1.Properties.Items.Add(c.Name);
});
comboBoxEdit1.SelectedIndex = 0;
eqNow = list2.First();
}
}
public ActionResult OnSetEquipmentTroubleImage()
{
StatusReport sr = new StatusReport();
if (Request.Files.Count == 0)
{
sr.status = "Fail";
sr.result = "没有图片";
return(Json(sr));
}
string ID = Request.Form["id"];
string func = Request.Form["func"];
string index = Request.Form["index"];
string fileName = "~~-" + (3383 + Convert.ToInt32(index)) + "-" + ID.ToString() + "|" + Request.Files.AllKeys[0];
sr = EquipmentDal.SetEquipmentTroubleImage(ID, func, index, fileName);
sr = SetImage(Request);
return(Json(sr));
}
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left && e.Clicks == 2)
{
Equipment eq = gridView1.GetFocusedRow() as Equipment;
AddDeviceForm addform = new AddDeviceForm(eq);
if (addform.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (!EquipmentDal.UpdateOne(addform.mEquipment))
{
XtraMessageBox.Show("更新设备失败");
}
else
{
InitList();
}
}
}
}
private void btn_AddAdd_Click(object sender, EventArgs e)
{
try
{
Equipment eee = GetAddEquip();
List <byte> adds = EquipmentDal.GetAddress();
if (adds.Contains(eee.Address))
{
XtraMessageBox.Show("ID重复，请重新输入");
return;
}
Equipment eee1 = EquipmentDal.AddOneR(eee);
mainList.Add(eee1);
RefreshenAdd();
}
catch (Exception ex)
{
LogLib.Log.GetLogger(this).Warn(ex);
}
}
private void Form_SensorParmSet_Load(object sender, EventArgs e)
{
enableControls();
hwnd = LibMessageHelper.MessageHelper.FindWindow(null, "气体检测软件 ");
if (hwnd == IntPtr.Zero)
{
LogLib.Log.GetLogger(this).Warn("获取主窗口失败");
}
list = EquipmentDal.GetAllList();
gridControl1.DataSource = list;
if (list == null || list.Count < 1)
{
sendByWindow("系统中不存在注册的气体");
this.Close();
return;
}
else
{
eqNow = list.First();
setCapution();
}
}
private void loadData()
{
lastSensor = ConfigurationManager.AppSettings["lastSensor"].ToString();
lastGas = ConfigurationManager.AppSettings["lastGas"].ToString();
mainList = EquipmentDal.GetListIn();
List <IGrouping <string, Equipment> > list1 = mainList.GroupBy(c => c.Name).ToList();
comboBoxEdit_SensorName.Properties.Items.Clear();
list1.ForEach(c => { comboBoxEdit_SensorName.Properties.Items.Add(c.Key); });
for (int i = 0; i < list1.Count; i++)
{
if (list1[i].Key == lastSensor)
{
comboBoxEdit_SensorName.SelectedIndex = i;
}
else
{
comboBoxEdit_SensorName.SelectedIndex = 0;
}
}
}
// 添加默认设备
private void addDefultList()
{
try
{
using (WaitDialogForm wdf = new WaitDialogForm("正在读取数据 ...", "请耐心等待", new Size(200, 50), ParentForm))
{
for (byte i = 1; i <= 29; i++)
{
Equipment ept = new Equipment();
ept.Name = "VOC监控系统";
ept.Address = i;
ept.SensorTypeB = "通道" + i;
ept.GasName = "VOC";
ept.biNnum = 1;
ept.UnitType = 0;
ept.A1 = 200;
ept.A2 = 500;
ept.Max = 30;
ept.Point = 2;
ept.IsRegister = true;
if (!EquipmentDal.AddOne(ept))
{
LogLib.Log.GetLogger(this).Warn("插入失败");
continue;
}
}
InitList();
}
}
catch (Exception ex)
{
LogLib.Log.GetLogger(this).Warn(ex);
XtraMessageBox.Show("添加失败");
return;
}
}
private void simpleButton5_Click(object sender, EventArgs e)
{
try
{
if (XtraMessageBox.Show("数据将要被清空(当前设备)，是否继续", "注意", MessageBoxButtons.YesNo) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
foreach (CheckedListBoxItem item in checkedComboBoxEdit1.Properties.Items)
{
if (item.CheckState != CheckState.Checked)
{
continue;
}
List <Equipment> eq = mainList.FindAll(c => c.ID == Convert.ToInt32(item.Value));
foreach (Equipment equipment in eq)
{
EquipmentDataDal.DeleteByEquipmentID(equipment.ID);
// dang qian jian ce she bei bu shan chu
if (equipment.IsDel)
{
EquipmentDal.DeleteOne(equipment);
}
}
}
gridControl2.DataSource = null;
chartControl2.Series.Clear();
loadData();
XtraMessageBox.Show("数据已清空");
}
catch (Exception ex)
{
LogLib.Log.GetLogger(this).Warn(ex);
}
}
