private string TelGecmis(Int32 M, Int64 T)
{
string val;
string strSql = "SELECT T.UID SİCİL,DBO.MCR_FN_AKSACIKLAMA(result) AKSİYON,T.DT TARİH from [dbo].[MCR_TBL_TELAKSIYON] T WHERE tel='" + T + "' order by dt DESC";
try
{
DataTable dt = new DataTable();
//DEV İÇİN dt = PCL.Oracle_DBOperations.GetData(strSql, "EDWConn", HttpContext.Current.Session["EDWuser"].ToString(), HttpContext.Current.Session["EDWpass"].ToString());
dt = PCL.MsSQL_DBOperations.GetData(strSql, "SqlConn");
val = MM.ConvertDataTable2HTMLString("SqlConn", "TELHIST", strSql);
}
catch (Exception ex)
{
val = "[{\"WARNING\":\"" + ex.Message + "\"}]";
}
return(val);// sb.ToString();
}
public string Ortaklik(string b)
{
return("<h3>" + b + " Numaralı Base'e Bağlı Ortaklık Bilgileri</h3>" + MM.ConvertDataTable2HTMLString("EDWConn", "ORTAK", "SELECT /*+ parallel(4)*/ A.ORTAK_CUST_ID,A.PRTNR_PRCNTG ORTAKLIK_YUZDE,E.SCND_NM||' '||E.NM ISIM,E.SURNM from MUSTERI_ORTAK_DATA_1 a,edw.ind e where A.ORTAK_CUST_ID=E.CUST_ID(+) and a.CUST_ID='" + b + "'"));
}