protected void Page_Load(object sender, EventArgs e)
{
NorthwindContext context = new NorthwindContext();
var empList = context.Employees.OrderBy(c => c.FirstName).ToList();
RptData.DataSource = empList;
RptData.DataBind();
}
private void loadRepeater()
{
var proc = "Select Id,UserName,Password from AppUser ";
var dt = new DataTable();
dt = u.ReturnTable(proc);
var objPds = new PagedDataSource();
var objDataView = new DataView(dt);
objPds.DataSource = objDataView;
objPds.AllowPaging = true;
objPds.PageSize = 10;
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
objPds.CurrentPageIndex = CurPage - 1;
lblCurrentPage.Text = "Page: " + CurPage.ToString();
if (!objPds.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath
+ "?Page=" + Convert.ToString(CurPage - 1);
}
if (!objPds.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath
+ "?Page=" + Convert.ToString(CurPage + 1);
}
RptData.DataSource = objPds;
RptData.DataBind();
}
public static bool PrintTaskDtlList(DataSet dsRpt, string sysTile, string sConditon)
{
frmReportView view = new frmReportView {
Text = "任务清单报表"
};
rptTaskList list = new rptTaskList();
RptData data = new RptData();
try
{
data.Tables.Clear();
data.Tables.Add(dsRpt.Tables["tbTaskDtlList"].Copy());
data.AcceptChanges();
list.SetDataSource(data);
if (list.ParameterFields["SystemName"] != null)
{
list.SetParameterValue("SystemName", sysTile);
}
if (list.ParameterFields["Condition"] != null)
{
list.SetParameterValue("Condition", sConditon);
}
view.rptViewer.ReportSource = list;
view.ShowDialog();
list.Dispose();
view.Dispose();
return(true);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
if (list != null)
{
list.Dispose();
}
if (view != null)
{
view.Dispose();
}
return(false);
}
}
/// <summary>
/// 根据数据名称获取数据
/// </summary>
/// <param name="p_name">数据名称</param>
/// <returns></returns>
public async Task <RptData> GetData(string p_name)
{
if (_dataSet.TryGetValue(p_name, out var data))
{
return(data);
}
RptDataSourceItem srcItem;
if (Root == null || (srcItem = Root.Data.GetDataSourceItem(p_name)) == null)
{
return(null);
}
Table tbl = null;
if (srcItem.IsScritp)
{
// 通过脚本获取数据源
if (ScriptObj != null)
{
tbl = await ScriptObj.GetData(p_name);
}
else
{
Kit.Warn($"未定义报表脚本，无法获取数据【{p_name}】");
}
}
else
{
tbl = await AtRpt.Query(srcItem.Srv, srcItem.Sql, Params);
}
if (tbl != null)
{
var rptData = new RptData(tbl);
_dataSet[p_name] = rptData;
return(rptData);
}
return(null);
}
private void BindData()
{
// get database name
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AbleCommerce"].ConnectionString);
string dbName = con.Database;
// build query
StringBuilder queryStr = new StringBuilder();
queryStr.Append("DECLARE @SPWHO2 TABLE (SPID VARCHAR(1000), [Status] VARCHAR(1000) NULL, [Login] VARCHAR(1000) NULL");
queryStr.Append(", HostName VARCHAR(1000) NULL, BlkBy VARCHAR(1000) NULL, DBName VARCHAR(1000) NULL, Command VARCHAR(1000) NULL");
queryStr.Append(", CPUTime VARCHAR(1000) NULL, DiskIO VARCHAR(1000) NULL, LastBatch VARCHAR(1000) NULL, ProgramName VARCHAR(1000) NULL");
queryStr.Append(", SPID2 VARCHAR(1000) NULL, Request VARCHAR(1000) NULL) ");
queryStr.Append("INSERT INTO @SPWHO2 EXEC sp_who2");
if (ActiveOnly.Checked)
{
queryStr.Append(" 'Active' ");
}
queryStr.Append(" SELECT * FROM @SPWHO2 WHERE DBName = :dbName");
var nhQuery = NHibernateHelper.CreateSQLQuery(queryStr.ToString())
.SetString("dbName", dbName);
// execute query
var results = nhQuery.List();
// parse results
IList <RptData> finalData = new List <RptData>();
foreach (object[] resultRow in results)
{
RptData row = new RptData();
row.Spid = (string)resultRow[0];
row.Status = (string)resultRow[1];
row.Login = (string)resultRow[2];
row.HostName = (string)resultRow[3];
row.BlkBy = (string)resultRow[4];
row.DbName = (string)resultRow[5];
row.Command = (string)resultRow[6];
row.CPUTime = (string)resultRow[7];
row.DiskIO = (string)resultRow[8];
row.LastBatch = (string)resultRow[9];
row.ProgramName = (string)resultRow[10];
row.SPID2 = (string)resultRow[11];
row.Request = (string)resultRow[12];
finalData.Add(row);
}
ConnectionsGrid.DataSource = finalData;
ConnectionsGrid.DataBind();
// summarize data
ConnectionsCount.Text = finalData.Count.ToString();
if (Session["LastCount"] != null)
{
int lastCount = AlwaysConvert.ToInt(Session["LastCount"], 0);
int diff = finalData.Count - lastCount;
Changed.Text = diff.ToString();
}
else
{
Changed.Text = "n/a";
}
Session["LastCount"] = finalData.Count.ToString();
}