public NewErrorModel Save(CURDModel cURDModel)
{
try
{
if (cURDModel != null && cURDModel.SaveModels != null && cURDModel.SaveModels.Count > 0)
{
int iCount = 0;
using (DDContext dataContext = new DDContext())
{
SqlHelper sqlHelper = new SqlHelper();
foreach (var item in cURDModel.SaveModels)
{
List <TableInfo> tableInfos = dataContext.TableInfo.Where(t => t.TableID ==
dataContext.Tables.Where(s => s.TableName == item.TableName).FirstOrDefault().ID
).ToList();
string strSql = sqlHelper.Insert(item, tableInfos);
int iResult = dataContext.Database.ExecuteSqlCommand(strSql);
if (iResult != 1)
{
return(new NewErrorModel()
{
error = new Error(1, $"{item.TableName} 格式有误,插入失败！", "")
{
},
});
}
else
{
iCount += iResult;
}
}
}
return(new NewErrorModel()
{
count = iCount,
error = new Error(0, $"批量插入成功！共计插入:{iCount.ToString()}条数据", "")
{
},
});
}
else
{
return(new NewErrorModel()
{
error = new Error(1, "参数有误！", "")
{
},
});
}
}
catch (Exception)
{
throw;
}
}
public NewErrorModel Read(CURDModel cURDModel)
{
try
{
if (cURDModel != null && cURDModel.SaveModels != null && cURDModel.SaveModels.Count > 0)
{
DDContext dataContext = new DDContext();
SqlHelper sqlHelper = new SqlHelper();
if (cURDModel.SaveModels.Count == 1) //单表
{
foreach (var item in cURDModel.SaveModels)
{
List <TableInfo> tableInfos = dataContext.TableInfo.Where(t => t.TableID ==
dataContext.Tables.Where(s => s.TableName == item.TableName).FirstOrDefault().ID
).ToList();
string strSql = sqlHelper.Read(item, tableInfos);
DataTable result = SqlAdoHelper.ExecuteDataTable(strSql);
//List<TestTable> testTables = dataContext.Database.SqlQuery<TestTable>(strSql).ToList();
//var results = dataContext.Database.SqlQuery<object>(strSql).ToList();
//dynamic result = dataContext.Database.SqlQuery<object>(strSql).ToList();
return(new NewErrorModel()
{
data = result,
error = new Error(0, $"{item.TableName} 读取成功！", "")
{
},
});
}
}
else //多表
{
}
}
else
{
return(new NewErrorModel()
{
error = new Error(1, "参数有误！", "")
{
},
});
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public NewErrorModel Delete(CURDModel cURDModel)
{
try
{
if (cURDModel != null && cURDModel.SaveModels != null && cURDModel.SaveModels.Count > 0)
{
int iCount = 0;
using (DDContext dataContext = new DDContext())
{
SqlHelper sqlHelper = new SqlHelper();
foreach (var item in cURDModel.SaveModels)
{
string strSql = sqlHelper.Delete(item);
int iResult = dataContext.Database.ExecuteSqlCommand(strSql);
if (iResult == 0)
{
return(new NewErrorModel()
{
error = new Error(1, $"{item.TableName} 格式有误或者Id不存在,数据删除失败！", "")
{
},
});
}
else
{
iCount += iResult;
}
}
}
return(new NewErrorModel()
{
count = iCount,
error = new Error(0, $"批量删除成功！共计删除:{iCount.ToString()}条数据 ", "")
{
},
});
}
else
{
return(new NewErrorModel()
{
error = new Error(1, "参数有误！", "")
{
},
});
}
}
catch (Exception)
{
throw;
}
}
