public SqlDatabase(string connectionString, Dbs dbEnum)
{
switch (dbEnum)
{
case Dbs.MainDb:
Set(connectionString, System.Data.CommandType.StoredProcedure);
break;
case Dbs.LogDb:
SetLog(connectionString, System.Data.CommandType.StoredProcedure);
break;
}
}
static void Main()
{
Dbs.GetSession();
Login login = new Login();
login.ShowDialog();
if (login.IsLogin)
{
login.Close();
Application.EnableVisualStyles();
Application.Run(new Principal());
}
}
public String Delete_Role(int id)
{
String sql = "proc_Delete_Role '" + id + "'";
int result = Dbs.ExecuteNonQuery(sql);
if (result == 1)
{
ViewBag.saveStatus = 1;
// return 1;
String tip = "success";
//return RedirectToAction("Basci_faq");
return(tip);
}
else
{
ViewBag.saveStatus = 0;
String tip = "Fail";
return(tip);
//return Content("<script>alert('no');history.go(-1);</script>");
}
}
/// <summary>
/// 逻辑删除 post 数据格式类似为 { primaryKey: 1,2 }
/// </summary>
/// <returns></returns>
public string Delete()
{
string json = GetPostData();
DynamicJson dj = GetParam();
JMI jmi = GetJMI(dj);
if (!dj.IsList && !dj.GetStr(JModelNo.AccessSaveListKey).IsNullOrEmpty())
{
dj = dj.Get(JModelNo.AccessSaveListKey).ToJson().ToDynamicJson();
if (!jmi.TBCode.IsNullOrWhiteSpace())
{
foreach (DynamicJson djItem in dj)
{
djItem.Set(JModelNo.AccessTableKey, jmi.TBCode);
}
}
}
using (DBAccessor dba = DBAccessor.Instance(Dbs.Get(jmi.DbsName)))
{
return(OnSave(dj, dba, true));
}
}
public ActionResult Edit_Role(List <String> Role_manage)
{
string ID = Role_manage[0];
//string UserName = Role_manage[1];
string Password = Role_manage[1];
string Role = Role_manage[2];
string RealName = Role_manage[3];
string Phone = Role_manage[4];
string DepartNum = Role_manage[5];
//string newUserName = Leach(UserName);
string newPassword = Leach(Password);
string newRole = Leach(Role);
string newRealName = Leach(RealName);
string newPhone = Leach(Phone);
string newDepartNum = Leach(DepartNum);
String sql = "exec proc_Update_Role_Manage '" + ID + "','" + newPassword + "','" + newRole + "','" + newRealName + "','" + newPhone + "','" + newDepartNum + "'";
int result = Dbs.ExecuteNonQuery(sql);
if (result == 1)
{
ViewBag.saveStatus = 1;
// return 1;
String tip = "Success";
return(JavaScript(tip));
}
else
{
ViewBag.saveStatus = 0;
String tip = "Fail";
return(JavaScript(tip));
//return Content("<script>alert('no');history.go(-1);</script>");
}
}
public async Task Invoke(HttpContext context, SuiteACWeb_Api_DbContext suiteCFDI_DBContext)
{
try
{
//string authHeader = context.Request.Headers["Authorization"];
//if (authHeader != null && authHeader.StartsWith("Basic"))
//{
// //Extract credentials
// string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim();
// Encoding encoding = Encoding.GetEncoding("iso-8859-1");
// var usernamePassword = encoding.GetString(Convert.FromBase64String(encodedUsernamePassword));
// int seperatorIndex = usernamePassword.IndexOf(':');
// var username = usernamePassword.Substring(0, 9);
// var password = usernamePassword.Substring(seperatorIndex + 1);
// if (true) //check if your credentials are valid
// {
// MasterDbContext.ConnectionString = "connection"; //_masterContext.Retrive Your subscriber connection string here
// if (string.IsNullOrEmpty(MasterDbContext.ConnectionString))
// {
// //no authorization header
// context.Response.StatusCode = 401; //Unauthorized
// return;
// }
// await _next.Invoke(context);
// }
// else
// {
// context.Response.StatusCode = 401; //Unauthorized
// return;
// }
//}
//else
//{
// // no authorization header
// context.Response.StatusCode = 401; //Unauthorized
// return;
//}
//Identificar el Tenant
string Header = context.Request.Headers["Postman-Token"];
HttpRequest request = context.Request;
string path = request.Path;
string[] parts = path.Split('/');
string lic = parts[1];
string conn = @"Server=|server|;Database=|db|;Trusted_Connection=False;user id=|userId|;password=|userPsw|;ConnectRetryCount=0";
Bitacora bit = new Bitacora();
Instancias inst = solControl_db.Instancias.Where(a => a.Licencia == lic).FirstOrDefault();
if (inst == null)
{
//no tenant header
bit.Descripcion = string.Format("Recuperar la instancia con Licencia '{0}'", lic);
bit.Evento = "API01";
bit.Fecha = DateTime.Now;
bit.Mensaje = string.Format("Instancia null. Licencia: {0}", lic);
bit.Tipo = "I";
bit.Usuario = "System";
solControl_db.Add(bit);
solControl_db.SaveChanges();
context.Response.StatusCode = 401; //Not Found
return;
//conn = @"Server=mssql.consulteam.mx;Database=scfdi_plenty;Trusted_Connection=False;user id=scfdi_plenty_admin;password=1z2x3c.CC;ConnectRetryCount=0";
//SuiteCFDI_DbContext.ConnectionString = conn;
//await _next.Invoke(context);
}
//Construir Connection
Dbs db = solControl_db.Dbs.Find(inst.IdDb);
if (db == null)
{
//Base de datos no enciontrada
bit.Descripcion = string.Format("Recuperar la base de datos '{0}'", inst.IdDb);
bit.Evento = "API02";
bit.Fecha = DateTime.Now;
bit.Mensaje = string.Format("IdDb null. Licencia: {0}, DB: {1}", lic, inst.IdDb);
bit.Tipo = "I";
bit.Usuario = "System";
solControl_db.Add(bit);
solControl_db.SaveChanges();
context.Response.StatusCode = 402; //Not Found
return;
//conn = @"Server=mssql.consulteam.mx;Database=scfdi_plenty;Trusted_Connection=False;user id=scfdi_plenty_admin;password=1z2x3c.CC;ConnectRetryCount=0";
//SuiteCFDI_DbContext.ConnectionString = conn;
//await _next.Invoke(context);
}
conn = conn.Replace("|server|", db.Server);
conn = conn.Replace("|db|", db.IdDb);
conn = conn.Replace("|userId|", db.Usuario);
conn = conn.Replace("|userPsw|", db.Psw);
//string conn = string.Empty;
//if (tenant == "plenty")
// conn = @"Server=mssql.consulteam.mx;Database=scfdi_plenty;Trusted_Connection=False;user id=scfdi_plenty_admin;password=1z2x3c.CC;ConnectRetryCount=0";
//if (tenant == "cteam")
// conn = @"Server=mssql.consulteam.mx;Database=scfdi_cteam;Trusted_Connection=False;user id=scfdi_cteam_admin;password=4f5g6h.HH;ConnectRetryCount=0";
//MasterDbContext.TenantName = tenant;
SuiteCFDI_DbContext.ConnectionString = conn;
bit.Descripcion = string.Format("Establecer connection string para Licencia '{0}'", lic);
bit.Evento = "API00";
bit.Fecha = DateTime.Now;
bit.Mensaje = string.Format("Connection String '{0}'", conn);
bit.Tipo = "I";
bit.Usuario = "System";
solControl_db.Add(bit);
solControl_db.SaveChanges();
await _next.Invoke(context);
}
catch (Exception e)
{
// no authorization header
e.ToString();
context.Response.StatusCode = 400;
Bitacora bit = new Bitacora();
bit.Descripcion = string.Format("Excepción en 'MiddleWare '{0}'", "");
bit.Evento = "API00";
bit.Fecha = DateTime.Now;
bit.Mensaje = string.Format("Error: {0}", e.ToString());
bit.Tipo = "E";
bit.Usuario = "System";
solControl_db.Add(bit);
solControl_db.SaveChanges();
return;
}
}
protected IStatelessSession GetSession()
{
return(Dbs.GetSession());
}
