public int AddNew(DonViInfo donViInfo)
{
string strSql = "INSERT INTO Units VALUES(@UnitID, @Name, @Note)";
int nRow = 0;
try
{
nRow = dB.ExecuteNonQuery(CommandType.Text, strSql,
new SqlParameter {
ParameterName = "@UnitID", Value = donViInfo.UnitID
},
new SqlParameter {
ParameterName = "@Name", Value = donViInfo.Name
},
new SqlParameter {
ParameterName = "@Note", Value = donViInfo.Note
}
);
}
catch (SqlException ex)
{
throw ex;
}
return(nRow);
}
public int Update(DonViInfo donViInfo)
{
string strSQL = "UpdateUnits";
int nRow = 0;
try
{
nRow = dB.ExecuteNonQuery(CommandType.StoredProcedure, strSQL,
new SqlParameter {
ParameterName = "@UnitID", Value = donViInfo.UnitID
},
new SqlParameter {
ParameterName = "@Name", Value = donViInfo.Name
},
new SqlParameter {
ParameterName = "@Note", Value = donViInfo.Note
}
);
}
catch (SqlException ex)
{
throw ex;
}
return(nRow);
}
public DonViInfo LoadInfo(int id)
{
string sqlStr = string.Format("SELECT * FROM Units WHERE UnitID = {0}", id);
DataTable dt = dB.getData(sqlStr);
DonViInfo donViInfo = new DonViInfo();
donViInfo.UnitID = int.Parse(dt.Rows[0]["UnitID"].ToString());
donViInfo.Name = dt.Rows[0]["Name"].ToString();
donViInfo.Note = dt.Rows[0]["Note"].ToString();
return(donViInfo);
}
public static IList <DonViInfo> LayDsDonVi(String phong)
{
DonViData m_DVData = new DonViData();
DataTable m_DV = m_DVData.LayDSTheoLoaiDonVi(phong);
IList <DonViInfo> dS = new List <DonViInfo>();
foreach (DataRow Row in m_DV.Rows)
{
DonViInfo dv = new DonViInfo();
dv.MaDonVi = Convert.ToString(Row["MaDonVi"]);
dv.TenDonVi = Convert.ToString(Row["TenDonVi"]);
dS.Add(dv);
}
return(dS);
}
public static IList <NhanVienInfo> LayDsLuongNhanVien(String dt)
{
NhanVienData m_NVData = new NhanVienData();
//DataTable m_DT = m_NVData.LayDsNhanVienForReport();
DataTable m_DT = m_NVData.LayDSNV(dt);
IList <NhanVienInfo> dS = new List <NhanVienInfo>();
foreach (DataRow Row in m_DT.Rows)
{
NhanVienInfo nv = new NhanVienInfo();
ChucVuInfo cv = new ChucVuInfo();
cv.MaChucVu = Convert.ToString(Row["MaChucVu"]);
cv.TenChucVu = Convert.ToString(Row["TenChucVu"]);
DonViInfo dv = new DonViInfo();
dv.MaDonVi = Convert.ToString(Row["MaDonVi"]);
dv.TenDonVi = Convert.ToString(Row["TenDonVi"]);
GioiTinhInfo gt = new GioiTinhInfo();
gt.MaGioiTinh = Convert.ToString(Row["MaGioiTinh"]);
gt.TenGioiTinh = Convert.ToString(Row["TenGioiTinh"]);
nv.MaNhanVien = Convert.ToString(Row["MaNhanVien"]);
nv.HoTen = Convert.ToString(Row["HoTenNhanVien"]);
nv.GT = gt;
nv.ChucVu = cv;
nv.DonVi = dv;
nv.QueQuan = Convert.ToString(Row["QueQuan"]);
dS.Add(nv);
}
return(dS);
}
public int Update(DonViInfo donViInfo)
{
return(donViDAO.Update(donViInfo));
}
public int AddNew(DonViInfo donViInfo)
{
return(donViDAO.AddNew(donViInfo));
}
