public Int32 UpdatePersonInfo(PersonInfo personInfo) { String sql = ORMapping.GetUpdateSql(personInfo, BuilderEx.TSqlBuilderInstance); int result = _DataHelper.ExecuteSql(sql); return result; }
public List<PersonInfo> GetPersonInfoList(WhereSqlClauseBuilder builder) { String sql = String.Format("SELECT * FROM {0} WHERE {1} ORDER BY PERSON_CODE, ENTRY_DATE", PersonInfoDBConst.TableName, builder.ToSqlString()); DataTable dt = _DataHelper.GetDataTable(sql); List<PersonInfo> result = new List<PersonInfo>(); for (Int32 i = 0; i < dt.Rows.Count; i++) { PersonInfo info = new PersonInfo(); ORMapping.DataRowToObject(dt.Rows[i], info); result.Add(info); } return result; }
public bool IsPersonNameUsed(PersonInfo personInfo, Boolean isAdd) { WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); builder.AppendItem(PersonInfoDBConst.PersonName, personInfo.PersonName); builder.AppendItem(PersonInfoDBConst.ParentID, personInfo.ParentID); builder.AppendItem(PersonInfoDBConst.EntryDate, personInfo.EntryDate); PersonInfo info = GetPersonInfoList(builder).FirstOrDefault(); if (info == null) { return false; } else { if (isAdd) { return true; } else { return info.PersonID.Equals(personInfo.PersonID) ? false : true; } } }