/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmXGDataQuery_Load(object sender, System.EventArgs e)
{
// string[] colNames = {"xgdata_id", "station_address", "card_sn", "station_time", "computer_time", "isAuto", "tag"};
// string[] showNames = {"编号", "站点地址", "卡号", "站点时间", "时间", "自动上报", "备注"};
// 2007-10-30 Added "team", "班组", 50
//
string[] colNames = { "xgdata_id", "team", "stationName", "person", /*"sn",*/ "xgtime" };
string[] showNames = { "编号", "班组", "站名", "持卡人", /*"卡号",*/ "时间" };
int [] colWidths = new int[] { 50, 50, 100, 100, /*150,*/ 120 };
// int[] boolIndexs = {5};
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("table", colNames, showNames, null, colWidths);
this.dataGridXGData.TableStyles.Add(dgts);
string[] colNames2 = { "team", "name", "ci" };
string[] showNames2 = { "班组", "站名", "巡更次数" };
int [] colWidths2 = { 50, 100, 100 };
DataGridTableStyle dgts2 = Misc.CreateDataGridTableStyle(XG_COUNT_TABLE, colNames2, showNames2, null, colWidths2);
this.dataGridXGData.TableStyles.Add(dgts2);
this.FillStationName();
this.FillCardPerson();
// 2007-10-30 Added
//
this.FillTeam();
SetDefaultTimeRange();
this.QueryXgData();
// LoadXGDataFromDB();
}
private void AddTableStyles()
{
string [] colNames = new string[] { "card_id", "sn", "person", "team", "remark" };
string [] showNames = new string[] { "编号", "卡号", "持卡人", "所属班组", "备注" };
int [] columnWidth = new int[] { 50, 150, 100, 100, 200 };
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("Table", colNames, showNames, null, columnWidth);
this.dataGridCards.TableStyles.Add(dgts);
}
private void frmXGTaskManager_Load(object sender, System.EventArgs e)
{
dataGridXGTasK.ReadOnly = true;
string[] colNames = new string[] { "xgtask_id", "name", "person", "sn", "begin_time", "end_time" };
string[] showNames = new string[] { "编号", "站名", "持卡人", "卡号", "开始时间", "结束时间" };
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("Table", colNames, showNames, null);
this.dataGridXGTasK.TableStyles.Add(dgts);
LoadXGTaskFromDB();
}
private void frmctrllog_Load(object sender, System.EventArgs e)
{
//new Test.Test().InsertPumpOPLog();
string [] colName = new string[] { "ctrllog_id", "dt", "obj", "op", "person" };
string [] colText = new string[] { "编号", "时间", "目标", "操作", "操作人" };
//int [] boolColIndexs = {3,4,5,6,7,8,9,10,11,12,13,14,15,16};
int [] colWidths = new int[] { 50, 100, 100, 100, 100 };
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("table", colName, colText, null, colWidths);
this.dataGrid1.TableStyles.Add(dgts);
RefGD();
}
private void InitForm()
{
dataGridGPRSStation.ReadOnly = true;
// string[] colNames = new string[] {"grstation_id", "name", "team", "addDrug", "heatArea", "ip", "gr_address", "xg_address", "serverIp", "remark", };
string[] colNames = new string[] { "gprs_station_id", "name", "team", "addDrug", "heatArea", "ip", "gr_address", "xg_address", "serverIp", "remark", };
string[] showNames = new string[] { "编号", "站名", "所属班组", "加药方式", "供热面积", "IP地址", "供热控制器地址", "巡更控制器地址", "服务器IP地址", "备注" };
int [] columnWidth = new int[] { 50, 100, 60, 60, 60, 100, 120, 120, 100, 100 };
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("Table", colNames, showNames, null, columnWidth);
this.dataGridGPRSStation.TableStyles.Add(dgts);
LoadXGStationFromDB();
}
private void frmXGTaskResultManager_Load(object sender, System.EventArgs e)
{
string[] colNames = new string[] { "result_id", "dt", "station_name",
"person", "card_sn", "expection_time",
"occur_time", "complete" };
string[] showNames = new string[] { "编号", "时间", "站名",
"持卡人", "卡号", "期望时间",
"发生时间", "是否完成" };
int[] boolColIndexs = new int[] { 7 };
DataGridTableStyle style = Misc.CreateDataGridTableStyle("Table", colNames, showNames,
boolColIndexs);
this.dataGridXGTaskResult.TableStyles.Add(style);
LoadXGTaskResultFromDB();
}
private void setTableStyle()
{
string [] colName = new string[] { "id", "name", "time", "oneGiveTempLow", "twoGiveTempHigh", "oneGivePressLow",
"twoGivePressHigh", "twoBackPressHigh", "twoBackPressLow", "watLevelLow", "watLevelHigh",
"pumpAlarm1", "pumpAlarm2", "pumpAlarm3", "addPumpAlarm1", "addPumpAlarm2",
"NoPower" };
string [] colText = new string[] { "编号", "站名", "时间", "一次供温低", "二次供温高", "一次供压低",
"二次供压高", "二次回压高", "二次回压低", "水箱水位低", "水箱水位高",
"循环泵1故障", "循环泵2故障", "循环泵3故障", "补水泵1故障", "补水泵2故障",
"掉电" };
int [] boolColIndexs = { 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16 };
int [] colWidths = new int[] { 50, 100, 100, 75, 75, 75,
75, 75, 75, 75, 75,
75, 75, 75, 75, 75,
75 };
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("table", colName, colText, boolColIndexs, colWidths);
this.dataGridGrAlarmData.TableStyles.Add(dgts);
}
private void frmXGDataManager_Load(object sender, System.EventArgs e)
{
// string[] colNames = {"xgdata_id", "station_address", "card_sn", "station_time", "computer_time", "isAuto", "tag"};
// string[] showNames = {"编号", "站点地址", "卡号", "站点时间", "时间", "自动上报", "备注"};
string[] colNames = { "xgdata_id", "stationName", "person", /*"sn",*/ "xgtime" };
string[] showNames = { "编号", "站名", "所属班组", /*"卡号",*/ "时间" };
int [] colWidths = new int[] { 50, 100, 100, /*150,*/ 120 };
// int[] boolIndexs = {5};
DataGridTableStyle dgts = Misc.CreateDataGridTableStyle("table", colNames, showNames, null, colWidths);
this.dataGridXGData.TableStyles.Add(dgts);
this.FillStationName();
this.FillCardPerson();
SetDefaultTimeRange();
this.QueryXgData();
// LoadXGDataFromDB();
}