public Int32 UpdatePersonBaseFeeDepartmentProjectInfo(PersonBaseFeeDepartmentProjectInfo PersonBaseFeeDepartmentProjectInfo) { String sql = ORMapping.GetUpdateSql(PersonBaseFeeDepartmentProjectInfo, BuilderEx.TSqlBuilderInstance); int result = _DataHelper.ExecuteSql(sql); return(result); }
public List <PersonBaseFeeDepartmentProjectInfo> GetPersonBaseFeeDepartmentProjectInfoList(String yearMonth, WhereSqlClauseBuilder builder) { String sql = String.Format("SELECT * FROM {0} WHERE {1} " , String.IsNullOrEmpty(yearMonth) ? PersonBaseFeeDepartmentProjectInfoDBConst.TableName : ORMapping.GetMappingInfo <PersonBaseFeeDepartmentProjectMonthInfo>().TableName , builder.ToSqlString()); DataTable dt = _DataHelper.GetDataTable(sql); List <PersonBaseFeeDepartmentProjectInfo> result = new List <PersonBaseFeeDepartmentProjectInfo>(); for (Int32 i = 0; i < dt.Rows.Count; i++) { PersonBaseFeeDepartmentProjectInfo info = String.IsNullOrEmpty(yearMonth) ? new PersonBaseFeeDepartmentProjectInfo() : new PersonBaseFeeDepartmentProjectMonthInfo(); ORMapping.DataRowToObject(dt.Rows[i], info); result.Add(info); } return(result); }