/// <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); }