コード例 #1
0
ファイル: UserDal.cs プロジェクト: SoMeTech/SoMeRegulatory
 public override string GetLastStream(Page page, DB_OPT dbo)
 {
     string str = page.Request.Url.ToString();
     int startIndex = str.LastIndexOf("/") + 1;
     int num2 = str.LastIndexOf("?");
     string str2 = (num2 < 0) ? str.Substring(startIndex) : str.Substring(startIndex, num2 - startIndex);
     string strSql = "select distinct oper.serverpks from gov_tc_db_servicesmess ser left join gov_tc_db_sfproject sf on sf.PK=ser.taxfeecallectionpk left join gov_tc_db_taxfeekind tax on tax.pk=sf.TAXFEEKINDPK left join gov_tc_db_operation oper on oper.operationpk=ser.operationpk  where tax.pkpath=:path";
     OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("path", OracleType.VarChar, 100) };
     parameters[0].Value = str2;
     DataSet set = dbo.Query(strSql, parameters);
     if ((set.Tables.Count <= 0) || (set.Tables[0].Rows.Count <= 0))
     {
         return null;
     }
     string str4 = set.Tables[0].Rows[0]["serverpks"].ToString();
     int num3 = str4.LastIndexOf('|');
     string str5 = null;
     if (num3 >= 0)
     {
         str5 = str4.Substring(num3).Replace("|", "");
     }
     return str5;
 }