public void musteridoldur(string baseno)
{
txtOID.Text = baseno;
lblAktifMusteri.Visible = false;
lblManuelArama.Visible = false;
lblMusteriBilgileri.Visible = true;
String MusStr = "select /*+ parallel(1024)*/* from A36596.MICRO_MEMO_TEL where MUSTERI_NO= " + baseno;
DataTable dt = new DataTable();
try
{
dt = PCL.MsSQL_DBOperations.GetData(MusStr, "SqlConn");
// dt = PCL.Oracle_DBOperations.GetData(MusStr, "EDWConn", HttpContext.Current.Session["EDWuser"].ToString(), HttpContext.Current.Session["EDWpass"].ToString());
string val = MM.GetJSONString(dt);
ScriptManager.RegisterStartupScript(this, typeof(string), "JsVal", "var JSVal=" + val + ";", true);
ScriptManager.RegisterStartupScript(this, typeof(string), "jSON", "$(document).ready(function(){DOLDUR(0," + baseno + ");$('.header').sticky({topSpacing:0});})", true);
lblMusteriAnaBilgileri.Text = ORT_KEF(baseno);// Ortaklik(baseno) + "<hr>" + Kefillik(baseno);
}
catch (Exception ex)
{
dt = PCL.MsSQL_DBOperations.GetData(MusStr, "SqlConn");
string val = MM.GetJSONString(dt);
ScriptManager.RegisterStartupScript(this, typeof(string), "JsVal", "var JSVal=" + val + ";", true);
ScriptManager.RegisterStartupScript(this, typeof(string), "jSON", "$(document).ready(function(){DOLDUR(0," + baseno + ");$('.header').sticky({topSpacing:0});})", true);
lblMusteriAnaBilgileri.Text = ex.ToString() + ORT_KEF(baseno); // Ortaklik(baseno) + "<hr>" + Kefillik(baseno);
}
// lblMusteriBilgileri.Text = baseno;
/*
*
* TAŞINDI
* String MusStr = "select * from A36596.micro_memo_tel where MUSTERI_NO= " + baseno;
* DataTable dt = new DataTable();
* dt = PCL.Oracle_DBOperations.GetData(MusStr, "EDWConn", HttpContext.Current.Session["EDWuser"].ToString(), HttpContext.Current.Session["EDWpass"].ToString());
*
* string val= MM.GetJSONString(dt);
*/
// lblMusteriBilgileri.Text = MM.GetJSONString(dt);
}
public static string retJS(string SqlSTR)
{
MicroMain MM = new MicroMain();
String strRetVal = SqlSTR;
DataTable dt = new DataTable();
try
{
dt = PCL.MsSQL_DBOperations.GetData(SqlSTR, "SqlConn");
strRetVal = MM.GetJSONString(dt); //dt.Rows[0]["RV"].ToString().Trim();
}
catch (Exception ex)
{
strRetVal = "HATA @retJS()= " + ex.Message;
}
return(strRetVal);
}
protected void Page_Load(object sender, EventArgs e)
{
InitEDWUser();
Session["TOKEN"] = "-1";
try
{
if (String.IsNullOrEmpty(Session["TOKEN"].ToString()))
{
Response.Redirect("default.aspx");
}
}
catch { Response.Redirect("default.aspx"); }
#region giriş
D = false;
if (Request.QueryString["T"] == null)
{
tkn = "-1";
}
else if (MM.IsNumeric(Request.QueryString["T"]))
{
tkn = "-1";// Request.QueryString["T"].ToString();
}
else
{
tkn = "-1";
}
if (Session["TOKEN"].ToString() == tkn)
{
D = true;
}
if (Request.QueryString["I"] == null)
{
Islem = 0;
}
else if (MM.IsNumeric(Request.QueryString["I"]) && D)
{
Islem = PCL.Utility.UItoMT.ToInt16(Request.QueryString["I"].ToString());
D = true;
}
else
{
Islem = 0;
}
if (Request.QueryString["M"] == null)
{
M = 0;
D = false;
}
else if (MM.IsNumeric(Request.QueryString["M"]) && D)
{
M = PCL.Utility.UItoMT.ToInt32(Request.QueryString["M"].ToString());
D = true;
}
else
{
M = 0;
D = false;
}
#endregion
if (D && Islem == 0)
{
String MusStr = "select /*+ parallel(1024)*/* from A36596.MICRO_MEMO_TEL where MUSTERI_NO= " + M;
DataTable dt = new DataTable();
dt = PCL.Oracle_DBOperations.GetData(MusStr, "EDWConn", HttpContext.Current.Session["EDWuser"].ToString(), HttpContext.Current.Session["EDWpass"].ToString());
// dt = PCL.MsSQL_DBOperations.GetData(MusStr, "SqlConn");
string val = MM.GetJSONString(dt);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 1)
{
string val = "";
val = urunler(M);// "[{\"KART\":" + ccard(M) + "},{\"KREDI\":" + cashloan(M) + "},{\"KMH\":" + overdraft(M) + "}]";
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 2)
{
string val = "";
val = UYARI(M);// "[{\"KART\":" + ccard(M) + "},{\"KREDI\":" + cashloan(M) + "},{\"KMH\":" + overdraft(M) + "}]";
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 3)
{
string val = "";
val = TEMELBILGI(M);// "[{\"KART\":" + ccard(M) + "},{\"KREDI\":" + cashloan(M) + "},{\"KMH\":" + overdraft(M) + "}]";
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 4)
{
string val = "";
val = ADRES(M);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 5)
{
string val = "";
val = TELEFON(M);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 6)
{
Int32 TP;
if (Request.QueryString["TP"] == null)
{
TP = 5;
}
else if (MM.IsNumeric(Request.QueryString["TP"]))
{
TP = PCL.Utility.UItoMT.ToInt32(Request.QueryString["TP"].ToString());
}
else
{
TP = 5;
}
string val = "";
val = MEMOG(M, TP);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 7)
{
Int32 TP;
if (Request.QueryString["TP"] == null)
{
TP = 5;
}
else if (MM.IsNumeric(Request.QueryString["TP"]))
{
TP = PCL.Utility.UItoMT.ToInt32(Request.QueryString["TP"].ToString());
}
else
{
TP = 5;
}
string val = "";
val = MEMOO(M, TP);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 8)
{
string val = "";
val = TelAksList();
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 9)
{
string val = "";
val = UrnAksList();
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 10)
{
Int32 TP;
if (Request.QueryString["TP"] == null)
{
TP = 5;
}
else if (MM.IsNumeric(Request.QueryString["TP"]))
{
TP = PCL.Utility.UItoMT.ToInt32(Request.QueryString["TP"].ToString());
}
else
{
TP = 5;
}
string val = "";
val = MEMOF(M, TP);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 11)
{
Int64 TP;
if (Request.QueryString["TP"] == null)
{
TP = 5;
}
else if (MM.IsNumeric(Request.QueryString["TP"]))
{
TP = PCL.Utility.UItoMT.ToInt64(Request.QueryString["TP"].ToString());
}
else
{
TP = 5;
}
string val = "";
val = TelGecmis(M, TP);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 12)
{
string val = "";
val = MusteriSonucuList();
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 13)
{
string val = "";
val = DDLODEYEMEMEList();
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 14)
{
string val = "";
val = YYREDList();
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 15)
{
Int64 TP;
if (Request.QueryString["TP"] == null)
{
TP = 0;
}
else if (MM.IsNumeric(Request.QueryString["TP"]))
{
TP = PCL.Utility.UItoMT.ToInt64(Request.QueryString["TP"].ToString());
}
else
{
TP = 0;
}
string val = "";
val = EXT_TEL(M, TP);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 16)
{
string val = "";
val = MusAks();
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else if (D && Islem == 17)
{
Int32 TP;
if (Request.QueryString["TP"] == null)
{
TP = 0;
}
else if (MM.IsNumeric(Request.QueryString["TP"]))
{
TP = PCL.Utility.UItoMT.ToInt32(Request.QueryString["TP"].ToString());
}
else
{
TP = 0;
}
// fazladanmemo(Int32 M, Int32 TOP)
string val = "";
val = fazladanmemo(M, TP);
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
else
{
string val = "";
Response.Clear();
//Response.ContentType = "application/json; charset=utf-8";
Response.Write(val);
Response.End();
}
}