/// <summary>
/// 批量新增
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="t"></param>
/// <param name="cols">选择性插入的字段</param>
/// <returns></returns>
public bool InsertBatch <T>(List <T> list, string cols, bool needReturn)
{
List <CommandInfo> commandInfos = new List <CommandInfo>();
if (list == null || list.Count <= 0)
{
return(false);
}
CommandInfo commandInfo = null;
SqlModel insertModel = null;
for (int i = 0; i < list.Count; i++)
{
insertModel = CreateSqlHelper.InsertSql(list[i], cols, needReturn);
commandInfo = new CommandInfo()
{
CommendText = insertModel.Sql,
IsProcess = false,
Params = insertModel.SqlParameters
};
commandInfos.Add(commandInfo);
}
return(SQLiteHelper.ExecuteTrans(commandInfos));
}
/// <summary>
/// 新增
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="cols">选择性插入的字段</param>
/// <param name="t"></param>
/// <returns></returns>
public int Insert <T>(T t, string cols, bool needReturn)
{
if (t == null)
{
return(0);
}
SqlModel insertModel = CreateSqlHelper.InsertSql(t, cols, needReturn);
if (!needReturn)
{
return(SQLiteHelper.ExecuteNonQuery(insertModel.Sql, needReturn, insertModel.SqlParameters));
}
object resultObj = SQLiteHelper.ExecuteScalar(insertModel.Sql, false, insertModel.SqlParameters);
if (resultObj != null && resultObj.ToString() != "")
{
return(Convert.ToInt32(resultObj));
}
return(0);
}