Exemple #1
0
        /// <summary>
        /// 受理操作
        /// </summary>
        /// <param name="model"></param>
        /// <param name="errorMsg"></param>
        /// <returns></returns>
        public bool Audit(t_D_UserTableTen model, out string errorMsg)
        {
            using (var db = dbFactory.Open())
            {
                using (var dbTrans = db.OpenTransaction())
                {
                    try
                    {
                        errorMsg = string.Empty;

                        db.Insert(model, true);

                        db.UpdateOnly(new t_D_UserTableOne {
                            @static = 2
                        }, p => p.@static, p => p.id == model.pid);

                        dbTrans.Commit();
                        return(true);
                    }
                    catch (Exception ex)
                    {
                        dbTrans.Rollback();
                        errorMsg = ex.Message;
                        return(false);
                    }
                }
            }
        }
Exemple #2
0
        public ActionResult Distribute(DistributeExpertViewModels model)
        {
            ControllerResult result = ControllerResult.SuccResult;

            try
            {
                var zjsp1   = string.Empty;
                var zjsp2   = string.Empty;
                var experts = model.DistributedExpert.Split(',');
                if (experts.Count() == 1)
                {
                    zjsp1 = experts[0];
                }
                else if (experts.Count() == 2)
                {
                    zjsp1 = experts[0];
                    zjsp2 = experts[1];
                }

                var ude = new t_D_UserTableTen()
                {
                    id      = model.Id,
                    pid     = model.PID,
                    zjsp1   = zjsp1,
                    zjsp2   = zjsp2,
                    @static = 2
                };

                string errorMsg = string.Empty;
                if (!checkQualifyService.SaveDistributeExpert(ude, out errorMsg))
                {
                    result         = ControllerResult.FailResult;
                    result.ErroMsg = errorMsg;
                }
                else
                {
                    LogUserAction("对检测机构资质Id:{0} 分配专家:[{1}]".Fmt(model.Id, model.DistributedExpert));
                }
            }
            catch (Exception ex)
            {
                result         = ControllerResult.FailResult;
                result.ErroMsg = ex.Message;
            }

            return(Content(result.ToJson()));
        }
Exemple #3
0
        public ActionResult NoApproval(CBRUnitApprovalSaveModel model)
        {
            ControllerResult result = ControllerResult.SuccResult;

            try
            {
                var utt = new t_D_UserTableTen()
                {
                    id            = model.id,
                    ThreeYJ       = model.ThreeYJ,
                    ThreeFZr      = model.ThreeFZr,
                    ThreeZZZSBH   = model.ThreeZZZSBH,
                    ThreeTime     = DateTime.Now,
                    ThreeYXQBegin = model.ThreeYXQBegin,
                    ThreeYXQEnd   = model.ThreeYXQEnd,
                    pid           = model.pid,
                    cbr           = repUser.GetById(GetCurrentUserId()).UserDisplayName,
                    outstaticinfo = model.outstaticinfo,
                    @static       = 5 //审核不通过
                };

                string errorMsg = string.Empty;
                if (!checkQualifyService.SaveCBRUnitApproval(utt, out errorMsg))
                {
                    result         = ControllerResult.FailResult;
                    result.ErroMsg = errorMsg;
                }
                else
                {
                    LogUserAction("对检测机构资质Id:{0} 审批完成".Fmt(model.pid));
                }
            }
            catch (Exception ex)
            {
                result         = ControllerResult.FailResult;
                result.ErroMsg = ex.Message;
            }

            return(Content(result.ToJson()));
        }
