//public IList<SuDivision> FindByOrganization(SuOrganization org)
//{
// return GetCurrentSession().CreateQuery("from SuDivision div where div.Organization.OrganizationID = :OrganizationID")
// .SetInt16("OrganizationID", org.Organizationid)
// .List<SuDivision>();
//}
public ISQLQuery FindByOrganizationCriteria(SuOrganization org, bool isCount)
{
StringBuilder sqlBuilder = new StringBuilder();
if (!isCount)
{
sqlBuilder.Append("select div.DivisionId as Divisionid, div.Comment as Comment from SuDivision div where div.OrganizationID = :OrganizationId");
}
else
{
sqlBuilder.Append("select count(div.DivisionId) as DivisionCount from SuDivision div where div.OrganizationID = :OrganizationId");
}
QueryParameterBuilder parameterBuilder = new QueryParameterBuilder();
parameterBuilder.AddParameterData("OrganizationId", typeof(short), org.Organizationid);
ISQLQuery query = GetCurrentSession().CreateSQLQuery(sqlBuilder.ToString());
parameterBuilder.FillParameters(query);
if (!isCount)
{
query.AddScalar("Divisionid", NHibernateUtil.Int16)
.AddScalar("Comment", NHibernateUtil.String);
query.SetResultTransformer(Transformers.AliasToBean(typeof(SS.SU.DTO.SuDivision)));
}
else
{
query.AddScalar("DivisionCount", NHibernateUtil.Int32);
}
return(query);
}
private void GetSuDivisionInfo(SuDivision div)
{
DropDownList org = ctlDivisionForm.FindControl("ctlOrganizeList") as DropDownList;
TextBox comment = ctlDivisionForm.FindControl("ctlComment") as TextBox;
CheckBox active = ctlDivisionForm.FindControl("ctlActive") as CheckBox;
div.Comment = comment.Text;
div.Active = active.Checked;
if (ctlDivisionForm.CurrentMode.Equals(FormViewMode.Insert))
{
SuOrganization organize = new SuOrganization(UIHelper.ParseShort(ctlOrganizationList.SelectedValue));
div.Organization = organize;
}
else
{
if (UIHelper.ParseShort(org.SelectedValue) != -1)
{
SuOrganization organize = new SuOrganization(UIHelper.ParseShort(org.SelectedValue));
div.Organization = organize;
}
}
div.CreBy = UserAccount.UserID;
div.CreDate = DateTime.Now.Date;
div.UpdBy = UserAccount.UserID;
div.UpdDate = DateTime.Now.Date;
div.UpdPgm = ProgramCode;
}
public SuOrganization GetOrganization()
{
SuOrganization org = new SuOrganization();
if (ctlOrganizationList.SelectedIndex > 0)
{
org.Organizationid = UIHelper.ParseShort(ctlOrganizationList.SelectedValue);
}
return(org);
}
public int CountByOrganizationCriteria(SuOrganization criteria)
{
return(NHibernateDaoHelper.CountByCriteria(DaoProvider.SuDivisionDao, "FindByOrganizationCriteria", new object[] { criteria, true }));
}
public IList <SuDivision> FindDivisionByOrganization(SuOrganization criteria, int firstResult, int maxResults, string sortExpression)
{
return(NHibernateDaoHelper.FindPagingByCriteria <SuDivision>(DaoProvider.SuDivisionDao, "FindByOrganizationCriteria", new object[] { criteria, false }, firstResult, maxResults, sortExpression));
}
