public bool SaveFindMast(IEnumerable <EM_MasterOperation> entity)
{
try
{
using (var db = DbBase.CreateDbBase())
{
string baseSql = @"INSERT INTO EM_MasterOperation (
OpreDate,
GroupName,
GroupNameUrl,
OpreType,
ZhengQuanName,
ZhengQuanNameUrl,
MasterType,
MasterRate,
RiRate,
DealWinCnt,
WinCntRate,
ManageName,
ManageNameUrl
)
VALUES
(
@OpreDate ,@GroupName ,@GroupNameUrl ,@OpreType ,@ZhengQuanName ,@ZhengQuanNameUrl ,
@MasterType ,@MasterRate ,@RiRate ,@DealWinCnt ,@WinCntRate ,@ManageName ,@ManageNameUrl )";
var result = db.InsertMultiple <EM_MasterOperation>(baseSql, entity);
if (result == 0)
{
return(false);
}
LogUtility.LogAction(string.Format(@"成功入库{0}条", result));
return(true);
}
////实体批量插入
//using (var db = DbBase.CreateDbBase())
//{
// var result = db.InsertBatch<EM_MasterOperation>(entity.ToList(), true);
// return result;
//}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 获取最后一条数据，用于停车点
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public List <EM_MasterOperation> LastFindMast()
{
try
{
using (var db = DbBase.CreateDbBase())
{
string baseSql = @"select * from em_masteroperation t order by t.OpreDate desc limit 1";
var result = db.DbConnecttion.Query <EM_MasterOperation>(baseSql);
if (result == null)
{
return(null);
}
return(result.ToList());
}
}
catch (Exception ex)
{
return(null);
}
}