Ejemplo n.º 1
0
        protected override void ExecuteChild(ASAUDITCUTDATEMST dataReq, ResponseAPI dataRes)
        {
            var res = new AsFixedAsset();

            //var obj = ASSETKKF_ADO.Mssql.Asset.AsFixedAssetAdo.GetInstant().Search(new ASSETKKF_MODEL.Data.Mssql.Asset.AsFixedAsset() { OFFICECODE = dataReq.OFFICECODE.Trim() });
            //if (obj == null) { throw new Exception("ไม่พบข้อมูล"); }

            //res.AsFixedAssetLST = obj;
            //dataRes.data = res;
        }
Ejemplo n.º 2
0
        public int AuditCancel(AsFixedAsset d, SqlTransaction transac = null, string conStr = null)
        {
            DynamicParameters param = new DynamicParameters();

            sql  = " EXEC [SP_AUDITCANCEL]  ";
            sql += " @SQNO  = '" + d.SQNO + "'";
            sql += " ,@COMPANY = '" + d.COMPANY + "'";
            sql += " ,@USERID = '" + d.INPID + "'";


            var res = ExecuteNonQuery(sql, param, conStr);

            return(res);
        }
Ejemplo n.º 3
0
        private TrackOfflineRes addPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null)
        {
            try
            {
                ASSETKKF_MODEL.Data.Mssql.Asset.AsFixedAsset req1 = new AsFixedAsset()
                {
                    ASSETNO = dataReq.assetno
                };

                AsFixedAsset asset = ASSETKKF_ADO.Mssql.Asset.AsFixedAssetAdo.GetInstant().Search(req1, null, conStr).FirstOrDefault();
                if (asset != null)
                {
                    dataReq.assetname = asset.ASSETNAME;
                }



                var obj = InsertTrackPostMST(dataReq, conStr);
                if (obj.Result > 0)
                {
                    res._result._code    = "200";
                    res._result._message = "";
                    res._result._status  = "OK";
                }
                else
                {
                    res._result._code    = "400";
                    res._result._message = "พบความผิดพลาดระหว่างประมวลผลข้อมูล " + obj.Result.ToString();
                    res._result._status  = "Bad Request";
                }
            }
            catch (Exception ex)
            {
                res._result._code    = "500 ";
                res._result._message = ex.Message;
                res._result._status  = "Internal Server Error";
            }

            return(res);
        }