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