private void button1_Click(object sender, EventArgs e) { bool ifConnected = OracleHelper.CheckOracleConnect(ReadPropertyFile.getOraConnStr()); if (ifConnected) { MessageBox.Show("ok"); } else { MessageBox.Show("no"); } }
private void exeUpdate(string fieldNm, string fieldValue, string taskNm) { OracleParameter[] param = new OracleParameter[] { new OracleParameter(":" + fieldNm, OracleDbType.Varchar2), new OracleParameter(":TASKNM", OracleDbType.Varchar2), }; param[0].Value = fieldValue; param[1].Value = taskNm; upCnt = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.upOneField(fieldNm), param); if (upCnt > 0) { this.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll); } }
private void button1_save_Click(object sender, EventArgs e) { int i = 0; if (!saveCheck(textBox1_taskNm.Text, dateTimePicker1_preStartTime.Value, dateTimePicker1_preEndTime.Value, textBox1_taskOwner.Text)) { return; } OracleParameter[] param = new OracleParameter[] { new OracleParameter(":taskOwner", OracleDbType.Varchar2), new OracleParameter(":preStartTime", OracleDbType.Varchar2), new OracleParameter(":preEndTime", OracleDbType.Varchar2), new OracleParameter(":bikou", OracleDbType.Varchar2), new OracleParameter(":taskNm", OracleDbType.Varchar2), }; param[0].Value = textBox1_taskOwner.Text; param[1].Value = dateTimePicker1_preStartTime.Value.ToString("yyyy/MM/dd"); param[2].Value = dateTimePicker1_preEndTime.Value.ToString("yyyy/MM/dd"); param[3].Value = richTextBox1.Text; param[4].Value = textBox1_taskNm.Text; if (fpUpdateFlg == 1) { // 插入数据库表 i = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.InsertTask, param); } else { i = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.UpdateTask, param); } if (i == 1) { MessageBox.Show("保存成功"); Form1 f1; f1 = (Form1)this.Owner; f1.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll); this.Close(); } else { MessageBox.Show("保存失敗"); } }
private void exeUpdate(string zkEndTime, string zkEndTm_val, string zkKousu, string zkKousu_val, string taskNm) { OracleParameter[] param = new OracleParameter[] { new OracleParameter(":" + zkEndTime, OracleDbType.Varchar2), new OracleParameter(":" + zkKousu, OracleDbType.Varchar2), new OracleParameter(":TASKNM", OracleDbType.Varchar2), }; param[0].Value = zkEndTm_val; param[1].Value = zkKousu_val; param[2].Value = taskNm; List <string> taskList = new List <string>(); taskList.Add(zkEndTime); taskList.Add(zkKousu); upCnt = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.updateTask(taskList), param); if (upCnt > 0) { this.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll); } }
private void button_taskDel_Click(object sender, EventArgs e) { int selectedCnt = dataGridView1.SelectedRows.Count; if (selectedCnt == 0) { MessageBox.Show("削除したい行を選択してください"); return; } DialogResult dr = MessageBox.Show(selectedCnt.ToString() + "件タスクを削除してよろしいですか?", "メッセージ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.Cancel) { return; } else { OracleParameter[] param = new OracleParameter[] { new OracleParameter(":taskNm", OracleDbType.Varchar2), }; param[0].Value = dataGridView1.CurrentRow.Cells[0].Value.ToString(); int delCnt = OracleHelper.ExecuteNonQuery(ReadPropertyFile.getOraConnStr(), CommandType.Text, OracleSQL.DeleteTask, param); if (delCnt > 0) { MessageBox.Show(delCnt.ToString() + "件タスクが削除されました"); this.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll); } else { MessageBox.Show("タスクが削除が失敗しました"); } } }
private void Form1_Load(object sender, EventArgs e) { this.loadAll(ReadPropertyFile.getOraConnStr(), OracleSQL.getAll); }