예제 #1
0
        /// <summary>
        /// 新增员工加扣款批量审核
        /// </summary>
        /// <param name="entity">员工加扣款批量审核实体</param>
        /// <returns></returns>
        public bool EmployeeAddSumBatchAdd(T_HR_EMPLOYEEADDSUMBATCH entity, string[] addsumids)
        {
            int i = 0;

            try
            {
                i = dal.Add(entity);
                if (i > 0)
                {
                    foreach (var id in addsumids)
                    {
                        var ents = from a in dal.GetObjects <T_HR_EMPLOYEEADDSUM>()
                                   where a.ADDSUMID == id
                                   select a;
                        if (ents.Count() > 0)
                        {
                            T_HR_EMPLOYEEADDSUM ent = ents.FirstOrDefault();
                            ent.CHECKSTATE = entity.CHECKSTATE;
                            string sql = "UPDATE T_HR_EMPLOYEEADDSUM T SET T.MONTHLYBATCHID = '" + entity.MONTHLYBATCHID + "'";
                            sql += " , T.CHECKSTATE = '" + entity.CHECKSTATE + "' WHERE T.ADDSUMID = '" + ent.ADDSUMID + "'";
                            EmployeeSalaryRecordBLL bll = new EmployeeSalaryRecordBLL();
                            bll.ExecuteSql(sql, "T_HR_EMPLOYEEADDSUM");
                            //EmployeeAddSumBLL bll = new EmployeeAddSumBLL();
                            //ent.T_HR_EMPLOYEEADDSUMBATCH = new T_HR_EMPLOYEEADDSUMBATCH();
                            //ent.T_HR_EMPLOYEEADDSUMBATCH.EntityKey =
                            //    new System.Data.EntityKey(qualifiedEntitySetName + "T_HR_EMPLOYEEADDSUMBATCH", "MONTHLYBATCHID", entity.MONTHLYBATCHID);
                            //bll.Update(ent);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                SMT.Foundation.Log.Tracer.Debug(ex.Message);
                ex.Message.ToString();
            }
            if (i > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }