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; }
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); }
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); }