public List <ThamSoModels> SelectRows(ThamSoModels clParam) { logger.Start("SelectRows"); List <ThamSoModels> lstResult = new List <ThamSoModels>(); try { Hashtable param = new Hashtable(); param = base.SetDataToHashtable(false, clParam); IList ilist = sqlMap.ExecuteQueryForList("m_thamso.SelectRows", param); CastDataType cast = new CastDataType(); lstResult = cast.AdvanceCastDataToList <ThamSoModels>(ilist); } catch (Exception ex) { logger.Error("Loi ---> " + ex.Message); } logger.End("SelectRows"); return(lstResult); }
public int CountRows(ThamSoModels clparam) { logger.Start("CountRows"); int iResult = 0; try { Hashtable param = new Hashtable(); param = base.SetDataToHashtable(false, clparam); iResult = (int)sqlMap.ExecuteQueryForObject("m_thamso.CountRows", param); } catch (Exception ex) { sqlMap.RollbackTransaction(); iResult = 0; logger.Error(ex.Message); } logger.End("CountRows"); return(iResult); }
public ThamSoModels RowDetail(ThamSoModels clparam) { logger.Start("RowDetail"); ThamSoModels vbResult = new ThamSoModels(); try { Hashtable param = new Hashtable(); param = base.SetDataToHashtable(false, clparam); IList ilist = sqlMap.ExecuteQueryForList("m_thamso.SelectRows", param); CastDataType cast = new CastDataType(); vbResult = cast.AdvanceCastDataToList <ThamSoModels>(ilist)[0]; } catch (Exception ex) { logger.Error(ex.Message); vbResult = new ThamSoModels(); } logger.End("RowDetail"); return(vbResult); }
public string Test(ThamSoModels param) { //SequenceValuecs seqValue = base.GetSequenceValue(strTableName, param.nguoitao.ToString()); //int iID = -1; //int.TryParse(seqValue.giatri, out iID); //if (iID == -1) // return string.Empty; ////tao ma makehoach //param.tenthamso = string.Format(Functiontring.ReturnStringFormatID("makehoach"), // "RICONS", // "PB", // iID.ToString(seqValue.dodai)); //base.UpdateData(param, strTableName); ////cap nhat laij sequence cho user; //base.UpdateSequenceValue(strTableName, param.nguoitao.ToString(), seqValue.giatri); ArrayList arrWhere = new ArrayList(); arrWhere.Add("mathamso"); base.UpdateData(param, strTableName, arrWhere); return("complet"); }
public bool UpdateRow(ThamSoModels clParam) { logger.Start("UpdateRow"); bool bResult = false; try { sqlMap.BeginTransaction(); Hashtable param = new Hashtable(); param = base.SetDataToHashtable(false, clParam); sqlMap.Update("m_thamso.UpdateRow", param); sqlMap.CommitTransaction(); bResult = true; } catch (Exception ex) { sqlMap.RollbackTransaction(); bResult = false; logger.Error(ex.Message); } logger.End("UpdateRow"); return(bResult); }