Exemple #4
0
        /// <summary>
        /// 承办人审批
        /// </summary>
        /// <param name="saveModel"></param>
        /// <param name="errorMsg"></param>
        /// <returns></returns>
        public bool SaveCBRUnitApproval(t_D_UserTableTen saveModel, out string errorMsg)
        {
            using (var db = dbFactory.Open())
            {
                using (var dbTrans = db.OpenTransaction())
                {
                    try
                    {
                        errorMsg = string.Empty;
                        if (db.Select <t_D_UserTableTen>(r => r.id == saveModel.id).Count > 0)
                        {
                            db.UpdateOnly(saveModel, r => new
                            {
                                r.ThreeYJ,
                                r.ThreeFZr,
                                r.ThreeZZZSBH,
                                r.ThreeTime,
                                r.ThreeYXQBegin,
                                r.ThreeYXQEnd,
                                r.cbr,
                                r.@static,
                                r.outstaticinfo
                            }, r => r.id == saveModel.id);
                        }
                        else
                        {
                            db.Insert <t_D_UserTableTen>(saveModel);
                        }

                        db.UpdateOnly(new t_D_UserTableOne {
                            @static = saveModel.@static
                        }, p => p.@static, p => p.id == saveModel.pid);

                        //更新t_bp_custom表相关数据 证书、资质、有效期 同步到主表
                        var tbTwo = db.Select <t_D_UserTableTwo>(r => r.pid == saveModel.pid).FirstOrDefault();
                        if (tbTwo != null)
                        {
                            db.UpdateOnly(new t_bp_custom
                            {
                                BUSINESSNUM     = tbTwo.businessnum,
                                businessnumPath = tbTwo.businessnumpath,
                                BUSINESSNUMUNIT = tbTwo.businessnumunit,
                                ECONOMICNATURE  = tbTwo.economicnature,
                                MEASNUM         = tbTwo.measnum,
                                MEASNUMPATH     = tbTwo.measnumpath,
                                MEASUNIT        = tbTwo.measunit,
                                zzlbmc          = tbTwo.sqjcyw,
                                detectappldate  = saveModel.ThreeYXQBegin,
                                measnumEndDate  = saveModel.ThreeYXQEnd
                            }, r => new
                            {
                                r.BUSINESSNUM,
                                r.businessnumPath,
                                r.BUSINESSNUMUNIT,
                                r.ECONOMICNATURE,
                                r.MEASNUM,
                                r.MEASNUMPATH,
                                r.MEASUNIT,
                                r.zzlbmc,
                                r.detectappldate,
                                r.measnumEndDate
                            }, r => r.ID == tbTwo.unitcode);
                        }


                        dbTrans.Commit();
                        return(true);
                    }
                    catch (Exception ex)
                    {
                        dbTrans.Rollback();
                        errorMsg = ex.Message + ex.StackTrace;
                        return(false);
                    }
                }
            }
        }
Exemple #5
0
        /// <summary>
        /// 分配专家
        /// </summary>
        /// <param name="model"></param>
        /// <param name="errorMsg"></param>
        /// <returns></returns>
        public bool SaveDistributeExpert(t_D_UserTableTen model, out string errorMsg)
        {
            using (var db = dbFactory.Open())
            {
                using (var dbTrans = db.OpenTransaction())
                {
                    try
                    {
                        errorMsg = string.Empty;

                        int needUnitBuildingQualify = 0; //是否需要填写 建设工程质量检测资质机构审核表
                        int needSpecialQualify      = 0; //是否需要填写 专项检测备案审核表
                        var tbTwo = repTwo.GetByCondition(r => r.pid == model.pid).FirstOrDefault();
                        if (tbTwo != null)
                        {
                            if (tbTwo.sqjcyw.IndexOf("地基基础工程检测") >= 0 ||
                                tbTwo.sqjcyw.IndexOf("主体结构工程现场检测") >= 0 ||
                                tbTwo.sqjcyw.IndexOf("建筑幕墙工程检测") >= 0 ||
                                tbTwo.sqjcyw.IndexOf("钢结构工程检测") >= 0 ||
                                tbTwo.sqjcyw.IndexOf("见证取样检测") >= 0)
                            {
                                needUnitBuildingQualify = 1;
                            }

                            if (tbTwo.sqjcyw.IndexOf("室内环境质量检测") >= 0 ||
                                tbTwo.sqjcyw.IndexOf("建筑附属设备安装工程检测") >= 0)
                            {
                                needSpecialQualify = 1;
                            }
                        }

                        //先删除之前分配的专家
                        repExp.DeleteByCondition(r => r.pid == model.pid);

                        if (!string.IsNullOrEmpty(model.zjsp1))
                        {
                            var ueu = new t_D_UserExpertUnit();
                            ueu.userid  = Convert.ToInt32(model.zjsp1);
                            ueu.pid     = Convert.ToInt32(model.pid);
                            ueu.addtime = DateTime.Now;
                            ueu.status  = 0;
                            ueu.needUnitBuildingQualify = needUnitBuildingQualify;
                            ueu.needSpecialQualify      = needSpecialQualify;

                            db.Insert(ueu, true);
                        }

                        if (!string.IsNullOrEmpty(model.zjsp2))
                        {
                            var ueu = new t_D_UserExpertUnit();
                            ueu.userid  = Convert.ToInt32(model.zjsp2);
                            ueu.pid     = Convert.ToInt32(model.pid);
                            ueu.addtime = DateTime.Now;
                            ueu.status  = 0;
                            ueu.needUnitBuildingQualify = needUnitBuildingQualify;
                            ueu.needSpecialQualify      = needSpecialQualify;

                            db.Insert(ueu, true);
                        }

                        //更新
                        db.UpdateOnly(new t_D_UserTableOne {
                            @static = 3
                        }, p => p.@static, p => p.id == model.pid);
                        db.UpdateOnly(model, r => new
                        {
                            r.zjsp1,
                            r.zjsp2,
                            r.@static
                        }, r => r.id == model.id);

                        dbTrans.Commit();
                        return(true);
                    }
                    catch (Exception ex)
                    {
                        dbTrans.Rollback();
                        errorMsg = ex.Message;
                        return(false);
                    }
                }
            }
        }