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()); }