public Int32 UpdateProjectClassInfo(ProjectClassInfo projectClassInfo)
{
String sql = ORMapping.GetUpdateSql(projectClassInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return(result);
}
public List <ProjectClassInfo> GetProjectClassInfoList(WhereSqlClauseBuilder builder)
{
String sql = String.Format("SELECT * FROM {0} WHERE {1} ORDER BY PROJECT_CLASS_ID", ProjectClassInfoDBConst.TableName, builder.ToSqlString());
DataTable dt = _DataHelper.GetDataTable(sql);
List <ProjectClassInfo> result = new List <ProjectClassInfo>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
ProjectClassInfo info = new ProjectClassInfo();
ORMapping.DataRowToObject(dt.Rows[i], info);
result.Add(info);
}
return(result);
}
private ProjectClassInfo GetInfoFromPageControl()
{
ProjectClassInfo info = null;
switch (action)
{
case ActionType.Add:
info = new ProjectClassInfo();
info.ProjectClassID = this.tbProjectClassCode.Text;
break;
case ActionType.Edit:
info = ProjectClassInfoAdapter.Instance.LoadProjectClassInfo(projectClassId);
//info.ProjectClassId = this.tbProjectClassCode.Text;//CZ
break;
}
info.ProjectClassName = this.tbProjectClassName.Text.Trim();
if (this.ddlProjectClass.SelectedIndex > 0)
{
info.ParentClassID = this.ddlProjectClass.SelectedValue;
String nm = this.ddlProjectClass.SelectedItem.Text.Replace(" ", "").Trim();
info.ParentClassName = nm.StartsWith("-") ? nm.Substring(1).Trim() : nm;
}
return info;
}
public Boolean IsProjectClassIDUsed(ProjectClassInfo projectClassInfo, Boolean isAdd)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(ProjectClassInfoDBConst.ProjectClassID, projectClassInfo.ProjectClassID);
ProjectClassInfo info = GetProjectClassInfoList(builder).FirstOrDefault();
if (info == null)
{
return(false);
}
else
{
if (isAdd)
{
return(true);
}
else
{
return(false);
}
}
}
public Int32 InsertProjectClassInfo(ProjectClassInfo projectClassInfo)
{
String sql = ORMapping.GetInsertSql(projectClassInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return result;
}
public List<ProjectClassInfo> GetProjectClassInfoList(WhereSqlClauseBuilder builder)
{
String sql = String.Format("SELECT * FROM {0} WHERE {1} ORDER BY PROJECT_CLASS_ID", ProjectClassInfoDBConst.TableName, builder.ToSqlString());
DataTable dt = _DataHelper.GetDataTable(sql);
List<ProjectClassInfo> result = new List<ProjectClassInfo>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
ProjectClassInfo info = new ProjectClassInfo();
ORMapping.DataRowToObject(dt.Rows[i], info);
result.Add(info);
}
return result;
}
public Boolean IsProjectClassNameUsed(ProjectClassInfo projectClassInfo, Boolean isAdd)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(ProjectClassInfoDBConst.ProjectClassName, projectClassInfo.ProjectClassName);
ProjectClassInfo info = GetProjectClassInfoList(builder).FirstOrDefault();
if (info == null)
{
return false;
}
else
{
if (isAdd)
{
return true;
}
else
{
return info.ProjectClassID.Equals(projectClassInfo.ProjectClassID) ? false : true;
}
}
}