Beispiel #1
0
        protected override void ExecuteChild(AuditCutReq dataReq, ResponseAPI dataRes)
        {
            var res = new AuditCutListRes();

            try
            {
                DBMode = dataReq.DBMode;
                res._result.ServerAddr = ConnectionString();
                res._result.DBMode     = DBMode;

                var obj = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().GetAuditCutLists(dataReq, null, conString);
                if (obj == null)
                {
                    res._result._code    = "404";
                    res._result._message = "ไม่พบข้อมูล";
                    res._result._status  = "Not Found";
                }
                else
                {
                    res._result._code    = "200";
                    res._result._message = "";
                    res._result._status  = "OK";
                }

                res.auditCutNoLst = obj;
            }
            catch (SqlException ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Execute exception Error";
            }
            catch (InvalidOperationException ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Connection Exception Error";
            }
            catch (Exception ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Internal Server Error";
            }

            dataRes.data = res;
        }
Beispiel #2
0
        protected override void ExecuteChild(AuditCutReq dataReq, ResponseAPI dataRes)
        {
            var res = new AuditCutListRes();

            try
            {
                DBMode = dataReq.DBMode;
                res._result.ServerAddr = ConnectionString();
                res._result.DBMode     = DBMode;

                var req = new ASSETKKF_MODEL.Request.Asset.AuditCutReq()
                {
                    Company  = dataReq.Company,
                    DeptCode = dataReq.DeptCode,
                    DeptLST  = dataReq.DeptLST,
                    Menu3    = dataReq.Menu3,
                    Menu4    = dataReq.Menu4,
                };

                List <ASSETKKF_MODEL.Response.Asset.AuditCutList> obj = new List <ASSETKKF_MODEL.Response.Asset.AuditCutList>();

                if (!String.IsNullOrEmpty(dataReq.MODE) && dataReq.MODE.ToLower().Equals("rd"))
                {
                    obj = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAuditDepList2(dataReq, null, conString);
                }
                else
                {
                    obj = ASSETKKF_ADO.Mssql.Asset.AuditCutADO.GetInstant().getAuditDepList(dataReq, null, conString);
                }


                if (obj == null)
                {
                    res._result._code    = "404";
                    res._result._message = "ไม่พบข้อมูล";
                    res._result._status  = "Not Found";
                }
                else
                {
                    res._result._code    = "200";
                    res._result._message = "";
                    res._result._status  = "OK";
                }

                res.auditCutNoLst = obj;
            }
            catch (SqlException ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Execute exception Error";
            }
            catch (InvalidOperationException ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Connection Exception Error";
            }
            catch (Exception ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Internal Server Error";
            }

            dataRes.data = res;
        }