public MainMenu(Login form2) { Instance = this; InitializeComponent(); FaceCamera camera = new FaceCamera(); //初始化相机 if (!camera.Init()) { MessageBox.Show("面部识别库初始化失败!\n" + "点击确定关闭程序。", "人脸库失败", MessageBoxButtons.OK, MessageBoxIcon.Warning); System.Environment.Exit(0); } if (!SQLModel.InitDB()) { MessageBox.Show("数据库初始化失败!\n" + "点击确定关闭程序。", "人脸库失败", MessageBoxButtons.OK, MessageBoxIcon.Warning); System.Environment.Exit(0); } camera.Data.DataSource = DataAccess.DataSrcType.DataBase; camera.Data.InitDB(SQLEngine.Instance.Connection); camera.Data.LoadFaceData(null); camera.SpeechEnable = true; }
public IActionResult sql(SQLModel sql) { setAuth(); ResponseREST rs = new ResponseREST(); rs.ProcessRequestREST(Request, Response); sql.queryResults = "<h4>Results</h4>" + rs.getResult(); return(PartialView("sql", sql)); }
public IActionResult SQLDesc([FromQuery] SQLModel model) { return(new Result <string> { code = ErrorCodeConst.ERROR_200, status = ErrorCodeConst.ERROR_200, data = Common.AESDecrypt(model.str, model.guid) }); }
/// <summary> /// Edit User /// </summary> /// <param name="Data"></param> /// <returns></returns> public int EditUser(Dictionary <string, object> paramValues, string UserID) { SQLModel am = GetSQLModel("t_ccas_user", paramValues); if (!String.IsNullOrEmpty(UserID)) { am.UpdateSQL.Append(" UserID=@UserID "); paramValues.Add("@UserID", UserID); } return(Template.Execute(am.UpdateSQL.ToString(), paramValues)); }
public SQLModel GenerateModel() { SQLModel model = new SQLModel { Id = Guid.NewGuid(), Name = _names[new Random().Next(_names.Length)], Surname = _surnames[new Random().Next(_surnames.Length)], }; model.Email = model.Name + model.Surname + "@gmail.com"; return(model); }
/// <summary> /// Edit Group /// </summary> /// <param name="Data"></param> /// <returns></returns> public int EditGroup(Dictionary <string, object> paramValues, string groupID) { SQLModel am = GetSQLModel("t_ccas_group", paramValues); if (!String.IsNullOrEmpty(groupID)) { am.UpdateSQL.Append(" GroupID=@GroupID "); paramValues.Add("@GroupID", groupID); } return(Template.Execute(am.UpdateSQL.ToString(), paramValues)); }
public ContentResult SQLSearchTool(SQLModel sql) { ResponseREST rs = new ResponseREST(); rs.ProcessRequestREST(Request, Response); string content = rs.getResult(); string contentType = rs.getContentType(); return(new ContentResult { ContentType = contentType, Content = content }); }
/// <summary> /// Get AccessModel /// </summary> /// <param name="tableName">table Name</param> /// <param name="obj"> Insert , Update or Delete Data , type for Anonymous </param> /// <returns></returns> protected SQLModel GetSQLModel(string tableName, Dictionary <string, object> paramValues = null) { SQLModel model = new SQLModel(); StringBuilder paramStr = new StringBuilder(); StringBuilder valueStr = new StringBuilder(); StringBuilder setStr = new StringBuilder(); if (paramValues != null) { //允许插入空值 //var pvs = paramValues.Where(z => z.Value != null); var pvs = paramValues; foreach (var item in pvs) { string name = item.Key; object value = item.Value; //允许插入空值 //if (value == null) // continue; if (item.Key == pvs.Last().Key) { paramStr.Append(name); valueStr.Append("@" + name); setStr.Append(name + "=@" + name); } else { paramStr.Append(name + ','); valueStr.Append("@" + name + ','); setStr.Append(name + "=@" + name + ','); } } } model.InsertSQL = new StringBuilder(string.Format("insert into {0} ({1}) values ({2})", tableName, paramStr, valueStr)); model.DeleteSQL = new StringBuilder(string.Format("delete {0} where ", tableName)); model.UpdateSQL = new StringBuilder(string.Format("update {0} set {1} where IsDeleted = 0 and ", tableName, setStr)); model.UpdateCCASSQL = new StringBuilder(string.Format("update {0} set {1} where ", tableName, setStr)); model.DeleteCCASSQL = new StringBuilder(string.Format("update {0} set IsDeleted = 1 where IsDeleted = 0 and ", tableName)); return(model); }
public static SQLModel Map(Table table, SQLModel model, Enum.Language language) { model.Properties = getProperties(language, table.Columns); model.CSharpKeySignature = string.Join(", ", ( from k in model.KeyProperties select $"{ k.Type } { k.Name.LowerCamelCase }" )); model.CSharpKeyList = string.Join(", ", ( from k in model.KeyProperties select $"{ k.Name.LowerCamelCase }" )); model.CSharpKeyTypeList = string.Join(", ", ( from k in model.KeyProperties select $"{ k.Type }" )); model.SQLInsertSignature = getSQLInsertSignature(model.KeyProperties, model.NonKeyProperties); model.SQLUpdateSignature = string.Join(", ", ( from p in model.Properties where !ignoredProperties_Update.Contains(p.Name.Value) select $"@{ p.Name.LowerCamelCase } { getDataType(p) }" )); model.CSharpInsertCallSignature = getCSharpInsertCallSignature(model.KeyProperties, model.NonKeyProperties); model.CSharpUpdateCallSignature = string.Join(", ", ( from p in model.Properties where !ignoredProperties_Update.Contains(p.Name.Value) select $"@{ p.Name.Value }" )); model.CSharpKeyCallSignature = string.Join(", ", ( from p in model.KeyProperties select $"@{ p.Name.LowerCamelCase }" )); model.SQLPKSignature = getSQLPKSignature(model.Properties); model.SQLPKWhere = getSQLPKWhere(model.Properties); model.SQLSet = getSQLSet(model.Properties); return(model); }
public IActionResult sql() { setAuth(); SQLModel predefinedQuery = new SQLModel(); predefinedQuery.cmd = "-- This query does a table JOIN between the imaging (PhotoObj) and spectra\n"; predefinedQuery.cmd += "--(SpecObj) tables and includes the necessary columns in the SELECT to upload\n"; predefinedQuery.cmd += "--the results to the SAS(Science Archive Server) for FITS file retrieval.\n"; predefinedQuery.cmd += "SELECT TOP 10\n"; predefinedQuery.cmd += "p.objid,p.ra,p.dec,p.u,p.g,p.r,p.i,p.z,\n"; predefinedQuery.cmd += "p.run, p.rerun, p.camcol, p.field,\n"; predefinedQuery.cmd += "s.specobjid, s.class, s.z as redshift,\n"; predefinedQuery.cmd += "s.plate, s.mjd, s.fiberid\n"; predefinedQuery.cmd += "FROM PhotoObj AS p\n"; predefinedQuery.cmd += "JOIN SpecObj AS s ON s.bestobjid = p.objid\n"; predefinedQuery.cmd += "WHERE \n"; predefinedQuery.cmd += " p.u BETWEEN 0 AND 19.6\n"; predefinedQuery.cmd += " AND g BETWEEN 0 AND 20"; return(PartialView("sql", predefinedQuery)); }
public string BuildScript(int stringCount) { List <string> ScriptSource = new List <string>(); for (int i = 0; i <= stringCount; i++) { SQLModel model = GenerateModel(); ScriptSource.Add($"new DbProject " + $"{{ " + $"Id = Guid.NewGuid(), " + $"Name = \"{model.Name}\", " + $"Info = \"{model.Surname}\"" + //etc. $"}}"); } var result = string.Join(", \n", ScriptSource); var script = "builder.Entity<DbProject>().HasData(" + result + "); "; return(script); }