ASP.NET MVC用存储过程批量添加修改数据操作

public ActionResult MarketTaskAdd()
 {
 var markeType = new MarketDataProvider().GetBTIDData().Where(a=>a.ID!="0");//读取类别
 var rel = new MarketTaskProgressProvider().GetMarketMonthTask();
 if (rel.Count() > 0)
 {
 ViewBag.datas = rel.Join(markeType, a => a.MKBTID, b => int.Parse(b.ID), (a, b) => new { a.MKBTID, b.ID,b.Text,a.TaskNum }).Select(s=>new ViewsModel { ID= s.MKBTID.ToString() ,Text=s.Text,TaskNum=s.TaskNum.ToString()}); }//如果有数据关联数据
 else
 {
 var rel2 = markeType.Select(s => new ViewsModel{ ID = s.ID, Text = s.Text, TaskNum="" }).ToList();//直接返回表单
 ViewBag.datas = rel2;
 }
 return View();
 }

@foreach (var modelMarkets in ViewBag.datas)
 {
 <div class="row" style="margin-top:10px">
 <div class="col-md-4 text-right"><span class="red">*</span> @modelMarkets.Text </div>
 <div class="col-md-8 text-left">
 <input name="text|@modelMarkets.ID" class="form-control" style="width:50%" value="@modelMarkets.TaskNum" type="text" />
 <input type="hidden" name="type|@modelMarkets.ID" value="type|@modelMarkets.ID" /><!--隐藏表单-->
 </div>
 </div>
 }

[HttpPost]
 public ActionResult MarketTaskAdd(string type)
 {
 var strform = Request.Form;
 int userId = adminUser!=null?adminUser.UserID:0;//创建人或者修改人ID
 DataTable dt = new DataTable();
 dt.Columns.Add("MKBTID",Type.GetType("System.Int32"));
 dt.Columns.Add("TaskNum", Type.GetType("System.Int32"));
 List<string> temp1 = new List<string>();
 List<string> temp2 = new List<string>();
 for (int i = 0; i < strform.Count; i++)
 {
 if (strform[i].Contains("type"))
 { temp1.Add(strform[i].Split('|')[1]); }
 else
 { temp2.Add(strform[i]); }//循环分解表单
 }
 for (int i = 0; i < temp1.Count; i++)
 {
 DataRow dr = dt.NewRow();
 dr[0] = temp1[i];
 dr[1] = temp2[i];
 dt.Rows.Add(dr);//批量添加到datatable
 }
 var rel = new MarketTaskProgressProvider().MarketTaskAddOrEdit(userId,dt);//调用方法
 if(rel)
 ViewBag.js = "<script>alert('操作成功！');window.location.href='/MarketTaskProgress/MarketTaskAdd';</script>";
 else
 ViewBag.js = "<script>alert('操作失败！');window.location.href='/MarketTaskProgress/MarketTaskAdd';</script>";
 List<ViewsModel> listTemp = new List<ViewsModel>();
 listTemp.Add(new ViewsModel
 {
 ID = "",
 Text = "",
 TaskNum = ""
 });
 ViewBag.datas = listTemp;
 return View();
 }
 }

public bool MarketTaskAddOrEdit(int userId,DataTable dt)
 {
 using (DssEntity entity = new DssEntity())//不推荐用using
 {
 SqlParameter p = new SqlParameter("@CreatedUser",DbType.Int32);
 p.Value = userId;
 SqlParameter p1 = new SqlParameter("@tableMarketTask",DbType.Object);
 p1.Value = dt;
 p1.TypeName = "tableMarketTask";//参数处理，貌似自定义函数必须加这个函数名称
 var rel = entity.Database.ExecuteSqlCommand("EXEC[dbo].[PR_MarketTaskAddorEdit] @CreatedUser,@tableMarketTask", p,p1);//ef执行存储过程
 return rel > 0;
 }
 }

-- Create the data type
CREATE TYPE [dbo].[tableMarketTask] AS TABLE(
 [MKBTID] [varchar](50) NOT NULL,--投放类别
 [TaskNum] [varchar](50) NOT NULL--投放任务数量
)

CREATE PROCEDURE PR_MarketTaskAddorEdit
 @CreatedUser INT,
 @tableMarketTask tableMarketTask readonly --自定义类型的参数，必须加readonly。
AS
 DECLARE @TempCreatedUser INT
 IF EXISTS(SELECT TOP 1 * FROM MarketMonthTask T WHERE Months=MONTH(GETDATE()))--当月存在的话就修改
 BEGIN
 SELECT TOP 1 @TempCreatedUser=CreatedUser FROM MarketMonthTask T WHERE Months=MONTH(GETDATE())
 DELETE FROM MarketMonthTask WHERE Months=MONTH(GETDATE())
 INSERT INTO MarketMonthTask(MKBTID,TaskNum,Months,UpdateUser,CreatedUser) SELECT MKBTID,TaskNum,MONTH(GETDATE()),@CreatedUser,@TempCreatedUser FROM @tableMarketTask
 END
 ELSE--或者直接插入
 BEGIN
 INSERT INTO MarketMonthTask(MKBTID,TaskNum,Months,CreatedUser) SELECT MKBTID,TaskNum,MONTH(GETDATE()),@CreatedUser FROM @tableMarketTask
 END