本文整理汇总了C#中System.Data.DataSet.TryGet方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.TryGet方法的具体用法?C# DataSet.TryGet怎么用?C# DataSet.TryGet使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.TryGet方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Index
//.........这里部分代码省略.........
selectClause.AppendLine(@"GROUP BY S0.SYSID,S0.MBLNO,S0.BILLDATE,S0.ETD,S0.POL,S0.POD,S0.BSSRCID,S0.BILLNO,S0.ACCYEAR,S0.ACCMONTH,SOURCE");
selectClause.AppendLine(@"UNION");
selectClause.AppendLine(@"SELECT COALESCE(SUM(SC1.FCYAMT) -((MIN(P1.V20)* SUM(BQ201.CNTRQTY))");
selectClause.AppendLine(@"+(MIN(P1.V40)* SUM(BQ401.CNTRQTY))");
selectClause.AppendLine(@"+(MIN(P1.V40HQ)* SUM(BQ40HQ1.CNTRQTY))),0) EXPECT");
selectClause.AppendLine(@",S1.SYSID,S1.MBLNO,S1.BILLDATE,S1.ETD,S1.POL,S1.POD,S1.BSSRCID,S1.BILLNO,S1.ACCYEAR,S1.ACCMONTH,'箱贴' SOURCE");
selectClause.AppendLine(@"FROM PRICEMNGGENLEGITEMS P1");
selectClause.AppendLine(@"LEFT JOIN SEABILLS S1 ON S1.SYSID=P1.SYSID AND S1.EXSALESID=P1.USERID AND S1.POLID=S1.POLID AND S1.PODID=S1.PODID AND S1.CARRIERID=P1.CARRIERID");
selectClause.AppendLine(@"LEFT JOIN BSCNTRQTY BQ201 ON BQ201.SYSID=S1.SYSID AND BQ201.ENTITYID=S1.ENTITYID");
selectClause.AppendLine(@"LEFT JOIN CNTRS CN201 ON CN201.SYSID=S1.SYSID AND CN201.CNTRID=BQ201.CNTRTYPEID");
selectClause.AppendLine(@"LEFT JOIN BSCNTRQTY BQ401 ON BQ401.SYSID=S1.SYSID AND BQ401.ENTITYID=S1.ENTITYID");
selectClause.AppendLine(@"LEFT JOIN CNTRS CN401 ON CN401.SYSID=S1.SYSID AND CN401.CNTRID=BQ401.CNTRTYPEID");
selectClause.AppendLine(@"LEFT JOIN BSCNTRQTY BQ40HQ1 ON BQ40HQ1.SYSID=S1.SYSID AND BQ40HQ1.ENTITYID=S1.ENTITYID");
selectClause.AppendLine(@"LEFT JOIN CNTRS CN40HQ1 ON CN40HQ1.SYSID=S1.SYSID AND CN40HQ1.CNTRID=BQ40HQ1.CNTRTYPEID");
selectClause.AppendLine(@"LEFT JOIN SEABILLSITEMS SC1 ON SC1.SYSID=S1.SYSID AND SC1.ENTITYID=S1.ENTITYID AND SC1.DC='C'");
selectClause.AppendLine(@"LEFT JOIN ITEMS IC1 ON IC1.SYSID=S1.SYSID AND IC1.ITEMID=SC1.ITEMID");
selectClause.AppendLine(@"LEFT JOIN WEB_LOGINUSERS U1 ON U1.SYSID=S1.SYSID AND U1.USERID=S1.EXSALESID");
selectClause.AppendLine(@"WHERE S1.SYSID=1 AND IC1.ITEMNO='OF' AND P1.CREATEDATE<=S1.BILLDATE AND P1.INUREFROM<=S1.BILLDATE AND P1.INURETO>=S1.BILLDATE");
selectClause.AppendLine(@"AND [email protected] AND S1.BILLDATE BETWEEN @STARTDATE AND @ENDDATE");
selectClause.AppendLine(@"GROUP BY S1.SYSID,S1.MBLNO,S1.BILLDATE,S1.ETD,S1.POL,S1.POD,S1.BSSRCID,S1.BILLNO,S1.ACCYEAR,S1.ACCMONTH,SOURCE)");
selectClause.AppendLine(@"GROUP BY SYSID,EXPECT,MBLNO,BILLDATE,ETD,POL,POD,BSSRCID,BILLNO,ACCYEAR,ACCMONTH,SOURCE");
selectClause.AppendLine(@"ORDER BY BILLDATE DESC");
#endregion
#region 取计提和箱贴明细的统计数量
var countClause = selectClause.ToString().Replace("SELECT *", "SELECT COUNT(SYSID) ");
#endregion
//由于此页面逻辑较为复杂,这里使用标准ADO.NET方式处理数据查询
//定义局部变量
Decimal expectProfit = 0.0M;//预计利润
Decimal expectCntr = 0.0M;//预计箱贴
int totalRows = 0;
//开始计算分页
Double totalPages = Math.Ceiling((Double)totalRows / pageSize);//总页数,Ceiling向上取整
int rowStart = (pageIndex - 1) * pageSize + 1;
int rowEnd = pageSize * pageIndex;
selectClause.AppendLine("ROWS @ROWSTART TO @ROWEND ");
parameters.Add(client.CreateParameter("@ROWSTART", rowStart));
parameters.Add(client.CreateParameter("@ROWEND", rowEnd));
//准备连接
System.Data.IDbConnection conn = client.CreateDbConnection(false);
var expectProfitCommand = client.CreateDbCommand(expectProfitClause.ToString(), parameters, conn);
var expectCntrCommand = client.CreateDbCommand(expectCntrClause.ToString(), parameters, conn);
var countCommand = client.CreateDbCommand(countClause.ToString(), parameters, conn);
var selectCommand = client.CreateDbCommand(selectClause.ToString(), parameters, conn);
DataSet dataSet = new DataSet();
conn.Open();//打开连接
var __expect_profit = expectProfitCommand.ExecuteScalar();
if (__expect_profit != null)
{
try
{
expectProfit = Convert.ToDecimal(__expect_profit);
}
catch { expectProfit = 0.0M; }
}
var __expect_cntr = expectCntrCommand.ExecuteScalar();
if (__expect_cntr != null)
{
try
{
expectCntr = Convert.ToDecimal(__expect_cntr);
}
catch { expectCntr = 0.0M; }
}
var __count = countCommand.ExecuteScalar();
if (__count != null)
{
try
{
totalRows = Convert.ToInt32(__count);
}
catch { totalRows = 0; }
}
var adapter = client.CreateAdapter(selectCommand);
adapter.Fill(dataSet);
var entities = dataSet.TryGet().GetDynamicCollection();
if(conn!=null && conn.State!= ConnectionState.Closed)
{
conn.Close();
}
var pager = Pager.Create(totalPages, "/Performance/Home/Index?pageIndex={{pageIndex}}&pageSize={{pageSize}}", pageIndex, pageSize);
ViewBag.AccYears = entities.Select(x => x.AccYear).Distinct();
ViewBag.AccMonths = entities.Select(x => x.AccMonth).Distinct();
ViewBag.ExpectProfit = expectProfit;
ViewBag.ExpectCntr = expectCntr;
ViewBag.SealongUserName = sealongusername;
ViewBag.Pager = pager;
return View(entities);
}