protected void LoadData(int pageIndex)
{
var search = new HcontractSearch();
//search.Szdw = txtSrchSzdw.Text;
//search.Htbh = txtSrchHtbh.Text;
search.Xmmc = txtSrchXmmc.Text;
//search.Fjdw = txtSrchFjdw.Text;
//search.Gcxz = txtSrchGcxz.Text;
//search.Htzt = txtSrchHtzt.Text;
//search.Sznd = txtSrchSznd.Text;
//search.Htgq = txtSrchHtgq.Text;
search.Cbf = txtSrchCbf.Text;//供应商，直接存的名称
//search.Cbfw = txtSrchCbfw.Text;
//search.Cbfs = txtSrchCbfs.Text;
//search.Zlbz = txtSrchZlbz.Text;
//search.Htjk = txtSrchHtjk.Text;
//search.Qfbz = txtSrchQfbz.Text;
//search.Zffs = txtSrchZffs.Text;
//search.Jftl = txtSrchJftl.Text;
//search.Gcbxq = txtSrchGcbxq.Text;
//search.Gcbxj = txtSrchGcbxj.Text;
//search.Gztk = txtSrchGztk.Text;
//search.Qtyd = txtSrchQtyd.Text;
//search.Cbdb = txtSrchCbdb.Text;
//search.Jglfw = txtSrchJglfw.Text;
//search.Dbsl = txtSrchDbsl.Text;
//search.Zbht = txtSrchZbht.Text;
//search.Bdsl = txtSrchBdsl.Text;
//search.Bcsm = txtSrchBcsm.Text;
//search.Cbs = txtSrchCbs.Text;
//search.Jszj = txtSrchJszj.Text;
//search.Lydb = txtSrchLydb.Text;
//search.Fbsinstanceid = txtSrchFbsinstanceid.Text;
//if (ucSrchStartQcsj.DateValue.HasValue)
//{
// search.StartQcsj = ucSrchStartQcsj.DateValue.Value;
//}
//if (ucSrchEndQcsj.DateValue.HasValue)
//{
// search.EndQcsj = ucSrchEndQcsj.DateValue.Value;
//}
//search.Qdsj = txtSrchQdsj.Text;
//search.Htfl = txtSrchHtfl.Text;
//if (ucSrchStartJcxyrq.DateValue.HasValue)
//{
// search.StartJcxyrq = ucSrchStartJcxyrq.DateValue.Value;
//}
//if (ucSrchEndJcxyrq.DateValue.HasValue)
//{
// search.EndJcxyrq = ucSrchEndJcxyrq.DateValue.Value;
//}
//if (ucSrchStartFbjcrq.DateValue.HasValue)
//{
// search.StartFbjcrq = ucSrchStartFbjcrq.DateValue.Value;
//}
//if (ucSrchEndFbjcrq.DateValue.HasValue)
//{
// search.EndFbjcrq = ucSrchEndFbjcrq.DateValue.Value;
//}
//search.Jcxybh = txtSrchJcxybh.Text;
//search.Beizhu = txtSrchBeizhu.Text;
//if (ucSrchStartHtwcrq.DateValue.HasValue)
//{
// search.StartHtwcrq = ucSrchStartHtwcrq.DateValue.Value;//现在的合同完成日期
//}
//if (ucSrchEndHtwcrq.DateValue.HasValue)
//{
// search.EndHtwcrq = ucSrchEndHtwcrq.DateValue.Value;//现在的合同完成日期
//}
//if (ucSrchStartJssjrq.DateValue.HasValue)
//{
// search.StartJssjrq = ucSrchStartJssjrq.DateValue.Value;
//}
//if (ucSrchEndJssjrq.DateValue.HasValue)
//{
// search.EndJssjrq = ucSrchEndJssjrq.DateValue.Value;
//}
//if (ucSrchStartDzwcrq.DateValue.HasValue)
//{
// search.StartDzwcrq = ucSrchStartDzwcrq.DateValue.Value;
//}
//if (ucSrchEndDzwcrq.DateValue.HasValue)
//{
// search.EndDzwcrq = ucSrchEndDzwcrq.DateValue.Value;
//}
//search.Dzj = txtSrchDzj.Text;
//if (ucSrchStartJswcrq.DateValue.HasValue)
//{
// search.StartJswcrq = ucSrchStartJswcrq.DateValue.Value;
//}
//if (ucSrchEndJswcrq.DateValue.HasValue)
//{
// search.EndJswcrq = ucSrchEndJswcrq.DateValue.Value;
//}
//search.Jsj = txtSrchJsj.Text;
//search.Dysjsr = txtSrchDysjsr.Text;
//search.Qtydtmp = txtSrchQtydtmp.Text;
//search.Issaved = txtSrchIssaved.Text;
int recordCount = 0;
var list = HcontractService.RetrieveHcontractsPaging(search, pageIndex, pcData.PageSize, out recordCount);
rptContactsList.DataSource = list;
rptContactsList.DataBind();
pcData.RecordCount = recordCount;
pcData.CurrentIndex = pageIndex;
}
public List<Hcontract> RetrieveHcontractsPaging(HcontractSearch info,int pageIndex, int pageSize,out int count)
{
try
{
StringBuilder sqlCommand = new StringBuilder(@" SELECT ""H_CONTRACT"".""INSTANCEID"",""H_CONTRACT"".""SZDW"",""H_CONTRACT"".""HTBH"",""H_CONTRACT"".""XMMC"",""H_CONTRACT"".""FJDW"",
""H_CONTRACT"".""GCXZ"",""H_CONTRACT"".""HTZT"",""H_CONTRACT"".""SZND"",""H_CONTRACT"".""HTGQ"",""H_CONTRACT"".""CBF"",
""H_CONTRACT"".""CBFW"",""H_CONTRACT"".""CBFS"",""H_CONTRACT"".""ZLBZ"",""H_CONTRACT"".""HTJK"",""H_CONTRACT"".""QFBZ"",
""H_CONTRACT"".""ZFFS"",""H_CONTRACT"".""JFTL"",""H_CONTRACT"".""GCBXQ"",""H_CONTRACT"".""GCBXJ"",""H_CONTRACT"".""GZTK"",
""H_CONTRACT"".""QTYD"",""H_CONTRACT"".""CBDB"",""H_CONTRACT"".""JGLFW"",""H_CONTRACT"".""DEPARTID"",""H_CONTRACT"".""FAINSTANCEID"",
""H_CONTRACT"".""FLOWID"",""H_CONTRACT"".""DBSL"",""H_CONTRACT"".""HTLB"",""H_CONTRACT"".""ZBHT"",""H_CONTRACT"".""FIRSTNO"",
""H_CONTRACT"".""SECONDNO"",""H_CONTRACT"".""BDSL"",""H_CONTRACT"".""BCSM"",""H_CONTRACT"".""CBS"",""H_CONTRACT"".""JSZJ"",
""H_CONTRACT"".""LYDB"",""H_CONTRACT"".""FBS_INSTANCEID"",""H_CONTRACT"".""FINISHED_MONEY"",""H_CONTRACT"".""QCSJ"",""H_CONTRACT"".""QDSJ"",
""H_CONTRACT"".""HTFL"",""H_CONTRACT"".""JCXYRQ"",""H_CONTRACT"".""FBJCRQ"",""H_CONTRACT"".""JCXYBH"",""H_CONTRACT"".""BEIZHU"",
""H_CONTRACT"".""HTWCRQ"",""H_CONTRACT"".""JSSJRQ"",""H_CONTRACT"".""DZWCRQ"",""H_CONTRACT"".""DZJ"",""H_CONTRACT"".""JSWCRQ"",
""H_CONTRACT"".""JSJ"",""H_CONTRACT"".""DYSJSR"",""H_CONTRACT"".""QTYDTMP"",""H_CONTRACT"".""ISSAVED"",""H_CONTRACT"".""ZHTID"",
""H_CONTRACT"".""ISIMPORT""
,""SUBCOMPANYNAME""
FROM ""H_CONTRACT"" INNER JOIN SUBCOMPANYINFO ON SUBCOMPANYINFO.SUBCOMPANYID=""H_CONTRACT"".DEPARTID
WHERE ""FLOWID"" = :Flowid");
this.Database.AddInParameter(":Flowid", Hcontract.AssetContract);
//if (!string.IsNullOrEmpty(info.Szdw))
//{
// this.Database.AddInParameter(":Szdw",DbType.AnsiString,"%"+info.Szdw+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""SZDW"" LIKE :Szdw");
//}
//if (!string.IsNullOrEmpty(info.Htbh))
//{
// this.Database.AddInParameter(":Htbh",DbType.AnsiString,"%"+info.Htbh+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTBH"" LIKE :Htbh");
//}
if (!string.IsNullOrEmpty(info.Xmmc))
{
this.Database.AddInParameter(":Xmmc",DbType.AnsiString,"%"+info.Xmmc+"%");
sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""XMMC"" LIKE :Xmmc");
}
//if (!string.IsNullOrEmpty(info.Fjdw))
//{
// this.Database.AddInParameter(":Fjdw",DbType.AnsiString,"%"+info.Fjdw+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""FJDW"" LIKE :Fjdw");
//}
//if (!string.IsNullOrEmpty(info.Gcxz))
//{
// this.Database.AddInParameter(":Gcxz",DbType.AnsiString,"%"+info.Gcxz+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""GCXZ"" LIKE :Gcxz");
//}
//if (!string.IsNullOrEmpty(info.Htzt))
//{
// this.Database.AddInParameter(":Htzt",DbType.AnsiString,"%"+info.Htzt+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTZT"" LIKE :Htzt");
//}
//if (!string.IsNullOrEmpty(info.Sznd))
//{
// this.Database.AddInParameter(":Sznd",DbType.AnsiString,"%"+info.Sznd+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""SZND"" LIKE :Sznd");
//}
//if (!string.IsNullOrEmpty(info.Htgq))
//{
// this.Database.AddInParameter(":Htgq",DbType.AnsiString,"%"+info.Htgq+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTGQ"" LIKE :Htgq");
//}
#region ��Ӧ�̣�ֱ�Ӵ������
if (!string.IsNullOrEmpty(info.Cbf))
{
this.Database.AddInParameter(":Cbf",DbType.AnsiString,"%"+info.Cbf+"%");
sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""CBF"" LIKE :Cbf");
}
#endregion
//if (!string.IsNullOrEmpty(info.Cbfw))
//{
// this.Database.AddInParameter(":Cbfw",DbType.AnsiString,"%"+info.Cbfw+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""CBFW"" LIKE :Cbfw");
//}
//if (!string.IsNullOrEmpty(info.Cbfs))
//{
// this.Database.AddInParameter(":Cbfs",DbType.AnsiString,"%"+info.Cbfs+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""CBFS"" LIKE :Cbfs");
//}
//if (!string.IsNullOrEmpty(info.Zlbz))
//{
// this.Database.AddInParameter(":Zlbz",DbType.AnsiString,"%"+info.Zlbz+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""ZLBZ"" LIKE :Zlbz");
//}
//if (!string.IsNullOrEmpty(info.Htjk))
//{
// this.Database.AddInParameter(":Htjk",DbType.AnsiString,"%"+info.Htjk+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTJK"" LIKE :Htjk");
//}
//if (!string.IsNullOrEmpty(info.Qfbz))
//{
// this.Database.AddInParameter(":Qfbz",DbType.AnsiString,"%"+info.Qfbz+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""QFBZ"" LIKE :Qfbz");
//}
//if (!string.IsNullOrEmpty(info.Zffs))
//{
// this.Database.AddInParameter(":Zffs",DbType.AnsiString,"%"+info.Zffs+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""ZFFS"" LIKE :Zffs");
//}
//if (!string.IsNullOrEmpty(info.Jftl))
//{
// this.Database.AddInParameter(":Jftl",DbType.AnsiString,"%"+info.Jftl+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JFTL"" LIKE :Jftl");
//}
//if (!string.IsNullOrEmpty(info.Gcbxq))
//{
// this.Database.AddInParameter(":Gcbxq",DbType.AnsiString,"%"+info.Gcbxq+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""GCBXQ"" LIKE :Gcbxq");
//}
//if (!string.IsNullOrEmpty(info.Gcbxj))
//{
// this.Database.AddInParameter(":Gcbxj",DbType.AnsiString,"%"+info.Gcbxj+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""GCBXJ"" LIKE :Gcbxj");
//}
//if (!string.IsNullOrEmpty(info.Gztk))
//{
// this.Database.AddInParameter(":Gztk",DbType.AnsiString,"%"+info.Gztk+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""GZTK"" LIKE :Gztk");
//}
//if (!string.IsNullOrEmpty(info.Qtyd))
//{
// this.Database.AddInParameter(":Qtyd",DbType.AnsiString,"%"+info.Qtyd+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""QTYD"" LIKE :Qtyd");
//}
//if (!string.IsNullOrEmpty(info.Cbdb))
//{
// this.Database.AddInParameter(":Cbdb",DbType.AnsiString,"%"+info.Cbdb+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""CBDB"" LIKE :Cbdb");
//}
//if (!string.IsNullOrEmpty(info.Jglfw))
//{
// this.Database.AddInParameter(":Jglfw",DbType.AnsiString,"%"+info.Jglfw+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JGLFW"" LIKE :Jglfw");
//}
//if (!string.IsNullOrEmpty(info.Dbsl))
//{
// this.Database.AddInParameter(":Dbsl",DbType.AnsiString,"%"+info.Dbsl+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""DBSL"" LIKE :Dbsl");
//}
//if (!string.IsNullOrEmpty(info.Zbht))
//{
// this.Database.AddInParameter(":Zbht",DbType.AnsiString,"%"+info.Zbht+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""ZBHT"" LIKE :Zbht");
//}
//if (!string.IsNullOrEmpty(info.Bdsl))
//{
// this.Database.AddInParameter(":Bdsl",DbType.AnsiString,"%"+info.Bdsl+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""BDSL"" LIKE :Bdsl");
//}
//if (!string.IsNullOrEmpty(info.Bcsm))
//{
// this.Database.AddInParameter(":Bcsm",DbType.AnsiString,"%"+info.Bcsm+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""BCSM"" LIKE :Bcsm");
//}
//if (!string.IsNullOrEmpty(info.Cbs))
//{
// this.Database.AddInParameter(":Cbs",DbType.AnsiString,"%"+info.Cbs+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""CBS"" LIKE :Cbs");
//}
//if (!string.IsNullOrEmpty(info.Jszj))
//{
// this.Database.AddInParameter(":Jszj",DbType.AnsiString,"%"+info.Jszj+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JSZJ"" LIKE :Jszj");
//}
//if (!string.IsNullOrEmpty(info.Lydb))
//{
// this.Database.AddInParameter(":Lydb",DbType.AnsiString,"%"+info.Lydb+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""LYDB"" LIKE :Lydb");
//}
//if (!string.IsNullOrEmpty(info.Fbsinstanceid))
//{
// this.Database.AddInParameter(":Fbsinstanceid",DbType.AnsiString,"%"+info.Fbsinstanceid+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""FBS_INSTANCEID"" LIKE :Fbsinstanceid");
//}
//if (info.StartQcsj.HasValue)
//{
// this.Database.AddInParameter(":StartQcsj",info.StartQcsj.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""QCSJ"" >= :StartQcsj");
//}
//if (info.EndQcsj.HasValue)
//{
// this.Database.AddInParameter(":EndQcsj",info.EndQcsj.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""QCSJ"" <= :EndQcsj");
//}
//if (!string.IsNullOrEmpty(info.Qdsj))
//{
// this.Database.AddInParameter(":Qdsj",DbType.AnsiString,"%"+info.Qdsj+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""QDSJ"" LIKE :Qdsj");
//}
//if (!string.IsNullOrEmpty(info.Htfl))
//{
// this.Database.AddInParameter(":Htfl",DbType.AnsiString,"%"+info.Htfl+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTFL"" LIKE :Htfl");
//}
//if (info.StartJcxyrq.HasValue)
//{
// this.Database.AddInParameter(":StartJcxyrq",info.StartJcxyrq.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JCXYRQ"" >= :StartJcxyrq");
//}
//if (info.EndJcxyrq.HasValue)
//{
// this.Database.AddInParameter(":EndJcxyrq",info.EndJcxyrq.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JCXYRQ"" <= :EndJcxyrq");
//}
//if (info.StartFbjcrq.HasValue)
//{
// this.Database.AddInParameter(":StartFbjcrq",info.StartFbjcrq.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""FBJCRQ"" >= :StartFbjcrq");
//}
//if (info.EndFbjcrq.HasValue)
//{
// this.Database.AddInParameter(":EndFbjcrq",info.EndFbjcrq.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""FBJCRQ"" <= :EndFbjcrq");
//}
//if (!string.IsNullOrEmpty(info.Jcxybh))
//{
// this.Database.AddInParameter(":Jcxybh",DbType.AnsiString,"%"+info.Jcxybh+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JCXYBH"" LIKE :Jcxybh");
//}
//if (!string.IsNullOrEmpty(info.Beizhu))
//{
// this.Database.AddInParameter(":Beizhu",DbType.AnsiString,"%"+info.Beizhu+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""BEIZHU"" LIKE :Beizhu");
//}
//#region ���ڵĺ�ͬ�������
//if (info.StartHtwcrq.HasValue)
//{
// this.Database.AddInParameter(":StartHtwcrq",info.StartHtwcrq.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTWCRQ"" >= :StartHtwcrq");
//}
//if (info.EndHtwcrq.HasValue)
//{
// this.Database.AddInParameter(":EndHtwcrq",info.EndHtwcrq.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""HTWCRQ"" <= :EndHtwcrq");
//}
//#endregion
//if (info.StartJssjrq.HasValue)
//{
// this.Database.AddInParameter(":StartJssjrq",info.StartJssjrq.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JSSJRQ"" >= :StartJssjrq");
//}
//if (info.EndJssjrq.HasValue)
//{
// this.Database.AddInParameter(":EndJssjrq",info.EndJssjrq.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JSSJRQ"" <= :EndJssjrq");
//}
//if (info.StartDzwcrq.HasValue)
//{
// this.Database.AddInParameter(":StartDzwcrq",info.StartDzwcrq.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""DZWCRQ"" >= :StartDzwcrq");
//}
//if (info.EndDzwcrq.HasValue)
//{
// this.Database.AddInParameter(":EndDzwcrq",info.EndDzwcrq.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""DZWCRQ"" <= :EndDzwcrq");
//}
//if (!string.IsNullOrEmpty(info.Dzj))
//{
// this.Database.AddInParameter(":Dzj",DbType.AnsiString,"%"+info.Dzj+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""DZJ"" LIKE :Dzj");
//}
//if (info.StartJswcrq.HasValue)
//{
// this.Database.AddInParameter(":StartJswcrq",info.StartJswcrq.Value.Date);
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JSWCRQ"" >= :StartJswcrq");
//}
//if (info.EndJswcrq.HasValue)
//{
// this.Database.AddInParameter(":EndJswcrq",info.EndJswcrq.Value.Date.AddDays(1).AddSeconds(-1));
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JSWCRQ"" <= :EndJswcrq");
//}
//if (!string.IsNullOrEmpty(info.Jsj))
//{
// this.Database.AddInParameter(":Jsj",DbType.AnsiString,"%"+info.Jsj+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""JSJ"" LIKE :Jsj");
//}
//if (!string.IsNullOrEmpty(info.Dysjsr))
//{
// this.Database.AddInParameter(":Dysjsr",DbType.AnsiString,"%"+info.Dysjsr+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""DYSJSR"" LIKE :Dysjsr");
//}
//if (!string.IsNullOrEmpty(info.Qtydtmp))
//{
// this.Database.AddInParameter(":Qtydtmp",DbType.AnsiString,"%"+info.Qtydtmp+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""QTYDTMP"" LIKE :Qtydtmp");
//}
//if (!string.IsNullOrEmpty(info.Issaved))
//{
// this.Database.AddInParameter(":Issaved",DbType.AnsiString,"%"+info.Issaved+"%");
// sqlCommand.AppendLine(@" AND ""H_CONTRACT"".""ISSAVED"" LIKE :Issaved");
//}
sqlCommand.AppendLine(@" ORDER BY ""H_CONTRACT"".""INSTANCEID"" DESC");
return this.ExecuteReaderPaging<Hcontract>(sqlCommand.ToString(), pageIndex, pageSize, out count);
}
finally
{
this.Database.ClearParameter();
}
}
public List<Hcontract> RetrieveHcontractsPaging(HcontractSearch info,int pageIndex, int pageSize,out int count)
{
return Management.RetrieveHcontractsPaging(info,pageIndex,pageSize,out count);
}