/// <summary>
/// Dem so luong cong viec
/// </summary>
/// <param name="clparam">CongViecModels</param>
/// <returns></returns>
public int CountRows(CongViecModels clparam)
{
logger.Start("CountRows");
int iResult = 0;
try
{
//chuyen doi models cong viec sang param
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
iResult = (int)sqlMap.ExecuteQueryForObject("cv_congviec.CountRows", param);
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
iResult = 0;
logger.Error(ex.Message);
}
logger.End("CountRows");
return(iResult);
}
/// <summary>
/// Lay danh sach cong viec
/// </summary>
/// <param name="clParam">CongViecModels</param>
/// <returns></returns>
public List <CongViecModels> SelectRows(CongViecModels clParam)
{
logger.Start("SelectRows");
List <CongViecModels> lstResult = new List <CongViecModels>();
try
{
//chuyen doi models cong viec sang param
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("cv_congviec.SelectRows", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <CongViecModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRows");
return(lstResult);
}
/// <summary>
/// Them cong viec
/// </summary>
/// <param name="clParam">CongViecModels</param>
/// <returns></returns>
public string InsertRow(CongViecModels clParam)
{
logger.Start("InsertRow");
string strResult = "";
try
{
sqlMap.BeginTransaction();
//chuyen doi models cong viec sang param
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
//lay gia tri seqnam m_congviec
param["seqname"] = "seq_m_congviec";
string strid = sqlMap.ExecuteQueryForObject("Common.GetNextVal", param).ToString();
int iID = -1;
int.TryParse(strid, out iID);
if (iID == -1)
{
return(string.Empty);
}
//tao ma cong viec
param["macongviec"] = string.Format(Functiontring.ReturnStringFormatID("macongviec"),
clParam.tenviettat,
DateTime.Now.Year,
DateTime.Now.Month,
iID.ToString("0000000000"));
sqlMap.Insert("cv_congviec.InsertRow", param);
sqlMap.CommitTransaction();
//return macong
strResult = param["macongviec"].ToString();
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
strResult = string.Empty;
logger.Error(ex.Message);
}
logger.End("InsertRow");
return(strResult);
}
/// <summary>
/// Lay chi tiet cong viec
/// </summary>
/// <param name="clparam"></param>
/// <returns></returns>
public CongViecModels RowDetail(CongViecModels clparam)
{
logger.Start("RowDetail");
CongViecModels vbResult = new CongViecModels();
try
{
//chuyen doi models cong viec sang param
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
IList ilist = sqlMap.ExecuteQueryForList("cv_congviec.RowDetail", param);
CastDataType cast = new CastDataType();
vbResult = cast.AdvanceCastDataToList <CongViecModels>(ilist)[0];
}
catch (Exception ex)
{
logger.Error(ex.Message);
vbResult = new CongViecModels();
}
logger.End("RowDetail");
return(vbResult);
}
/// <summary>
/// Cap nhat cong viec
/// </summary>
/// <param name="clParam">CongViecModels</param>
/// <returns></returns>
public bool UpdateRow(CongViecModels clParam)
{
logger.Start("UpdateRow");
bool bResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("cv_congviec.UpdateRow", param);
sqlMap.CommitTransaction();
bResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
bResult = false;
logger.Error(ex.Message);
}
logger.End("UpdateRow");
return(bResult);
}
