base/view/TimeAreaSetting.cs

   1 using System;\r
   2 using System.Collections.Generic;\r
   3 using System.Linq;\r
   4 using System.Windows.Forms;\r
   5 using com.andoutomo.kybernetes.data.DAO;\r
   6 using com.andoutomo.kybernetes.data;\r
   7 using com.andoutomo.kybernetes.data.connection;\r
   8 \r
   9 \r
  10 namespace com.andoutomo.kybernetes.view\r
  11 {\r
  12     public partial class TimeAreaSetting : Form\r
  13     {\r
  14         public TimeAreaSetting()\r
  15         {\r
  16             InitializeComponent();\r
  17         }\r
  18         private List<TimeAreaData> innerList;\r
  19         private string targetForChg;\r
  20 \r
  21         private void listBox1_SelectedIndexChanged(object sender, EventArgs e)\r
  22         {\r
  23             string target = this.TimeareaListBox.SelectedItem.ToString().Substring(0, 1);\r
  24             var rawdata = from data in innerList where data.AreaStr == target select data;\r
  25             foreach (TimeAreaData innerData in rawdata)\r
  26             {\r
  27                 this.txtArea.Text = innerData.AreaStr;\r
  28                 this.targetForChg = innerData.AreaStr;\r
  29                 this.txtFrom.Text = innerData.StartTime.ToString();\r
  30                 this.txtTo.Text = innerData.EndTime.ToString();\r
  31             }\r
  32         }\r
  33         public void setTimeareaList(List<TimeAreaData> dataList)\r
  34         {\r
  35             TimeareaListBox.Items.Clear();\r
  36             innerList = dataList;\r
  37 \r
  38             foreach (TimeAreaData data in innerList)\r
  39             {\r
  40                 TimeareaListBox.Items.Add(data.TextForDropDown);\r
  41             }\r
  42         }\r
  43 \r
  44         private void btnClose_Click(object sender, EventArgs e)\r
  45         {\r
  46             List<MultiSQLRunnningBean> sqlList = new List<MultiSQLRunnningBean>();\r
  47             sqlList.Add(new MultiSQLRunnningBean(SqlDictionary.clearTimeArea, new List<object>()));\r
  48             foreach (TimeAreaData innerData in innerList)\r
  49             {\r
  50                 List<object> argList = new List<object>();\r
  51                 argList.Add(innerData.AreaStr);\r
  52                 argList.Add(innerData.StartTime);\r
  53                 argList.Add(innerData.EndTime);\r
  54                 \r
  55                 sqlList.Add(new MultiSQLRunnningBean(SqlDictionary.insertTimeArea, argList));\r
  56             }\r
  57 \r
  58             TaskDBConnection.Connection.updateData(sqlList);\r
  59 \r
  60             this.Close();\r
  61         }\r
  62 \r
  63         private void btnAdd_Click(object sender, EventArgs e)\r
  64         {\r
  65             if (txtArea.Text == string.Empty) return;\r
  66             var rawdata = from data in innerList where data.AreaStr == this.txtArea.Text select data;\r
  67             foreach (TimeAreaData dummy in rawdata)\r
  68             {\r
  69                 //既にデータがある場合は何もせず終了\r
  70                 return;\r
  71             }\r
  72             TimeAreaData newData = new TimeAreaData();\r
  73             newData.AreaStr=txtArea.Text;\r
  74             newData.StartTime=new TimeComponent(txtFrom.Text);\r
  75             newData.EndTime= new TimeComponent(txtTo.Text);\r
  76 \r
  77             innerList.Add(newData);\r
  78             setTimeareaList(innerList);\r
  79         }\r
  80 \r
  81         private void btnAply_Click(object sender, EventArgs e)\r
  82         {\r
  83 \r
  84             var rawdata = from data in innerList where data.AreaStr == this.targetForChg select data;\r
  85 \r
  86             foreach (TimeAreaData updData in rawdata)\r
  87             {\r
  88                 if (string.IsNullOrEmpty(this.txtArea.Text))\r
  89                 {\r
  90                     innerList.Remove(updData);\r
  91                     break;\r
  92                 }\r
  93                 else\r
  94                 {\r
  95                     updData.AreaStr = this.txtArea.Text.ToUpper();\r
  96                     updData.StartTime = new TimeComponent(this.txtFrom.Text);\r
  97                     updData.EndTime = new TimeComponent(this.txtTo.Text);\r
  98                 }\r
  99             }\r
 100             setTimeareaList(innerList);\r
 101         }\r
 102     }\r
 103 }\r