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;
}
}
}
