[HttpPost]
public string request([FromBody] object obj)
{
string tableName = "";
string data = "";
result rs = new result();
if (obj == null)
{
rs.code = "0";
rs.msg = "请求格式有误";
return JsonConvert.SerializeObject(rs);
}
using (var db = DbContext.getInstance())
{
try
{
JObject j = JObject.Parse(obj.ToString());
try
{
tableName = j["tableName"].ToString();
}
catch (System.NullReferenceException e)
{
rs.code = "0";
rs.msg = "缺少表名";
return JsonConvert.SerializeObject(rs);
}
try
{
data = j["data"].ToString();
}
catch (System.NullReferenceException e)
{
rs.code = "0";
rs.msg = "缺少数据";
return JsonConvert.SerializeObject(rs);
}
List<Dictionary<string, object>> list = JsonConvert.DeserializeObject<List<Dictionary<string, object>>>(data);
db.BeginTran();
foreach (Dictionary<string, object> item in list)
{
db.Insertable(item).AS(tableName).ExecuteCommand();
}
db.CommitTran();
rs.code = "1";
rs.msg = "success";
return JsonConvert.SerializeObject(rs);
}
catch (Exception e)
{
db.RollbackTran();
rs.code = "0";
rs.msg = e.Message;
return JsonConvert.SerializeObject(rs);
}
}
}
-----------------------------
public class result
{
public string code { get; set; }
public string msg { get; set; }
}