public int InsertQuery(bool isPrefixTableName = false)
{
var tablename = Url("_tablename");
if (isPrefixTableName)
{
tablename = APPCommon.GetWTableName(tablename);
}
var obj = QueryToDic(tablename);
return(DB.Kata.Query(tablename).Insert(obj));
}
public int InsertForm(bool isPrefixTableName = false)
{
var tablename = Form("_tablename");
var obj = FormToDic(tablename);
if (isPrefixTableName)
{
tablename = APPCommon.GetWTableName(tablename);
}
return(InsertDic(tablename, obj));
}
public int UpdateForm(bool isPrefixTableName = false)
{
var tablename = Form("_tablename");
var id = Form("_id").ToInt();
var obj = FormToDic(tablename);
if (isPrefixTableName)
{
tablename = APPCommon.GetWTableName(tablename);
}
Logger.LogInfo(nameof(UpdateForm), $"UpdateForm {tablename} dic {obj.ToJson() }");
return(Update(tablename, id, obj));
}
public Dictionary <string, object> FormToDic(string tablename, bool isprefixtableName = false)
{
if (isprefixtableName)
{
tablename = APPCommon.GetWTableName(tablename);
}
var cols = DB.UniClient.DbMaintenance.GetColumnInfosByTableName(tablename);
Dictionary <string, object> dic = new Dictionary <string, object>();
foreach (var cinfo in cols)
{
if (cinfo.DbColumnName.ToLower() != "id" && FormCollection.ContainsKey(cinfo.DbColumnName))
{
dic.Add(cinfo.DbColumnName, FormCollection[cinfo.DbColumnName]);
}
}
return(dic);
}