/// <summary> /// 插入数据 /// </summary> /// <param name="roleFunctionEntities">数据实体</param> public static void BatchInserFunction(List <RoleFunctionEntity> roleFunctionEntities) { var cmd = new DataCommand("Function.BatchInserFunction"); cmd.CommandText = cmd.CommandText.Replace("#TEMPLATE#", cmd.GetTemporaryTableScript("templateTable", roleFunctionEntities)); cmd.ExecuteNonQuery(); }
public static void BatchInserArticleUser(List <ArticleUser> list) { var cmd = new DataCommand("Article.BatchInserArticleUser"); var temp = list.First(); var templateScript = cmd.GetTemporaryTableScript <ArticleUser>("LYYTEAMPLATE", list); cmd.SetParameter("@ArticleId", DbType.Int32, temp.ArticleId); cmd.CommandText = cmd.CommandText.Replace("#TEMPLATETABLE#", templateScript); cmd.ExecuteNonQuery(); }