public DataTable[] InternalSearchByPage(string dsid, string tbnm, string[] fields, List <LibSearchCondition> conds, int pageindex, int pagesize)
{
object[] values = { };
StringBuilder whereformat = new StringBuilder();
AnalyzeSearchCondition(conds, whereformat, ref values);
SDPCRL.DAL.COM.SQLBuilder sQLBuilder = null;
if (string.IsNullOrEmpty(dsid))
{
sQLBuilder = new SDPCRL.DAL.COM.SQLBuilder();
}
else
{
sQLBuilder = new SDPCRL.DAL.COM.SQLBuilder(dsid);
}
//LibDSContext dSContext = new LibDSContext(dsid);
//string sql = dSContext.GetSQLByPage(tbnm, fields, new WhereObject { WhereFormat = whereformat.ToString(), Values = values }, pageindex, pagesize, true, false);
string sql = sQLBuilder.GetSQLByPage(tbnm, fields, new WhereObject {
WhereFormat = whereformat.ToString(), Values = values
}, pageindex, pagesize, true, false);
DataTable[] outtables = { };
DataSet dataSet = this.DataAccess.GetDataTables(sql);
foreach (DataTable dt in dataSet.Tables)
{
Array.Resize(ref outtables, outtables.Length + 1);
outtables[outtables.Length - 1] = dt;
}
//this.DataAccess.GetDatatTables(sql);
//return this.DataAccess.GetDataTable(sql);
return(outtables);
}
private void GetAssemblyInfo()
{
SDPCRL.DAL.COM.SQLBuilder sqlbuilder = new SDPCRL.DAL.COM.SQLBuilder();
string sql = sqlbuilder.GetSQL("FuncAssemblyInfo", new string[] { "AssemblyName", "TypeFullName" }, string.Format("FuncID='{0}'", _funcId));
DataRow dr = _dataAccess.GetDataRow(sql);
if (dr == null)
{
sql = sqlbuilder.GetSQL("FuncAssemblyInfo", new string[] { "AssemblyName", "TypeFullName" }, string.Format("FuncID='{0}'", SysConstManage.sdp_webdalbase));
dr = _dataAccess.GetDataRow(sql);
}
if (dr != null)
{
_assemblyNm = dr["AssemblyName"].ToString();
_typeNm = dr["TypeFullName"].ToString();
}
}
public virtual DataTable RptSearch(string dsid, string tbnm, string[] fields, string[] sumaryFields, List <LibSearchCondition> conds)
{
object[] values = { };
StringBuilder whereformat = new StringBuilder();
AnalyzeSearchCondition(conds, whereformat, ref values);
SDPCRL.DAL.COM.SQLBuilder sQLBuilder = null;
if (string.IsNullOrEmpty(dsid))
{
sQLBuilder = new SDPCRL.DAL.COM.SQLBuilder();
}
else
{
sQLBuilder = new SDPCRL.DAL.COM.SQLBuilder(dsid);
}
string sql = sQLBuilder.GetRptSQL(tbnm, fields, sumaryFields, new WhereObject {
WhereFormat = whereformat.ToString(), Values = values
});
return(this.DataAccess.GetDataTable(sql));
}
public virtual DataTable RptSearchByPage(string dsid, string tbnm, string[] fields, string[] sumaryFields, string groupfields, List <LibSearchCondition> conds, int pageindex, int pagesize)
{
object[] values = { };
StringBuilder whereformat = new StringBuilder();
AnalyzeSearchCondition(conds, whereformat, ref values);
SDPCRL.DAL.COM.SQLBuilder sQLBuilder = null;
if (string.IsNullOrEmpty(dsid))
{
sQLBuilder = new SDPCRL.DAL.COM.SQLBuilder();
}
else
{
sQLBuilder = new SDPCRL.DAL.COM.SQLBuilder(dsid);
}
//LibDSContext dSContext = new LibDSContext(dsid);
//string sql = dSContext.GetSQLByPage(tbnm, fields, new WhereObject { WhereFormat = whereformat.ToString(), Values = values }, pageindex, pagesize, true, false);
string sql = sQLBuilder.GetRptSQLByPage(tbnm, fields, sumaryFields, groupfields, new WhereObject {
WhereFormat = whereformat.ToString(), Values = values
}, pageindex, pagesize);
DataTable outtable = null;
DataSet dataSet = this.DataAccess.GetDataTables(sql);
outtable = dataSet.Tables[0];
foreach (DataColumn col in dataSet.Tables[1].Columns)
{
outtable.Columns.Add(col.ColumnName, col.DataType);
if (outtable != null && outtable.Rows.Count > 0)
{
outtable.Rows[0][col.ColumnName] = dataSet.Tables[1].Rows[0][col];
}
}
//DataTable dataTable = dataSet.Tables[1];
return(outtable);
}
