private void btnSave_Click(object sender, EventArgs e) { string question = txtQuestion.Text.Trim(); string answer = txtAnswer.Text.Trim(); if (string.IsNullOrEmpty(question) && string.IsNullOrEmpty(answer)) { MessageBox.Show("Please input Question & Answer."); return; } if (_id == "") { string query = string.Format("insert into TB_IT_QA (q_question, q_answer) values (N'{0}', N'{1}')", question, answer); DataServiceIT.GetInstance().ExecuteNonQuery(query); } else { string query = string.Format("update TB_IT_QA set q_question = N'{0}', q_answer = N'{1}' where q_id = '{2}'", question, answer, _id); DataServiceIT.GetInstance().ExecuteNonQuery(query); } MessageBox.Show("Record has been saved."); this.DialogResult = DialogResult.OK; }
private void SaveData() { if (txtItems.Text == "") { MessageBox.Show("Please input Item"); return; } string item = txtItems.Text.Trim(); if (_item != "") { if (utils.DataUtil.IsItemExist(_item)) { string query = string.Format("update TB_IT_ITEMS set i_item = N'{0}' where i_item = N'{1}'", item, _item); DataServiceIT.GetInstance().ExecuteNonQuery(query); } else { string query = string.Format("insert into TB_IT_ITEMS (i_item) values (N'{0}')", item); DataServiceIT.GetInstance().ExecuteNonQuery(query); } } else { string query = string.Format("insert into TB_IT_ITEMS (i_item) values (N'{0}')", item); DataServiceIT.GetInstance().ExecuteNonQuery(query); } LoadData(); }
private void SaveSoftware() { if (txtSoftware.Text == "") { MessageBox.Show("Please input software"); return; } string software = txtSoftware.Text.Trim(); if (_software != "") { if (utils.DataUtil.IsSoftwareExist(_software)) { string query = string.Format("update TB_IT_SOFTWARE set s_name = N'{0}' where s_name = N'{1}'", software, _software); DataServiceIT.GetInstance().ExecuteNonQuery(query); } else { string query = string.Format("insert into TB_IT_SOFTWARE (s_name) values (N'{0}')", software); DataServiceIT.GetInstance().ExecuteNonQuery(query); } } else { string query = string.Format("insert into TB_IT_SOFTWARE (s_name) values (N'{0}')", software); DataServiceIT.GetInstance().ExecuteNonQuery(query); } LoadHardware(); }
public static string GetExt(string user) { string query = string.Format("select t_ext from TB_C_EXT where t_staff = N'{0}'", user.Trim()); //return DataServiceIT.GetInstance().ExecuteScalar(query).ToString().Trim(); object objResult = DataServiceIT.GetInstance().ExecuteScalar(query); return(objResult == null ? string.Empty : objResult.ToString().Trim()); }
private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dgvQa.SelectedRows) { string id = row.Cells[2].Value.ToString(); string query = string.Format("delete from TB_IT_QA where q_id = '{0}'", id); DataServiceIT.GetInstance().ExecuteNonQuery(query); } LoadData(); }
public static bool IsSoftwareExist(string hardware) { string query = string.Format("select count(*) from TB_IT_SOFTWARE where s_name = N'{0}'", hardware); int result = (int)DataServiceIT.GetInstance().ExecuteScalar(query); if (result == 0) { return(false); } else { return(true); } }
private void LoadData() { dgvItems.Rows.Clear(); string query = "select i_id, i_item from TB_IT_ITEMS"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { dgvItems.Rows.Add(reader.GetInt32(0), reader.GetString(1).Trim()); } } }
public static bool IsItemExist(string item) { string query = string.Format("select count(*) from TB_IT_ITEMS where i_item = N'{0}'", item); int result = (int)DataServiceIT.GetInstance().ExecuteScalar(query); if (result == 0) { return(false); } else { return(true); } }
private void LoadSoftware() { dgvSoftware.Rows.Clear(); string query = "select s_id, s_name from TB_IT_SOFTWARE"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { dgvSoftware.Rows.Add(reader.GetInt32(0), reader.GetString(1).Trim()); } } }
private void dgvItems_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { foreach (DataGridViewRow row in dgvItems.SelectedRows) { string id = row.Cells[0].Value.ToString().Trim(); string query = string.Format("delete from TB_IT_ITEMS where i_id = '{0}'", id); DataServiceIT.GetInstance().ExecuteNonQuery(query); } LoadData(); } }
private void LoadAnswers() { string query = "select q_answer from TB_IT_QA order by q_answer"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { string item = reader.GetString(0).Trim(); if (!lbSuggestionAnswer.Items.Contains(item)) { lbSuggestionAnswer.Items.Add(item); } } } }
public static List <string> ItemList() { List <string> list = new List <string>(); string query = "select i_item from TB_IT_ITEMS"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { list.Add(reader.GetString(0).Trim()); } } return(list); }
private List <string> ItemColumn(string category) { List <string> list = new List <string>(); string query = string.Format("select a_name from TB_IT_ASSET where a_category = '{0}' and a_status = N'可借用'", category); using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { list.Add(reader.GetString(0).Trim()); } } return(list); }
private List <string> CategoryColumn() { List <string> list = new List <string>(); string query = "select distinct a_category from TB_IT_ASSET"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { list.Add(reader.GetString(0).Trim()); } } return(list); }
public static List <string> GetSoftwareList() { List <string> list = new List <string>(); string query = "select s_name from TB_IT_SOFTWARE"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { list.Add(reader.GetString(0).Trim()); } } return(list); }
public static List <QaList> GetQaList() { List <QaList> list = new List <QaList>(); string query = "select q_question, q_answer, q_id from TB_IT_QA"; using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { list.Add(new QaList { Question = reader.GetString(0), Answer = reader.GetString(1), Id = reader.GetInt32(2) }); } } return(list); }
private void btnAdd_Click(object sender, EventArgs e) { string question = txtQuestion.Text; string solution = txtSolution.Text; switch (MessageBox.Show("Store following information as permanent item?\n\nQuestion: " + question + "\nSolution: " + solution + "\n", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { case DialogResult.Yes: string query = string.Format("if not exists (select * from TB_IT_QA where q_question = N'{0}' and q_answer = N'{1}')" + " insert into TB_IT_QA (q_question, q_answer) values (N'{0}', N'{1}')", question, solution); DataServiceIT.GetInstance().ExecuteNonQuery(query); MessageBox.Show("Record has been added."); break; case DialogResult.No: break; } }
public FormQaSetup(string mode, string id) { InitializeComponent(); this.Text = mode == "" ? "QA Setup - New" : "QA Setup - Modify"; if (mode != "") { _id = id; string query = string.Format("select q_question, q_answer from TB_IT_QA where q_id = '{0}'", id); using (IDataReader reader = DataServiceIT.GetInstance().ExecuteReader(query)) { while (reader.Read()) { txtQuestion.Text = reader.GetString(0).Trim(); txtAnswer.Text = reader.GetString(1).Trim(); } } } }
private void dgvAsset_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 11) { string device = dgvAsset.CurrentRow.Cells[8].Value.ToString().Trim(); string query = string.Format("update TB_IT_ASSET set a_status = N'可借用' where a_name = '{0}'", device); DataServiceIT.GetInstance().ExecuteNonQuery(query); string chaseno = dgvAsset.CurrentRow.Cells[1].Value.ToString().Trim(); string query1 = string.Format("update TB_FORM_LOANING set l_status = N'申請處理完成' where l_chaseno = '{0}'", chaseno); DataService.GetInstance().ExecuteNonQuery(query1); LoadData(_mode); if (ReloadEvent != null) { ReloadEvent(this, new EventArgs()); } } }
public static string GetDeviceStatus(string device) { string query = string.Format("select a_status from TB_IT_ASSET where a_name = '{0}'", device); return(DataServiceIT.GetInstance().ExecuteScalar(query).ToString()); }