private void refresh_MonitorData(NavBarGroup group)
{
string sql = "select * from monitor where projectid = ?";
MySqlParameter mp = new MySqlParameter(@"projectid", MySqlDbType.Int32)
{
Value = group.Tag
};
try
{
DataTable dt = common.MySqlHelper.GetDataSet(sql, mp).Tables[0];
gridControl1.DataSource = null;
gridControl1.DataSource = dt;
comboBoxEdit1.Properties.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
string id = dt.Rows[i].ItemArray[0].ToString();
string name = dt.Rows[i].ItemArray[1].ToString();
ComboxData comboxData = new ComboxData()
{
Text = name, Value = id
};
comboBoxEdit1.Properties.Items.Add(comboxData);
}
if (comboBoxEdit1.Properties.Items.Count > 0)
{
comboBoxEdit1.SelectedItem = comboBoxEdit1.Properties.Items[0];
}
}
catch (Exception ex)
{
_logger.Trace(ex.Message + "----refresh_MonitorData方法");
}
}
private void refresh_SensorData()
{
if (comboBoxEdit1.SelectedItem == null)
{
return;
}
ComboxData comboxData = comboBoxEdit1.SelectedItem as ComboxData;
int monitorid = Convert.ToInt32(comboxData.Value);
string sql = "select s.id,s.name,st.name as sensortypename,st.code,st.unit,s.monitorid,s.sensortypeid from sensor s LEFT JOIN sensor_type st on s.sensortypeid = st.id WHERE monitorid = ?";
MySqlParameter mp = new MySqlParameter(@"monitorid", MySqlDbType.Int32)
{
Value = monitorid
};
try
{
DataSet ds = common.MySqlHelper.GetDataSet(sql, mp);
gridControl2.DataSource = null;
gridControl2.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
_logger.Trace(ex.Message + "----refresh_SensorData方法");
}
}
/// <summary>
/// 获取下拉列表
/// </summary>
/// <returns></returns>
protected new ComboxData GetCombox(string field)
{
ComboxData cdata = new ComboxData();
switch (field)
{
case "StockInType":
cdata.items.Add(new ComboxDataItem()
{
value = StockInEnum.OtherIn,
text = "其他入库"
});
cdata.items.Add(new ComboxDataItem()
{
value = StockInEnum.InvProfit,
text = "盘盈入库"
});
break;
case "StockStatus":
cdata.items.Add(new ComboxDataItem()
{
value = StockStatusEnum.New,
text = "新建"
});
cdata.items.Add(new ComboxDataItem()
{
value = StockStatusEnum.Approve,
text = "审核"
});
break;
}
return(cdata);
}
/// <summary>
/// 获取下拉列表
/// </summary>
/// <returns></returns>
private new ComboxData GetCombox(string field)
{
ComboxData cdata = new ComboxData();
switch (field)
{
case "StockOutType":
cdata.items.Add(new ComboxDataItem()
{
value = StockOutEnum.OtherOut,
text = "其他出库"
});
cdata.items.Add(new ComboxDataItem()
{
value = StockOutEnum.InvShortages,
text = "盘盈出库"
});
break;
case "StockStatus":
cdata.items.Add(new ComboxDataItem()
{
value = StockStatusEnum.New,
text = "新建"
});
cdata.items.Add(new ComboxDataItem()
{
value = StockStatusEnum.Approve,
text = "审核"
});
break;
}
return(cdata);
}
/// <summary>
/// 获取下拉列表
/// </summary>
/// <param name="field"></param>
/// <returns></returns>
protected ComboxData GetCombox(string field)
{
ComboxData cd = new ComboxData();
List <SCommonEnum> comms = ceService.GetCommonEnumByType(field);
foreach (SCommonEnum item in comms)
{
cd.items.Add(new ComboxDataItem()
{
text = item.EnumDesc,
value = Convert.ToInt32(item.EnumField)
});
}
return(cd);
}
/// <summary>
/// 获取下拉列表
/// </summary>
/// <returns></returns>
private ComboxData GetCombox()
{
ComboxData cdata = new ComboxData();
cdata.items.Add(new ComboxDataItem()
{
value = 0,
text = "否"
});
cdata.items.Add(new ComboxDataItem()
{
value = 1,
text = "是"
});
return(cdata);
}
private void sensorAddLink_Click(object sender, EventArgs e)
{
SensorAddForm sAdd = new SensorAddForm();
ComboxData comboxData = comboBoxEdit1.SelectedItem as ComboxData;
if (comboxData == null)
{
XtraMessageBox.Show("请选择监测线！");
return;
}
sAdd.Monitorid = Convert.ToInt32(comboxData.Value);
sAdd.MonitorName = comboxData.Text;
if (sAdd.ShowDialog() == DialogResult.OK)
{
sAdd.MdiParent = this;
sAdd.ShowDialog();
}
refresh_SensorData();
}
private void sensorEditLink_Click(object sender, EventArgs e)
{
SensorEditForm sEdit = new SensorEditForm();
ComboxData comboxData = comboBoxEdit1.SelectedItem as ComboxData;
if (comboxData == null)
{
XtraMessageBox.Show("请选择监测线！");
return;
}
sEdit.Monitorid = Convert.ToInt32(comboxData.Value);
sEdit.MonitorName = comboxData.Text;
ArrayList rows = new ArrayList();
Int32[] selectedRowHandles = gridView2.GetSelectedRows();
for (int i = 0; i < selectedRowHandles.Length; i++)
{
int selectedRowHandle = selectedRowHandles[i];
if (selectedRowHandle >= 0)
{
rows.Add(gridView2.GetDataRow(selectedRowHandle));
}
}
if (rows.Count > 0)
{
DataRow row = rows[0] as DataRow;
sEdit.SensorName = row["name"].ToString();
sEdit.Sensorid = Convert.ToInt32(row["id"]);
}
if (sEdit.ShowDialog() == DialogResult.OK)
{
sEdit.MdiParent = this;
sEdit.Show();
}
refresh_SensorData();
}
// GET: WTransferOut
public ActionResult Index()
{
ComboxData cData = GetCombox("StockStatus");
return(View(cData));
}
// GET: WInventory
public ActionResult Index()
{
ComboxData cData = GetCombox("InventoryStatus");
return(View(cData));
}
