/// <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(); }