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