private List <CHrinfo> getList(string sqlCommand)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlDataAdapter adt = new SqlDataAdapter(sqlCommand, conn))
{
adt.Fill(dt);
}
}
List <CHrinfo> result = new List <CHrinfo>();
foreach (DataRow row in dt.Rows)
{
CHrinfo hrinfo = new CHrinfo()
{
Seq = int.Parse(row["seq"].ToString()),
Emp_no = row["emp_no"].ToString(),
Emp_nm = row["emp_nm"].ToString(),
Phone_no = row["phone_no"].ToString(),
Sex = row["sex"].ToString(),
Remarks = row["remarks"].ToString()
};
result.Add(hrinfo);
}
return(result);
}
public void UpHrinfoList(CHrinfo hrinfo)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = string.Format(
@"
UPDATE [tbl_hrinfo]
SET [Emp_no] = '{0}',
[Emp_nm] = '{1}',
[Phone_no] = '{2}',
[Sex] = '{3}',
[Remarks] = '{4}'
WHERE Seq = '{5}'
", hrinfo.Emp_no, hrinfo.Emp_nm, hrinfo.Phone_no, hrinfo.Sex, hrinfo.Remarks, hrinfo.Seq);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
int cnt = cmd.ExecuteNonQuery();
}
}
public void DelHrinfoList(CHrinfo hrinfo)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = string.Format(
@"
DELETE FROM [tbl_hrinfo] WHERE Seq ='{0}' ", hrinfo.Seq);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
int cnt = cmd.ExecuteNonQuery();
}
}
public void SetHrinfoList(CHrinfo hrinfo)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = string.Format(
@"
INSERT INTO tbl_hrinfo (emp_no, emp_nm, phone_no, sex, remarks)
VALUES('{0}', '{1}', '{2}', '{3}', '{4}')
", hrinfo.Emp_no, hrinfo.Emp_nm, hrinfo.Phone_no, hrinfo.Sex, hrinfo.Remarks);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
int cnt = cmd.ExecuteNonQuery();
}
}
public void UpHrinfoList(CHrinfo hrinfo)
{
IHrinfoDao hrinfoDao = new HrinfoDao();
hrinfoDao.UpHrinfoList(hrinfo);
}
public void DelHrinfoList(CHrinfo hrinfo)
{
IHrinfoDao hrinfoDao = new HrinfoDao();
hrinfoDao.DelHrinfoList(hrinfo);
}
public void SetHrinfoList(CHrinfo hrinfo)
{
IHrinfoDao hrinfoDao = new HrinfoDao();
hrinfoDao.SetHrinfoList(hrinfo);
}
