/// <summary>
/// 导入处理人积分
/// </summary>
/// <param name="data"></param>
/// <param name="deptList"></param>
/// <param name="planList"></param>
public void ImportUserPlanRank(DataTable data, List <UserPlanRankValid> planList)
{
List <t_user_plan_rank> list = new List <t_user_plan_rank>();
foreach (System.Data.DataRow item in data.Rows)
{
var row = item.ItemArray;
var plan_name = row[0] + "";
var rank = int.Parse(row[1] + "");
var user_name = row[2] + "";
var score = decimal.Parse(row[3] + "");
//查询关联文档 判断关联文档与序号是否存在
var validModel = planList.Where(_ => _.user_name.Equals(user_name) && _.plan_name.Equals(plan_name)).FirstOrDefault();
t_user_plan_rank model = new t_user_plan_rank()
{
create_time = DateTime.Now,
user_id = validModel.user_id,
plan_id = validModel.plan_id.Value,
rank = rank,
score = score
};
list.Add(model);
}
InsertUserPlanRank(list);
}
/// <summary>
/// 新增处理人积分
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static int InsertUserPlanRank(t_user_plan_rank entity)
{
DataCommand cmd = new DataCommand("Plan.InsertUserPlanRank");
cmd.SetParameter(entity);
int result = cmd.ExecuteScalar <int>();
return(result);
}
