循环插入时,必须在循环体内实例化要插入的对象。否则提示:“不能添加已经存在的实体”
public bool ImportToPool()
{
DataTable dt = ImportExcel();
//return DAL.SmsPoolService.ImportFromDataBable(dt);
////SmsPool Pool = new SmsPool();
////Pool.ApplyID = this.ApplyID;
////Pool.NetOperationID = 0;
////Pool.PriorityLevel = 0;
////Pool.CheckFlag = "未操作";
////Pool.CheckContentFlag = "未操作";
string[] numArr = this.Numbers.Trim(',').Split(',');
//Pool.SrcNumbers = this.Numbers;
//Pool.ObjNum = "";
//Pool.SmsContent = "";
//Pool.SmsCount = 0;
DAL.SmsPoolService PoolSvs = new SmsPoolService();
////SmsPool Pool = new SmsPool();//不能添加已经存在的实体
for (int i = 0; i < dt.Rows.Count; i++)
{
//DAL.SmsPoolService PoolSvs = new SmsPoolService();
SmsPool Pool = new SmsPool();
Pool.ApplyID = this.ApplyID;
Pool.NetOperationID = 0;
Pool.PriorityLevel = 0;
Pool.CheckFlag = "未操作";
Pool.CheckContentFlag = "未操作";
Pool.SrcNum = numArr[i%numArr.Length];
Pool.ObjNum = dt.Rows[i][0].ToString();
Pool.SmsContent = dt.Rows[i][1].ToString();
Pool.SmsCount =(int) Math.Ceiling((Pool.SmsContent.Length * 0.1) / MyConst.SmsMaxCharCount);
PoolSvs.Insert(Pool);
}
return true;
}