public void ImportDepartmentPlanRank(DataTable data, List <DepartmentPlanRankValid> deptList)
{
List <t_department_plan_rank> list = new List <t_department_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 dept_name = row[2] + "";
var score = decimal.Parse(row[3] + "");
var validModel = deptList.Where(_ => _.dept_name.Equals(dept_name) && _.plan_name.Equals(plan_name)).FirstOrDefault();
//查询关联文档 判断关联文档与序号是否存在
t_department_plan_rank model = new t_department_plan_rank()
{
create_time = DateTime.Now,
department_id = validModel.dept_id.Value,
plan_id = validModel.plan_id.Value,
rank = rank,
score = score
};
list.Add(model);
}
InsertDepartmentPlanRank(list);
}
/// <summary>
/// 新增单位积分
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static int InsertDepartmentPlanRank(t_department_plan_rank entity)
{
DataCommand cmd = new DataCommand("Plan.InsertDepartmentPlanRank");
cmd.SetParameter(entity);
int result = cmd.ExecuteScalar <int>();
return(result);
}
